Home » SQL & PL/SQL » SQL & PL/SQL » top SQL (Oracle 10g Rel2, Linux AS4)
top SQL [message #362713] Wed, 03 December 2008 21:59 Go to next message
Messages: 295
Registered: May 2007
Senior Member

can somebody help me in finding out what were the top SQL queries in terms of disk utilization and wait time that were fired within a span of time , say between 9 and 10 AM.

Can somebody help in that.


[Updated on: Wed, 03 December 2008 22:26]

Report message to a moderator

Re: top SQL [message #362717 is a reply to message #362713] Thu, 04 December 2008 00:06 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Statspack or AWR/ADDM or query:
select * from dict where table_name like 'DBA_HIST%';

Previous Topic: LONG value VS DB Links
Next Topic: Excluding data
Goto Forum:

Current Time: Mon Oct 24 17:24:42 CDT 2016

Total time taken to generate the page: 0.06532 seconds