RE: 9i OCP Details

2003-06-25 Thread Bart Kersteter
if you take the 8i exams 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 i

RE: SORT_AREA_SIZE question

2003-06-25 Thread Bart Kersteter
using it, otherwise you can look directly in the dictionary 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

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 exam

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 o