Are dynamic performance tables really virtual tables? Or, do the v$views take up storage space? I have 25,000 'rows' in v$SQLTEXT alone. Thanks.
Printable View
Are dynamic performance tables really virtual tables? Or, do the v$views take up storage space? I have 25,000 'rows' in v$SQLTEXT alone. Thanks.
V$* objects are views; they don't take up any space.
system@dev815nt.us> select owner, object_name, object_type
2 from dba_objects
3 where object_name = 'V$SQLTEXT';
OWNER OBJECT_NAME OBJECT_TYPE
------------ -------------------- ---------------
PUBLIC V$SQLTEXT SYNONYM
system@dev815nt.us> select owner, synonym_name, table_owner, table_name
2 from dba_synonyms
3 where synonym_name = 'V$SQLTEXT';
OWNER SYNONYM_NAME TABLE_OWNER
------------ ------------------------------ ---------------------------
TABLE_NAME
------------------------------
PUBLIC V$SQLTEXT SYS
V_$SQLTEXT
system@dev815nt.us> select owner, object_name, object_type
2 from dba_objects
3 where object_name = 'V_$SQLTEXT';
OWNER OBJECT_NAME OBJECT_TYPE
------------ -------------------- ---------------
SYS V_$SQLTEXT VIEW
system@dev815nt.us>