Events in Oracle7, Oracle8

From: Andy Johnson <AJohnson_at_Armature.com>
Date: Fri, 17 Aug 2001 09:08:34 +0100
Message-ID: <783866CAB183D211883F0090271F46C2083885F3@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:08:34 CDT