Home » RDBMS Server » Performance Tuning » Help - To get Row Source Operation in Tkprof (Oracle 10g R2 on RHEL 4)
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
Previous Topic: How to SQL Tuning? Explain Steps
Next Topic: Statspack Report - Suggestion
Goto Forum:
  


Current Time: Mon Dec 05 12:33:47 CST 2016

Total time taken to generate the page: 0.15056 seconds