Home » RDBMS Server » Server Administration » list trace events (9iR2)
list trace events [message #321880] Wed, 21 May 2008 13:01 Go to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
How can I query active/running trace events in oracle 9iR2?
Re: list trace events [message #321881 is a reply to message #321880] Wed, 21 May 2008 13:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query v$system_event and v$session_event if you are talking about Oracle events otherwise explain what you want.

Regards
Michel
Re: list trace events [message #321882 is a reply to message #321881] Wed, 21 May 2008 13:19 Go to previous messageGo to next message
kazdba
Messages: 10
Registered: February 2008
Junior Member
I mean the trace events not the wait events.

example: event="12345 trace name context forever, level 2"

how to query the trace events which have been set either by init.ora or alter system.

[Updated on: Wed, 21 May 2008 13:20]

Report message to a moderator

Re: list trace events [message #321883 is a reply to message #321882] Wed, 21 May 2008 13:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can get them with the "sys.dbms_system.read_ev" procedure.
It is not documented in documentation but documented in Metalink notes 28446.1, "How to Determine What Events/Parameters are Set in the Current Session" and, for expert only, 436036.1, "How To List All The Named Events Set For A Database".

Regards
Michel

[Updated on: Wed, 21 May 2008 13:36]

Report message to a moderator

Re: list trace events [message #321891 is a reply to message #321883] Wed, 21 May 2008 14:31 Go to previous message
kazdba
Messages: 10
Registered: February 2008
Junior Member
thanks.
Previous Topic: Changing Character set
Next Topic: Patches Details
Goto Forum:
  


Current Time: Wed Dec 07 03:09:51 CST 2016

Total time taken to generate the page: 0.06029 seconds