Home » SQL & PL/SQL » SQL & PL/SQL » How to get all the expensive/costly query (Database: Oracle 10g)
How to get all the expensive/costly query [message #427619] Fri, 23 October 2009 10:07 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Hi,

How to get all the expensive/costly query, while the application is ruuning? Is there any system table for the same?
Database: Oracle 10g
Re: How to get all the expensive/costly query [message #427622 is a reply to message #427619] Fri, 23 October 2009 10:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10671
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
AWR
Certain DBA_HIST_* views
Re: How to get all the expensive/costly query [message #427785 is a reply to message #427619] Sun, 25 October 2009 09:20 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
V$SQL as well
Previous Topic: sql query proposed for using case
Next Topic: ORA-06532: Subscript outside of limit
Goto Forum:
  


Current Time: Tue Sep 27 05:56:37 CDT 2016

Total time taken to generate the page: 0.12985 seconds