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: 68625
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: Fri Mar 29 07:27:14 CDT 2024