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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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: Fri Nov 22 14:02:19 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.