Collect query optimization data using the dynamic performance view of Oracle

For some current releases, three dynamic performance views are available for DBAs (Database Administrator, Database Administrator) and developers, namely V $ SQL, V $ SQLAREA, and V $ SQLTEXT.

These views can be used to collect statistics about SQL command execution. In Oracle 10g and Release 2, the fourth dynamic performance view, V $ SQLSTATS, is added to facilitate access to such data.

Unlike the static data dictionary view (which is prefixed with USER _, ALL _, or DBA _), the dynamic performance view is constantly updated as the system runs. This makes it possible to monitor the performance of SQL statements during execution.

Like static views, you must first obtain a license to use them. You can grant SELECT_CATALOG_ROLE permissions to non-Database Administrators (such as in a typical development environment) so that they can make choices.

The following is a brief description of the functions provided by each view:

1 2 Next Page

[Content navigation]
Page 1st: Collect query tuning using the dynamic performance view of Oracle	Page 2nd: Collect query tuning using the dynamic performance view of Oracle