Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 ,0221 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:07:12 CDT