Yes, I am on and off! Too many things to juggle...
Many of the "new" 10g events are related to the breaking up of 'enqueue' and 'latch free'. That
really inflates the total number wait events to 808 (HP-UX). Instead of just one enqueue and one
latch free - there are 184, and 28 of those respectively. These are not really "new events", just
a result of automation of steps one took to figure out what type of latch/enqueue it was by
referring to the P1, P2.
No, we are not going to discuss each of these "new" events individually in the book. However, it
will cover the new views and such.
HTH,
- Kirti
- ryan.gaffuri_at_cox.net wrote:
> Kirtikumar Deshpande has a wait interface book coming on. Are you on? Are you going to cover
> many of the new 10g events?
> >
> > From: Mladen Gogala <mgogala_at_adelphia.net>
> > Date: 2004/02/24 Tue AM 07:03:09 EST
> > To: oracle-l_at_freelists.org
> > Subject: Re: 10g query
> >
> > 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...
> > >
> > >
> > >
> > >
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 11:37:35 CST