Top SQL view Oracle

Top SQL view - Oracle

Administration DBA Top SQL Top SQL view

The Top SQL view lists the 20 slowest database queries. This view requires a system data source and shows all statements in the database cache.

This option is not available if your N4 TOS is hosted by Kaleris. Double-click on a query to view extra detail in the SQL Text form.

The Database Performance Management privilege (on page 1) controls access to this view.

You can use the Actions menu to do the following:

Select Time Boundaries: (on page 1) FiIter the queries by time range. For example, you can view the slowest database queries for only the last hour. Enter the date as YYYY-MM-DD and the time as HH:MM.
Enable SQL Comments: (on page 1) Select this option to turn on SQL comments for the local node or for all nodes. This is applied at the global scope.
Disable SQL Comments: (on page 1) Select this option to turn off viewing SQL comments for the local node or for all nodes. This is applied at the global scope.

Top SQL Columns - Oracle

Short Label	Long Label	Description
Comment	Comment	The comments related to the SQL statement: The default comment displays the user ID, session type, host name, the caller's Java class, and the line of the code that executed the SQL statement. If the N4 developer has entered a comment, then that comment will be displayed, up to 100 characters. The comments appear on SQL statements that run while the comments are enabled (on page 1). If the SQL comments are disabled, then comments will not appear in this column.
Cost	Optimizer Cost	The cost of Oracle optimizer to execute this statement.
CPU Time	CPU Time(sec)	The amount of time in seconds that the query is consuming from the CPU.
Elapsed per Exec	Elapsed Time per Execution(sec)	The average execution time in seconds for this SQL statement. This is the (Total Elapsed) / (Number of Executions).
Executions	Number of Executions	The number of times that the SQL statement has been executed.
First Characters	First Characters	The first 30 characters of the SQL statement.
First Load Time	First Load Time	The timestamp when the SQL statement started executing.
Full Query	Full Query Text	The full text of the SQL statement.
Logical Reads	Number of Logical Reads	The number of logical reads for the SQL statement execution.
Node ID	Node ID	The N4 node that ran the query.
Parse Time	Parse Time(sec)	The amount of time in seconds to parse the SQL statement.
Physical Reads	Number of Physical Reads	The number of physical reads for the SQL statement execution.
Rows	Total Num of Processed Rows	The number of rows processed by the SQL statement.
Sorts	Sorts	The number of sorts the database performed to execute the SQL statement.
SQL ID	SQL ID	The unique ID of the SQL statement.
Total Elapsed	Total Elapsed Time(sec)	The total time in seconds of all the executions of the SQL statement.