Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Events in Oracle7, Oracle8

Events in Oracle7, Oracle8

From: Andy Johnson <AJohnson_at_Armature.com>
Date: Fri, 17 Aug 2001 09:52:56 +0100
Message-ID: <783866CAB183D211883F0090271F46C20838D209@mailhost.armature.com>


Hi..

I don't think is too much of an issue, it's when slaves are waiting for messages to be dequeued, but i think it's been renamed in newer releases (not too sure??)

you the metalink.oracle.com search engine to get more info around it.

regards

andy

-----Original Message-----
From: Thomas Kindermann [mailto:TKINDERMANN_at_TYCOINT.COM] Posted At: Friday, August 17, 2001 9:41 AM Posted To: server
Conversation: Events in Oracle7, Oracle8 Subject: Re: Events in Oracle7, Oracle8 -> parallel query dequeue wait

OK, i found the most events, but what is with:

Event Name                       Count         Total Time    Avg Time
-------------------------------- ------------- -------------
-------------
parallel query dequeue wait              49082       5986844
121,98

thanks

Thomas

"Thomas Kindermann" <TKINDERMANN_at_TYCOINT.COM> schrieb im Newsbeitrag news:3b7cd3c9$0$405$45beb828_at_newscene.com...
> Thanks a lot. .-)))
>
> A great adress.
>
>
> --
> Thomas Kindermann
> System- und Datenbankadministrator
>
> tyco
> Fire and Security
> TOTAL WALTHER GmbH
> Waltherstrasse 51
> 51069 Köln
>
> e-mail: TKindermann_at_tycoint.com
>
>
> "Andy Johnson" <AJohnson_at_Armature.com> schrieb im Newsbeitrag
> news:783866CAB183D211883F0090271F46C2083885F3_at_mailhost.armature.com...
> > Hi Thomas..
> >
> > this should give you the info you are after..
> >
> > http://technet.oracle.com/doc/server.815/a67790/apa.htm
> >
> > rgds
> >
> > andy
> >
> > -----Original Message-----
> > From: Thomas Kindermann [mailto:TKINDERMANN_at_TYCOINT.COM]
> > Posted At: Friday, August 17, 2001 9:07 AM
> > Posted To: server
> > Conversation: Events in Oracle7, Oracle8
> > Subject: Events in Oracle7, Oracle8
> >
> >
> > I try to tuning my oracle7 database. in the report.txt file i have
the
> > following entries:
> >
> > SVRMGR> select n1.event "Event Name",
> > 2> n1.event_count "Count",
> > 3> n1.time_waited "Total Time",
> > 4> round(n1.time_waited/n1.event_count, 2) "Avg Time"
> > 5> from stats$event n1
> > 6> where n1.event_count > 0
> > 7> order by n1.time_waited desc;
> > Event Name Count Total Time Avg
Time
> > -------------------------------- ------------- -------------
> > -------------
> > SQL*Net message from client 1877692 39562576
> > 21,07
> > parallel query dequeue wait 49082 5986844
> > 121,98
> > db file sequential read 407107 82504
> > ,2
> > rdbms ipc reply 1587 17607
> > 11,09
> > log file sync 8327 11950
> > 1,44
> > latch free 28372 6365
> > ,22
> > enqueue 309 5592
> > 18,1
> > db file scattered read 29602 2216
> > ,07
> > SQL*Net message to client 1877864 874
> > 0
> > log file switch completion 15 522
> > 34,8
> > SQL*Net more data to client 89587 427
> > 0
> > write complete waits 86 307
> > 3,57
> > parallel query signal server 154 154
> > 1
> > parallel query qref latch 91 75
> > ,82
> > control file parallel write 70 62
> > ,89
> > SQL*Net more data from client 4028 43
> > ,01
> > buffer busy waits 9 41
> > 4,56
> > library cache pin 70 34
> > ,49
> > db file single write 11 12
> > 1,09
> > control file sequential read 708 2
> > 0
> > SQL*Net break/reset to client 64 1
> > ,02
> > 21 Zeilen ausgewählt
> >
> > Where can i find a complete list and description of Oracle Events ?
> > for example: "parallel query dequeue wait", "SQL*Net message from
> > client",
> > "SQL*Net message to client"
> > (with some sample data ??)
> >
> >
> > Thomas Kindermann
> > System- und Datenbankadministrator
> > tyco
> > Fire and Security
> > TOTAL WALTHER GmbH
> > Waltherstrasse 51
> > 51069 Köln
> >
> > e-mail: TKindermann_at_tycoint.com
> >
> >
> >
> >
>
>
Received on Fri Aug 17 2001 - 03:52:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US