René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

SQL related dynamic views [Oracle]

The following dynamic views are related to cursors. Find other dynamic views here.

v$sqlarea

v$sql is quite similar to v$sqlarea. See here.

v$sql

v$sql is quite similar to v$sqlarea. See here.

v$sqlarea_plan_hash

v$sql_shared_memory

v$sqltext

v$sqltext_with_newlines

v$sql_cursor

v$sql_bind_metadata

v$sql_shared_cursor

v$sql_bind_data

v$sql_workarea

v$sql_workarea_active

v$sql_workarea_histogram

v$sql_optimizer_env

v$sql_plan

v$sql_plan_statistics

v$sql_plan_statistics_all

v$sql_redirection

v$sql_join_filter

v$sqlstats