Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Section 2: Viewing & Monitoring The Execution Plan > Real-Time SQL Monitoring
Real-Time SQL Monitoring
Based upon what has been discussed, consider the various ways in which SQL statements may be identified and monitored from the EM interface:
Performance
Top Activity
SQL ID – this lists the top consuming SQL statements currently active in the instance.
Performance
Search Sessions
SID
Open Cursors
SQL ID – this lists the top consuming SQL statements currently cached in the instance, although they may not at the moment be active.
About Real-Time Automatic SQL Monitoring
Yet another way exists in the EM interface whereby critical SQL statements may be identified. Anytime a single SQL statements meets any one of the following criteria, it is placed on the monitoring list represented by the V$SQL_MONITOR view.