Home » RDBMS Server » Performance Tuning » dynamic view to get 'SQL ordered by...' section from AWR
dynamic view to get 'SQL ordered by...' section from AWR [message #401312] Mon, 04 May 2009 01:00 Go to next message
tridentadm
Messages: 142
Registered: March 2006
Senior Member
In AWR outputs we have a Section :
SQL ordered by....Gets/CPU/Reads/etc.


^^
Is there any dynamic view which we can query to get this outputs ?


Re: dynamic view to get 'SQL ordered by...' section from AWR [message #401315 is a reply to message #401312] Mon, 04 May 2009 01:08 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sqlarea

Regards
Michel
Previous Topic: Hint is not working
Next Topic: configuring undo_retention.
Goto Forum:
  


Current Time: Mon Dec 05 21:36:36 CST 2016

Total time taken to generate the page: 0.08658 seconds