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,

Report message to a moderator

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: 68775
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBA_HIST_SQLSTAT

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 16 19:52:41 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.