welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com
Find Slow Oracle SQL
Oracle Tips by Burleson Consulting
June 17, 2011
Question: How do I find slow SQL statements in my Oracle database?
Answer: Oracle provides several views to find SQL with a long
execution time:
* v$active_session_history: The sysdate-sql_exec_start will find
slow SQL statements
* v$sql: The elapsed_time column shows slow execution time for
current SQL statements
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------
0 Commentaires