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.

Report message to a moderator

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: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Activate a trace using dbms_monitor.session_trace_enable.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 11:26:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.