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: 65143
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: Count as array
Next Topic: SMTP permanent error: 500 #5.5.1
Goto Forum:

Current Time: Sat Aug 19 06:22:37 CDT 2017

Total time taken to generate the page: 0.04905 seconds