Home » RDBMS Server » Performance Tuning » Top 5 long running using DBA_* hist views (Oracle 11g, Linux)
Top 5 long running using DBA_* hist views [message #571635] Wed, 28 November 2012 07:04 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,

To find the top 5 long running query using DBA_* history views(Know ASH will provide).

Thanks in advance,
Re: Top 5 long running using DBA_* hist views [message #571638 is a reply to message #571635] Wed, 28 November 2012 07:40 Go to previous message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_HIST_SQLSTAT

Regards
Michel
Previous Topic: Tune the materialized view
Next Topic: Database Reorganisation
Goto Forum:
  


Current Time: Wed Aug 27 21:03:02 CDT 2014

Total time taken to generate the page: 0.29081 seconds