RE: 9i OCP Details
That may be the case... however, since my employer pays for training but I am on the hook for the exams, it makes sense in my situation to go for the 9i cert. Bart >>> [EMAIL PROTECTED] 06/25/03 02:50PM >>> What? My understanding is that you can be certified for 9i 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 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 first, but my understanding is that Oracle won't issue you the actual certification until you've taken one of their authorized classes. I personally see no reason to certify for 8i even though I work with both 8i and 9i databases. HTH Bart >>> [EMAIL PROTECTED] 06/25/03 10:59AM >>>Hi Group,I wanted to do my 9i OCP. I have not taken any of the 8i OCP exams.To do 9i Exams directly I need to attend module 3 or 4 or New features from any of the Oracle Edu Partners.Shall I take 9i New features and go ahead with the 9i exams.Suggestion are appreciated.ThanksSenthil.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Senthil Kumar D INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you
RE: SORT_AREA_SIZE question
Sorry... I'm using 9.0.1.4 I will look into PGA_AGGREGATE_TARGET. Thanks, Bart >>> [EMAIL PROTECTED] 06/25/03 10:24AM >>> You didn't specify which version of Oracle you are using, but if it's 9i then you should investigate the use of pga_aggregate_target instead of the older sort_area parameters. I've been using pga_aggregate_target in a hybrid OLTP/reporting database for about 8 months with great results. Mine is set to 100 MB. You'll get the benifit of the memory advice feature of 9i as well. Have a look at OEM if you're 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: Wednesday, June 25, 2003 10:39 AMTo: Multiple recipients of list ORACLE-LSubject: SORT_AREA_SIZE question 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 financial year. I have large reports that run full table scans on this table daily. In an effort to keep as much of the sorting in memory as possible I have specified SORT_AREA_SIZE to be 100MB. Some of the tuning books I am reading now are making me second-guess myself and I am wondering if this is overkill. Can anyone provide some advice on how large they are setting their SORT_AREA_SIZE values for their DSS systems? Thanks in advance, Bart Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you
Re: 9i OCP Details
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 first, but my understanding is that Oracle won't issue you the actual certification until you've taken one of their authorized classes. I personally see no reason to certify for 8i even though I work with both 8i and 9i databases. HTH Bart >>> [EMAIL PROTECTED] 06/25/03 10:59AM >>>Hi Group,I wanted to do my 9i OCP. I have not taken any of the 8i OCP exams.To do 9i Exams directly I need to attend module 3 or 4 or New features from any of the Oracle Edu Partners.Shall I take 9i New features and go ahead with the 9i exams.Suggestion are appreciated.ThanksSenthil.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Senthil Kumar D INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you
SORT_AREA_SIZE question
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 financial year. I have large reports that run full table scans on this table daily. In an effort to keep as much of the sorting in memory as possible I have specified SORT_AREA_SIZE to be 100MB. Some of the tuning books I am reading now are making me second-guess myself and I am wondering if this is overkill. Can anyone provide some advice on how large they are setting their SORT_AREA_SIZE values for their DSS systems? Thanks in advance, Bart Please NoteThe information in this E-mail message is legally privilegedand confidential information intended only for the use of theindividual(s) named above. If you, the reader of this message,are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward thisE-mail message. If you have received this E-mail in error,please notify the sender. Thank you