Re: Reality check for filesystem/disk layout
Hi, Since it seems that your data can be loaded again easily via night batch load, why not consider noarchivelog mode? SAME is better than your disk partition policy ,I think. You have limited number of disk, seperate your limited number of disks for dedicated redo/archive maybe is not a good idear. And using outer part of the disk maybe become much more complicated when raid is in use.Do you know the underlying raid policy? Another possible solution I will consider is put redo on mirrored disk(2 disks) and everything else on raid5. This max the daily read performance and does not affect the nightly loading.Archive log is not relavant to performance of read and loading,unless archive process is unable to catch the speed of redo generation.I won't put valuable disk resource to archivelog. Zhu Chao. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 7:19 AM Sure. Our only real problem on this box comes from our large batch loads, especially at the end of the month when we get huge amounts of redo (it usually takes about a week to finish loading the month's data - the only time batch processing doesn't finish overnight). To make matters worse as soon as some tables are loaded reports start being generated off them while other tables are still being loaded. Redo activity is pretty constant at that time with frequent log switches. Since as soon a redo log fills up a) the previous redo log is read b) an archive log is written separating out the archive logs and ever other redo log seems like the best way to minimize io contention for redo. Of course ideally they'd be on their own disks but that's not feasible. I'm playing around a little more by putting the temp filesystem separate from the redo logs just because I know the large reports are a sore point with our production department that runs the data loads and I think this will reduce the delays for end of month loads/reports. Since the outer part of the disk is fastest I put the stuff that's acessed most often there (a trick I learned from a consultant SA we had a few years ago who was the most database/oracle knowledgeable unix SA I've ever met - I really regretted it when the company went through a cost savings period and cancelled his contract). Jay Miller Sr. Oracle DBA x68355 -Original Message- Sent: Friday, September 26, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Jay, I'd like to see (for my enlightenment) a brief rationale for your decisions, if you have time. Thanks! --- [EMAIL PROTECTED] wrote: We have the luxury of moving a 300G database to a new box that's being built and choosing the specifications, disk layout, striping, etc. After spending the morning poring over Cary Millsap's wonderful VLDB paper this is what we're thinking of but I'd appreciate any comments. One of my main goals going in was separating redo logs into 2 sets of disks and archive logs on a third. We have 16 disks to play with and seem to be winning the 1+0 battle against some SAs who don't understand why we wouldn't want to use RAID5. The database has minimal write activity during the day (other than sorts to the temp tablespace) but huge batch write activity at night and especially at the end of the month (the data load time is enough of a problem that the few partitioned tables we can easily reload are doing unrecoverable loads). There is a lot of read activity during the day, both single row queries from front ends that are rolled out to several thousand people and reports that can do some large sort/merge joins. Here's what we were thinking: 1st Disk Set - 4 72M disks RAID 1+0 1st and 3rd redo log on outside Misc. Datafiles in middle Misc scripts and files used by other departments in center 2nd Disk Set - 6 72M disks RAID 1+0 Archive logs on outside Temp tablespace and misc. datafiles in middle Text files used for loading in center 3rd Disk Set - 6 72M disks RAID 1+0 2nd and 4th redo logs on outside Rollback tablespace and misc datafiles in middle /oracle (executables and some scripts) in center I was debating if there was any advantage in varying stripe sizes across the different disk sets (since I know Cary says redo logs like fine grained stripe sizes) but given the mix of uses for each that doesn't seem viable. Comments, suggestions or even productive questioning of my sanity would be appreciated. Thanks, Jay Miller = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul
RE: guidance
Conversely, on *my* 30min drives to school with my Dad, his advice was: Why don't you take the bloody bus! :-) --- Cary Millsap [EMAIL PROTECTED] wrote: How can I say this... Don't confuse learning how to pass the performance tuning exam with learning how to make systems faster. I'll offer you my Dad's advice on this, which he reiterated frequently on our 30-minute drives to and from school: There are two answers to every question your teachers will ask you while you're in school. There's the correct answer, and there's the answer that the teacher wants. I expect you to know them both. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Thanks O'mladen one. No really, thanks , good advice. I am really going hyper about performance tuning exam. The course is so vast, and the exam so expensive. Honestly how can you test a newbie in performance tuning ? shouldn't it be a part of ocm ? Instead of putting that riduculous condition of attending Oracle classes to give ocp they should see how much experience you have before allowing you to appear for performance tuning exam. I would be much more prepared for the exam if I had apprenticed under you for a while. Look at me I haven't even read Cary's book ( wait a minute , neither have many people on this list , thanks to amazon) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:09 Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: guidance List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: guidance
:-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) To BOTH answers below! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED] Sent: Sat 9/27/2003 7:34 AM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: guidance Conversely, on *my* 30min drives to school with my Dad, his advice was: Why don't you take the bloody bus! :-) --- Cary Millsap [EMAIL PROTECTED] wrote: How can I say this... Don't confuse learning how to pass the performance tuning exam with learning how to make systems faster. I'll offer you my Dad's advice on this, which he reiterated frequently on our 30-minute drives to and from school: There are two answers to every question your teachers will ask you while you're in school. There's the correct answer, and there's the answer that the teacher wants. I expect you to know them both. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Thanks O'mladen one. No really, thanks , good advice. I am really going hyper about performance tuning exam. The course is so vast, and the exam so expensive. Honestly how can you test a newbie in performance tuning ? shouldn't it be a part of ocm ? Instead of putting that riduculous condition of attending Oracle classes to give ocp they should see how much experience you have before allowing you to appear for performance tuning exam. I would be much more prepared for the exam if I had apprenticed under you for a while. Look at me I haven't even read Cary's book ( wait a minute , neither have many people on this list , thanks to amazon) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:09 Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: guidance List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or
Re: Solaris /etc/system values for Oracle8i
What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 2:54 AM Mario: If you are using Solaris with 2GB of memory, it will be awfully difficult, if not impossible, to run 6 instances of Oracle8i simultaneously. Basically, because of the use of semaphores and the way Solaris manages memory, I would say you could run 3 or 4 instances , depending on their size. But to have all six up and running, especially if you have to create them, will not work. Oracle usually needs 1 GB per instance while you are creating a database. While running it, you would not necessarily need that much. I advice you to upgrade the memory on the server to 8 GB. I suggest you budget 1 GB per Oracle instance. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] .xerox.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Solaris /etc/system values for Oracle8i m 09/26/2003 06:19 PM Please respond to ORACLE-L Hi managers. I need modify /etc/systems parameters in my e450 box, it allow 6 instances for oracle 8i Box have 2 GB in RAM Next values are valid??? SHMMAX 0.5*(physical memory present in machine) SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an Oracle database on the system. SEMMNS Set to the sum of the PROCESSESparameter for each Oracle database except the largest one, plus 2 timesthe largest PROCESSES value, plus 10 times the number of Oracle databases. SEMOPM 100 SEMVMX 32767 Mario Henley Becerril Geldis * (52) +55 5326 3200 ext. 1588 * [EMAIL PROTECTED] System Administrator ___ sunmanagers mailing list [EMAIL PROTECTED] http://www.sunmanagers.org/mailman/listinfo/sunmanagers -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Becerril, Mario Henley INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris /etc/system values for Oracle8i
Precisely! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 28, 2003 12:54 AM What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 2:54 AM If you are using Solaris with 2GB of memory, it will be awfully difficult, if not impossible, to run 6 instances of Oracle8i simultaneously. Basically, because of the use of semaphores and the way Solaris manages memory, I would say you could run 3 or 4 instances , depending on their size. But to have all six up and running, especially if you have to create them, will not work. Oracle usually needs 1 GB per instance while you are creating a database. While running it, you would not necessarily need that much. I advice you to upgrade the memory on the server to 8 GB. I suggest you budget 1 GB per Oracle instance. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Top (=10) Issues faced by Oracle DBAs Deploying in a
As an Oracle DBA , I have no problems putting my Databases on SANs [yes, we have seperate SANs, from different vendors]. However, I find that Storage and Unix Admin skill requirements for a SAN seem to be higher. When Clustered servers access the SAN, it seems to be even more difficult to get an additional mount point made available to the DBA. Hemant At 10:59 AM 25-09-03 -0800, you wrote: Fellow Listers, If you don't deal with Oracle databases on SAN/NAS environments, this posting may not interest you. If so, my apologies, please delete this. Otherwise, please read on. In an effort to better understand what issues you face when deploying an Oracle database in a SAN/NAS environment, I am writing to you to get some real life feedback. Although I have a fair idea, where some of the pain lies, it would be much more valuable if you could tell me. Kind of like From the horse's mouth..;-) And I truly meant that as a compliment...:-) My goal is to fully understand where the real pain lies, so that appropriate solutions can be built to alleviate or even eliminate the pain. You can be as broad or narrow in your responses using the following topics as guidelines: * Initial SAN/NAS Configuration for Database Creation and Application Deployment * Ongoing Storage Volume Management in a SAN/NAS * Ongoing Storage Administration (Growth, Resizing) * Performance Optimization Troubleshooting * Things that require automation * Anything else you think is important that I have missed I do really appreciate you taking the time to put your feedback in black and white. Those of you who take the time and effort to provide feedback, will be entered in a raffle to for some T-shirts and other freebies. Oh, BTW, when you do send your response, please provide your full contact information, so that I know where to mail the goodies. In the interest of not flooding the list, please send me your feedback directly to [EMAIL PROTECTED] As a courtesy to my fellow listers, I will collate all responses and post a summary in the near future. You can count on me to do that. Best regards, Gaja = Gaja Krishna Vaidyanatha| E-Mail: [EMAIL PROTECTED] Principal Technical Product Manager | Phone: (650)-527-3180 Application Performance Management | Web: http://www.veritas.com Veritas Corporation | __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris /etc/system values for Oracle8i
That's what I said. :) I gotta go check my database I ran under Linux under VMware on my laptop. Maybe it didn't get created at all, I dreamed it all up! -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED] Sent: Sat 9/27/2003 10:54 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Solaris /etc/system values for Oracle8i What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 27, 2003 2:54 AM Mario: If you are using Solaris with 2GB of memory, it will be awfully difficult, if not impossible, to run 6 instances of Oracle8i simultaneously. Basically, because of the use of semaphores and the way Solaris manages memory, I would say you could run 3 or 4 instances , depending on their size. But to have all six up and running, especially if you have to create them, will not work. Oracle usually needs 1 GB per instance while you are creating a database. While running it, you would not necessarily need that much. I advice you to upgrade the memory on the server to 8 GB. I suggest you budget 1 GB per Oracle instance. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] .xerox.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Solaris /etc/system values for Oracle8i m 09/26/2003 06:19 PM Please respond to ORACLE-L Hi managers. I need modify /etc/systems parameters in my e450 box, it allow 6 instances for oracle 8i Box have 2 GB in RAM Next values are valid??? SHMMAX 0.5*(physical memory present in machine) SHMMIN 1 SHMMNI 100 SHMSEG 10 SEMMNI 100 SEMMSL Set to 10 plus the largestinitsid.ora PROCESSES parameter of an Oracle database on the system. SEMMNS Set to the sum of the PROCESSESparameter for each Oracle database except the largest one, plus 2 timesthe largest PROCESSES value, plus 10 times the number of Oracle databases. SEMOPM 100 SEMVMX 32767 Mario Henley Becerril Geldis * (52) +55 5326 3200 ext. 1588 * [EMAIL PROTECTED] System Administrator ___ sunmanagers mailing list [EMAIL PROTECTED] http://www.sunmanagers.org/mailman/listinfo/sunmanagers -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Becerril, Mario Henley INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). winmail.dat
Re: guidance
My dad never drove me to school. We didn't have cars in Denmark back in those days. I learned to survive. By the age of 12 I had studied and understood the excellent book Godfather by Mario Puzo, and implemented the organisational structure described in that manual in my class (5th grade). I was the lawyer. I think that might explain the difference between me and Cary today. And yes, my father was in the Military. No need to drive your sons to school. Mogens Caffrey, Melanie wrote: :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) :-) To BOTH answers below! -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED] Sent: Sat 9/27/2003 7:34 AM To: Multiple recipients of list ORACLE-L Cc: Subject: RE: guidance Conversely, on *my* 30min drives to school with my Dad, his advice was: Why don't you take the bloody bus! :-) --- Cary Millsap [EMAIL PROTECTED] wrote: How can I say this... Don't confuse learning how to pass the performance tuning exam with learning how to make systems faster. I'll offer you my Dad's advice on this, which he reiterated frequently on our 30-minute drives to and from school: There are two answers to every question your teachers will ask you while you're in school. There's the correct answer, and there's the answer that the teacher wants. I expect you to know them both. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Thanks O'mladen one. No really, thanks , good advice. I am really going hyper about performance tuning exam. The course is so vast, and the exam so expensive. Honestly how can you test a newbie in performance tuning ? shouldn't it be a part of ocm ? Instead of putting that riduculous condition of attending Oracle classes to give ocp they should see how much experience you have before allowing you to appear for performance tuning exam. I would be much more prepared for the exam if I had apprenticed under you for a while. Look at me I haven't even read Cary's book ( wait a minute , neither have many people on this list , thanks to amazon) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 03:09 Realx and feel the force. Only if you open your mind, you can master the force. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 5:05 PM To: Multiple recipients of list ORACLE-L Subject: guidance List , I am planning to give my 9i performance tuning exam on the first . Any advice you all want to give me ? Pretty nervous about it. Sure would appreciate your guidance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only.