DBA_VIEWS view tips

Oracle Tips by Burleson Consulting

DBA_VIEWS

<< Return to the index

Oracle 11g makes the following comments about the DBA_VIEWS table: "Description of all views in the database"

Related notes on DBA_VIEWS:

Column description of the DBA_VIEWS view:

OWNER

Description of DBA_VIEWS.OWNER: "Owner of the view"

VIEW_NAME

Description of DBA_VIEWS.VIEW_NAME: "Name of the view"

TEXT_LENGTH

Description of DBA_VIEWS.TEXT_LENGTH: "Length of the view text"

TEXT

Description of DBA_VIEWS.TEXT: "View text"

TYPE_TEXT_LENGTH

Description of DBA_VIEWS.TYPE_TEXT_LENGTH: "Length of the type clause of the object view"

TYPE_TEXT

Description of DBA_VIEWS.TYPE_TEXT: "Type clause of the object view"

OID_TEXT_LENGTH

Description of DBA_VIEWS.OID_TEXT_LENGTH: "Length of the WITH OBJECT OID clause of the object view"

OID_TEXT

Description of DBA_VIEWS.OID_TEXT: "WITH OBJECT OID clause of the object view"

VIEW_TYPE_OWNER

Description of DBA_VIEWS.VIEW_TYPE_OWNER: "Owner of the type of the view if the view is an object view"

VIEW_TYPE

Description of DBA_VIEWS.VIEW_TYPE: "Type of the view if the view is an object view"

SUPERVIEW_NAME

Description of DBA_VIEWS.SUPERVIEW_NAME: "Name of the superview, if view is a subview"

EDITIONING_VIEW

Description of DBA_VIEWS.EDITIONING_VIEW: "An indicator of whether the view is an Editioning View"

READ_ONLY

Description of DBA_VIEWS.READ_ONLY: "An indicator of whether the view is a Read Only View"

DBA_VIEWS View Source

Oracle 11g's data dictionary defines the DBA_VIEWS view using the following source query:

select u.name, o.name, v.textlength, v.text, t.typetextlength, t.typetext,
t.oidtextlength, t.oidtext, t.typeowner, t.typename,
decode(bitand(v.property, 134217728), 134217728,
(select sv.name from superobj$ h, "_CURRENT_EDITION_OBJ" sv
where h.subobj# = o.obj# and h.superobj# = sv.obj#), null),
decode(bitand(v.property, 32), 32, 'Y', 'N'),
decode(bitand(v.property, 16384), 16384, 'Y', 'N')
from sys."_CURRENT_EDITION_OBJ" o, sys.view$ v, sys.user$ u, sys.typed_view$ t
where o.obj# = v.obj#
and o.obj# = t.obj#(+)
and o.owner# = u.user#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books