OraFAQ Forum: Performance Tuning » Help - To get Row Source Operation in Tkprof

Home » RDBMS Server » Performance Tuning » Help - To get Row Source Operation in Tkprof (Oracle 10g R2 on RHEL 4)

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

Help - To get Row Source Operation in Tkprof [message #348055]

Mon, 15 September 2008 08:54

orasaket
Messages: 70
Registered: November 2006

Member

Hi,

I am trying to trace (10046) a session which is accessing a j2ee application

Thus there will be a sql session with dbms_sytem.set_ev(sid,serial#,10046,12,'') and another will be the connection to application server (jdbc) using the application

Now to get all correct statistics and row source operation which of the sequence I will follow :

1) jdbc session connect to j2ee application
2) sql session connect to db issue - dbms_sytem.set_ev(sid,serial#,10046,12,'')
3) jdbc session access the problematic screen
4) sql session connect to db issue - dbms_sytem.set_ev(sid,serial#,10046,0,'')
5) tkprof the trace file generated

Or

1) jdbc session connect to j2ee application
2) sql session connect to db issue - dbms_sytem.set_ev(sid,serial#,10046,12,'')
3) jdbc session access the problematic screen
4) log out the j2ee application (i.e.close j2ee session)
5) tkprof the trace file generated

Or

1) jdbc session connect to j2ee application
2) sql session connect to db issue - dbms_sytem.set_ev(sid,serial#,10046,12,'')
3) jdbc session access the problematic screen
4) exit sql session
5) tkprof the trace file generated

Thanks and Regards,
OraSaket

Report message to a moderator

Previous Topic:	How to SQL Tuning? Explain Steps
Next Topic:	Statspack Report - Suggestion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 09:33:09 CST 2024