Home » RDBMS Server » Performance Tuning » How can i trace a different from current session with LEVEL 4? (Oracle Database 10g Enterprise (RAC) Edition Release 10.2.0.4.0 - 64bit, LINUX)
How can i trace a different from current session with LEVEL 4? [message #557509] Wed, 13 June 2012 07:16 Go to next message
Andrey_R
Messages: 372
Registered: January 2012
Location: Israel
Senior Member

Hi All,

I've been searching the web for examples of how to run a trace.
It's needed for a session different then current in trace LEVEL 4
(I need the bind variables values in the trace).

Unfortunately, I couldn't trace with DBMS_SUPPORT.START_TRACE_IN_SESSION,
I understand that this is because it was only introduced in Oracle 11g.

how can i trace a session in level 4 on Oracle 10g for another session?

Thanks,

Andrey
Re: How can i trace a different from current session with LEVEL 4? [message #557510 is a reply to message #557509] Wed, 13 June 2012 07:17 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have a look at dbms_monitor
Re: How can i trace a different from current session with LEVEL 4? [message #557513 is a reply to message #557510] Wed, 13 June 2012 07:34 Go to previous messageGo to next message
Andrey_R
Messages: 372
Registered: January 2012
Location: Israel
Senior Member

I've ran
exec dbms_monitor.session_trace_enable(session_id=>102 ,serial_num=>49081,binds=>true,waits=>true);

but it doesn't give me the bind values.

any suggestions?

Thanks,
Andrey
Re: How can i trace a different from current session with LEVEL 4? [message #557518 is a reply to message #557513] Wed, 13 June 2012 07:39 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
It gives me binds whenever I run it - I suggest you raise the issue with oracle support.
Re: How can i trace a different from current session with LEVEL 4? [message #557526 is a reply to message #557513] Wed, 13 June 2012 09:04 Go to previous messageGo to next message
LNossov
Messages: 318
Registered: July 2011
Location: Germany
Senior Member
You can try also with
switch on: dbms_system.set_ev(<sid>,<serial#>,10046,<level>,'')
switch off : dbms_system.set_ev(<sid>,<serial#>,10046,0,'')
Re: How can i trace a different from current session with LEVEL 4? [message #557527 is a reply to message #557526] Wed, 13 June 2012 09:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DBMS_MONITOR.SESSION_TRACE_ENABLE(
    session_id   IN  BINARY_INTEGER DEFAULT NULL,
    serial_num   IN  BINARY_INTEGER DEFAULT NULL,
    waits        IN  BOOLEAN DEFAULT TRUE,
    binds        IN  BOOLEAN DEFAULT FALSE,
    plan_stat    IN  VARCHAR2 DEFAULT NULL);
Re: How can i trace a different from current session with LEVEL 4? [message #558119 is a reply to message #557527] Tue, 19 June 2012 08:31 Go to previous messageGo to next message
Andrey_R
Messages: 372
Registered: January 2012
Location: Israel
Senior Member

Thank you all for helping.

Sorry, I might have mislead you by looking at the formatted file(by tkprof).
in the raw tracefile I can perfectly see the bind values.

another question: how can i make it show bind values in the formatted file(by TKPROF) too?
Re: How can i trace a different from current session with LEVEL 4? [message #558122 is a reply to message #558119] Tue, 19 June 2012 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 67950
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: How can i trace a different from current session with LEVEL 4? [message #558188 is a reply to message #558122] Wed, 20 June 2012 02:16 Go to previous message
Andrey_R
Messages: 372
Registered: January 2012
Location: Israel
Senior Member

Thank you very much Michel for the quick answer,
thank you all for assistance and help!

Andrey
Previous Topic: "px send round-robin "
Next Topic: Oracle (HP-UX) connection very slow from Windows client
Goto Forum:
  


Current Time: Sat Sep 25 22:01:49 CDT 2021