August 2002
Intermediate to advanced
528 pages
10h 12m
English
Oracle has a number of views that can be used for performance tuning. These views are called dynamic performance tables. A user can get access to these tables after being granted the SELECT ANY TABLE privilege. The table begins with the characters V$. These views should normally be used by DBAs, but one view is of interest to the data administrator: V$SQL_PLAN.
V$SQL_PLAN is an information view. It has the same functionality as the EXPLAIN PLAN command. The difference is that EXPLAIN PLAN depicts a theoretical plan for a statement, whereas V$SQL_PLAN lists the actual plan for a cursor. The two can be different due to differing values of the session parameters. V$SQL_PLAN can be useful for the following:
Determining ...