OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Trace (Oracle 10g, Linux)

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

Oracle Trace [message #493683]

Wed, 09 February 2011 06:29

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi,

Currently we are using the trace to check the database performance. The below are the command to activate the trace session:-

SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';

I want to clear my concepts-- what is "EVENTS 10046" and "context forever"?

Also how can I activate the memory tracing in Oracle?

Please advice.

Thanks-
P

Report message to a moderator

Re: Oracle Trace [message #493686 is a reply to message #493683]

Wed, 09 February 2011 06:35

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you don't know what is an event and what it means then don't use it.
The standard way to activate trace is

alter session set sql_trace = true;

or use dbms_session (or dbms_monitor if you are a DBA) package:

exec dbms_session.session_trace_enable (true, true)

Regards
Michel

Report message to a moderator

Re: Oracle Trace [message #493835 is a reply to message #493683]

Thu, 10 February 2011 03:16

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Thanks for your suggestion.

Still I am very interested what is meant by "'10046 trace name context forever, level 12'.

Is there is any docs form where I can cleadr my concepts or at least any link for the same?

Thanks-
P

Report message to a moderator