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:23:08 CDT
