OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » list trace events (9iR2)

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

list trace events [message #321880]

Wed, 21 May 2008 13:01

kazdba
Messages: 10
Registered: February 2008

Junior Member

How can I query active/running trace events in oracle 9iR2?

Report message to a moderator

Re: list trace events [message #321881 is a reply to message #321880]

Wed, 21 May 2008 13:05

Michel Cadot
Messages: 68676
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

Report message to a moderator

Re: list trace events [message #321882 is a reply to message #321881]

Wed, 21 May 2008 13:19

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

Michel Cadot
Messages: 68676
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

kazdba
Messages: 10
Registered: February 2008

Junior Member

thanks.

Report message to a moderator

Previous Topic:	Changing Character set
Next Topic:	Patches Details

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 09 18:05:09 CDT 2024