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 ?


Report message to a moderator

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: 68665
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sqlarea

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jun 26 13:42:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.