SORT_AREA_SIZE question

2003-06-25 Thread Bart Kersteter
Hello, I joined this list last week, so I apologize in advance if I'm asking a question that has previously been answered. I am responsible for a reporting database/data mart that is approximately 175 GB. Our main fact table ranges from 1-14 GB depending upon how far along we are into our

Re: 9i OCP Details

2003-06-25 Thread Bart Kersteter
Hi Senthil, I am in the same boat as you. I have worked with Oracle for about 7 years but am finally getting going on my OCP work. Since all of the older Oracle Ed. courses I took are no longer valid, I will probably submit to the New Features Course as well. You can take all of the exams

RE: SORT_AREA_SIZE question

2003-06-25 Thread Bart Kersteter
views to determine proper sizing of PGA, shared pool, and buffer cache. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message-From: Bart Kersteter [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 10:39 AMTo: Multiple recipients

RE: 9i OCP Details

2003-06-25 Thread Bart Kersteter
first and the 9i upgrade exam even without the courses. -Original Message-From: Bart Kersteter [mailto:[EMAIL PROTECTED]Sent: Wednesday, June 25, 2003 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Re: 9i OCP Details Hi Senthil, I am in the same boat as you. I