Home » RDBMS Server » Performance Tuning » Wait events for a query (Oracle 10.2.0.4)
Wait events for a query [message #539584] Tue, 17 January 2012 04:47 Go to next message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Hi Experts,
I want to find out the associated waits for a query.Is there any easiest way to find out the waitevents for a specific sql?

Thanks
Himadri.
Re: Wait events for a query [message #539586 is a reply to message #539584] Tue, 17 January 2012 04:52 Go to previous message
Michel Cadot
Messages: 67948
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate a trace using dbms_monitor.session_trace_enable.

Regards
Michel
Previous Topic: Oracle10g Standard Edition on Linux machine
Next Topic: Best Practices to optimize a FAST REFRESH Materialized View?
Goto Forum:
  


Current Time: Thu Sep 23 06:38:40 CDT 2021