| |
 |
|
DBA_LIBRARIES view tips
Oracle Tips by Burleson Consulting |
DBA_LIBRARIES
<< Return to the index
Oracle 11g makes the following comments about the DBA_LIBRARIES table: "Description of all libraries in the database"
Related notes on DBA_LIBRARIES:
Column description of the DBA_LIBRARIES view:OWNERDescription of DBA_LIBRARIES.OWNER: "Owner of the library" LIBRARY_NAMEDescription of DBA_LIBRARIES.LIBRARY_NAME: "Name of the library" FILE_SPECDescription of DBA_LIBRARIES.FILE_SPEC: "Operating system file specification of the library" DYNAMICDescription of DBA_LIBRARIES.DYNAMIC: "Is the library dynamically loadable" STATUSDescription of DBA_LIBRARIES.STATUS: "Status of the library"
DBA_LIBRARIES View SourceOracle 11g's data dictionary defines the DBA_LIBRARIES view using the following source query:
select u.name,
o.name,
l.filespec,
decode(bitand(l.property, 1), 0, 'Y', 1, 'N', NULL),
decode(o.status, 0, 'N/A', 1, 'VALID', 'INVALID')
from sys."_CURRENT_EDITION_OBJ" o, sys.library$ l, sys.user$ u
where o.owner# = u.user#
and o.obj# = l.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
|
|
