Home » RDBMS Server » Performance Tuning » column to look for in v$system_event
column to look for in v$system_event [message #191530] Thu, 07 September 2006 00:01 Go to next message
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 #191606 is a reply to message #191530] Thu, 07 September 2006 04:28 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/ch3216.htm#1104104

Re: column to look for in v$system_event [message #191724 is a reply to message #191530] Thu, 07 September 2006 23:24 Go to previous messageGo to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
boss you redirected me to the same document site, from which i refered and have eventually raised my point.


it doesnt answer anything...


Re: column to look for in v$system_event [message #191759 is a reply to message #191724] Fri, 08 September 2006 01:07 Go to previous message
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

Previous Topic: shared pool, invalidations and creation indexes ??
Next Topic: Index Usage and SQL Tuning Question
Goto Forum:
  


Current Time: Tue Dec 06 16:15:18 CST 2016

Total time taken to generate the page: 0.10031 seconds