If I install statspack, I always 'fix' the STATS$IDLE_EVENT table, and also change the varibale top_n_events to 10 (from 5) in spreport.sql. Statspack is a very generic tool. One must 'tune' it to reflect ones environment...
:) - Kirti --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Dan, > > You said that very well (as usual). The problem is that Management doesn't > usually see the downside of their downsizing actions until the stuff hits > the fan. And Larry's statements about self-tuning databases are not helping > as well - they help apply pressure on a dwindling market, whether real or > apparent. The ability to communicate complex problems in simple, everyday > language will _always_ stand you in good stead - whether to the business, to > management or your fellow workers. I recently replied patiently without > sarcasm to a question on an internal Java user group about why compiling > procedures/packages when users are online is a bad idea - I could have been > rude and told the largerly development audience off. The VP of Development > was on that list (I didn't know about this) and wrote me a nice > complimentary note. I hope to stand well when there is a shake-up later on > :) > > On Idle events - I had a situation previously when I was remotely diagnosing > a performance issue and noticed a large number of PQ related "idle" events. > Turns out that the DBA had switched on PQ to make the queries 'run faster' - > the two CPU server was just choked to death after this. These 'idle' events > from a Statspack report helped me solve the issue (turn off PQ on all tables > - it was an OLTP system). > > John Kanagaraj > DB Soft Inc > Phone: 408-970-7002 (W) > > Listen to great, commercial-free christian music 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message are entirely mine and do > not reflect those of my employer or customers ** > > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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).