OraFAQ Forum: Server Administration » How to determine the values for database events that have been set?

Home » RDBMS Server » Server Administration » How to determine the values for database events that have been set?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to determine the values for database events that have been set? [message #193196]

Fri, 15 September 2006 04:38

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

Report message to a moderator

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

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,

Report message to a moderator

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

Mahesh Rajendran
Messages: 10707
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".

Report message to a moderator

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

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Thanks Mahesh.

Report message to a moderator

Previous Topic:	How do we find archive log is on or off
Next Topic:	Pro * C component Not installed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:55:04 CDT 2024