Cary, there are 808 events in 10g. There is a huge class of events which oracle calls "idle" and in your book you warned against disregarding "idle" events. Are there any changes in 10g in that recommendation? From what I've seen so far, 10g is not so drastically different from 9i as 9i was different from 8i. Would you agree with that impression? On 02/24/2004 01:23:24 AM, Cary Millsap wrote: > Can someone with production 10g installed please show me the result of > the following query: > > > > show release > > select count(*) from v$event_name; > > > > Thanks in advance. > > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > Nullius in verba > > Upcoming events: > - Performance <http://www.hotsos.com/training/PD101.html> Diagnosis > 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle > - Hotsos Symposium 2004 <http://www.hotsos.com/events/symposium/2004> : > March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------