DBA_EDITIONS view tips

Oracle Tips by Burleson Consulting

DBA_EDITIONS

<< Return to the index

Oracle 11g makes the following comments about the DBA_EDITIONS table: "Describes all editions in the database"

Column description of the DBA_EDITIONS view:

EDITION_NAME

Description of DBA_EDITIONS.EDITION_NAME: "Name of the edition"

PARENT_EDITION_NAME

Description of DBA_EDITIONS.PARENT_EDITION_NAME: "Name of the parent edition for this edition"

USABLE

Description of DBA_EDITIONS.USABLE: "A value of 'YES' means edition is usable and 'NO' means unusable"

DBA_EDITIONS View Source

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

select o.name, po.name, decode(bitand(e.flags,1),1,'NO','YES')
from sys.obj$ o, sys.edition$ e, sys.obj$ po
where o.obj# = e.obj#
and po.obj# (+)= e.p_obj#

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