Oracle Server Manager User's Guide

The Explain Plans Folder

When you click the Explain Plans folder tab, the Explain Plans folder opens and the Explain Plan object list appears. The Explain Plan object list contains a list of the SQL statements that have execution plans stored in the table PLAN_TABLE.

You can use the EXPLAIN PLAN command to generate the execution plan for a particular SQL statement. The execution plan is stored in a table, which by default is called PLAN_TABLE. For information about execution plans and the EXPLAIN PLAN command, see the Oracle7 Server Concepts, the Oracle7 Server Application Developer's Guide, and the Oracle7 Server SQL Reference.

The following figure illustrates the Explain Plan object list.

Figure 7 - 7. Explain Plan Object List

Explain Plan Object List

The columns of the Explain Plan object list are described below:

Statement ID Identifier for the SQL statement (can be null).
Timestamp Date the EXPLAIN PLAN command was executed for the statement.

Attention: The information displayed in the Explain Plan object list is from the table named PLAN_TABLE belonging to the schema SYS. Server Manager does not display information from any other plan tables. If SYS does not own a PLAN_TABLE or if you do not have access to SYS.PLAN_TABLE, you cannot open the Explain Plans folder.

Additional Information: You can run the script UTLXPLAN.SQL to create a PLAN_TABLE. The location of the script UTLXPLAN.SQL is platform dependent. For information about running UTLXPLAN.SQL, see your operating system-specific Oracle documentation.

Statement ID	Identifier for the SQL statement (can be null).
Timestamp	Date the EXPLAIN PLAN command was executed for the statement.