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: Thomas Kindermann <TKINDERMANN_at_TYCOINT.COM>
Date: 17 Aug 2001 03:07:12 -0500
Message-ID: <3b7cd016$0$427$45beb828@newscene.com>


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:07:12 CDT

Original text of this message

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