Posts Tagged ‘query’

DBA Troubleshoot Queries

+2 Top Ten most CPU TIME Queries SELECT sql_text,ROUND (CPU_TIME/1000000) "CPU_TIME in Seconds" FROM (SELECT  sql_text, CPU_TIME,rank() over ( order by CPU_TIME DESC) rank_desc FROM v$sql) WHERE rank_desc>10;