Home » SQL & PL/SQL » SQL & PL/SQL » V$SQL View
V$SQL View [message #307407] Tue, 18 March 2008 17:11 Go to next message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
I am trying to write a query that will show me the most cpu time but I am not sure how to parse out the most.

select cpu_time from v$sql;

This list out all the current cpu time but I am not sure how to query the most cpu_time.

Any help would be greatly appreciated

Thanks

DmKanz
Re: V$SQL View [message #307408 is a reply to message #307407] Tue, 18 March 2008 17:15 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
> I am not sure how to query the most cpu_time.
ORDER BY
Re: V$SQL View [message #307410 is a reply to message #307407] Tue, 18 March 2008 17:23 Go to previous message
dmkanz
Messages: 9
Registered: March 2008
Junior Member
would select max(cpu_time) from v$sql; work
Previous Topic: not equal (!=) in trigger
Next Topic: How do create a job to run my add my keys & indexes?
Goto Forum:
  


Current Time: Sun Dec 04 14:49:49 CST 2016

Total time taken to generate the page: 0.04192 seconds