Dynamic Performance Views
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 ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
