| column to look for in v$system_event [message #191530] |
Thu, 07 September 2006 00:01  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
what is the exact column to lookout for in v$system_event
1) total_waits
or
2) time_waited
and is time_waited refering to 'each wait' or how is it taken into consideration ???
|
|
|
|
|
|
|
|
| Re: column to look for in v$system_event [message #191759 is a reply to message #191724] |
Fri, 08 September 2006 01:07  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
-->what is the exact column to lookout for in v$system_event?
Both of the columns needs a consideration
total_waits --- It reflects the total number of waits for an event ( a number ).
time_waited --- It reflects the total time waited for an event, in hundreths of seconds ( again a number ).
For instance, there happens to be two events...
Event time
E1 .04 secs
E2 .8 secs
E1 .32 secs
E1 .40 secs
Now the V$system_event should reflect it as
Event Total_waits Time_waited(hundreths of seconds)
E1 3 76
E2 1 80
Am i able to make it clear now??
Is this what you wanted?
[Updated on: Fri, 08 September 2006 01:09] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
