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 <john.kanagaraj_at_hds.com> 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: kirtikumar_deshpande_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Sep 23 2003 - 13:15:03 CDT
