Cursors Page back | 1 2 3 4 5 6 7 8 | next
The Cursors page provides information about each shared cursor in the shared SQL area for the selected session. You can use the Show Cursors list box to display either the current cursor and SQL statement, or display all cursors and corresponding SQL statements for the selected user session.

You can also display the Explain Plan for the current user session, as long as you have logged in as SYS and have privileges for the objects referenced in the Explain Plan.