Home » RDBMS Server » Server Administration » How to determine the values for database events that have been set?
How to determine the values for database events that have been set? [message #193196] Fri, 15 September 2006 04:38 Go to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi all

How can I get the values for all events that have been set on my database?

I know I can use dbms_system.read_ev for obtaining event information for events set for current session, but, in case I want to check for all events set at my database level, how can I get that?

All responses will be highly appreciated.

Thanks

Girish
Re: How to determine the values for database events that have been set? [message #193242 is a reply to message #193196] Fri, 15 September 2006 07:10 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

The below given query may be solve your purpose:

select sid, event, p1, seconds_in_wait, state
from v$session_wait
/


Thanks,

Re: How to determine the values for database events that have been set? [message #193258 is a reply to message #193196] Fri, 15 September 2006 08:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you try this?
http://www.jlcomp.demon.co.uk/faq/what_events.html

"dump events 2" is for process level (as stated by Mark)
for system level, use "dump events 4".

Re: How to determine the values for database events that have been set? [message #196478 is a reply to message #193258] Thu, 05 October 2006 09:04 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Thanks Mahesh.
Previous Topic: How do we find archive log is on or off
Next Topic: Pro * C component Not installed
Goto Forum:
  


Current Time: Tue Dec 06 06:09:37 CST 2016

Total time taken to generate the page: 0.11487 seconds