SQL Monitoring
The SQL Monitoring tab contains a table that displays monitored SQL statements. To view this tab, click SQL Monitoring on the Performance Hub page.
SQL statements are monitored only if they have been running for at least five seconds or if they are run in parallel.
-
A spinning icon indicates that the SQL statement is running.
-
A green check mark icon indicates that the SQL statement completed its execution during the specified time period.
-
A red cross icon indicates that the SQL statement did not complete. The icon displays when an error occurs because the session was terminated.
-
A clock icon indicates that the SQL statement is queued.
You can end session to terminate a running or queued SQL statement.
Real-time SQL Monitoring
You can also click an SQL ID to go to the corresponding Real-time SQL Monitoring page. This page provides additional details that helps you tune the selected SQL statement.
Graphical Explain Plan
-
The default Tabular Execution Plan presents a tabular view of the execution plan.
-
Graphical Explain Plan presents a graphical tree representation of the explain plan. In this plan, you can display as much or as little data as needed, and can rotate the tree to display the information either horizontally or vertically.