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
rsreddy28
Messages: 295
Registered: May 2007
Senior Member
Hello,

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.

Regards,
Raj

[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: 64103
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%';

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


Current Time: Sat Dec 03 12:07:38 CST 2016

Total time taken to generate the page: 0.10802 seconds