Wednesday, September 17, 2008

DBA_LIBRARIES

DBA_LIBRARIES describes all libraries in the database. Its columns are the same as those in ALL_LIBRARIES.

Related Views

· ALL_LIBRARIES describes the libraries accessible to the current user.

· USER_LIBRARIES describes the libraries owned by the current user. This view does not display the OWNER column.

Column

Datatype

NULL

Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the library

LIBRARY_NAME

VARCHAR2(30)

NOT NULL

Library name

FILE_SPEC

VARCHAR2(2000)

Operating system file specification associated with the library

DYNAMIC

VARCHAR2(1)

Indicates whether the library is dynamically loadable (Y) or not (N)

STATUS

VARCHAR2(7)

Status of the library:

· N/A

· VALID

· INVALID

Note:

1. What is in DBA_LIBRARIES in Oracle 10gR2?

select * from DBA_LIBRARIES;

OWNER

LIBRARY_NAME

FILE_SPEC

DYNAMIC

STATUS

CTXSYS

DR$LIB

N

VALID

MDSYS

ORDMD_AG_LIBS

N

VALID

MDSYS

ORDMD_IDX_LIBS

N

VALID

MDSYS

ORDMD_SAM_LIBS

N

VALID

MDSYS

SDO_GEOR_LIZARDTECH_LIB

/oracle/product/10.2.0.1ee/md/dll/liblt_dbmrsid_oci.so

Y

VALID

MDSYS

ORDMD_GEOR_LIBS

N

VALID

MDSYS

ORDMD_GEORX_LIBS

N

VALID

MDSYS

ORDMD_TP_LIBS

N

VALID

MDSYS

ORDMD_PRIDX_LIBS

N

VALID

MDSYS

ORDMD_UTL_LIBS

N

VALID

MDSYS

ORDMD_LRS_LIBS

N

VALID

MDSYS

ORDMD_RTREE_LIBS

N

VALID

MDSYS

ORDMD_CS_LIBS

N

VALID

MDSYS

ORDMD_MIG_LIBS

N

VALID

MDSYS

ORDMD_UDT_LIBS

N

VALID

MDSYS

ORDMD_MBR_LIBS

N

VALID

MDSYS

ORDMD_WD_LIBS

N

VALID

MDSYS

ORDMD_REL_LIBS

N

VALID

ORDSYS

ORDIMLIBT

N

VALID

ORDSYS

ORDIMLIBS

/oracle/product/10.2.0.1ee/lib/libordim10.so

Y

VALID

SYS

DBMS_HAEVENTNOT_PRVT_LIB

N

VALID

SYS

DBMS_HA_ALERT_LIB

N

VALID

SYS

DBMS_HDM_LIB

N

VALID

SYS

DBMS_SQLTUNE_LIB

N

VALID

SYS

DBMS_UNDOADV_LIB

N

VALID

SYS

DBMS_SWRF_LIB

N

VALID

SYS

DBMS_TUNEMV_LIB

N

VALID

SYS

DBMS_SUMA_LIB

N

VALID

SYS

DBMS_KEA_LIB

N

VALID

SYS

DBMS_MONITOR_LIB

N

VALID

SYS

DBMS_SVRALRT_PRVT_LIB

N

VALID

SYS

DBMS_SVRALRT_LIB

N

VALID

SYS

DBMS_CHNF_LIB

N

VALID

SYS

DBMS_XPLAN_LIB

N

VALID

SYS

DBMS_TSM_LIB

N

VALID

SYS

DBMS_SERVICE_LIB

N

VALID

SYS

DBMS_PROFILER_LIB

N

VALID

SYS

KGL_TEST_LIB

N

VALID

SYS

DBMS_UPG_LIB

N

VALID

SYS

DBMS_CDCPUB_LIB

N

VALID

SYS

COLLECTION_LIB

N

VALID

SYS

DBMS_SERVER_TRACE_LIB

N

VALID

SYS

ORA_FI_LIB

N

VALID

SYS

DBMS_FILE_GROUP_LIB

N

VALID

SYS

DBMS_STREAMS_TBS_LIB

N

VALID

SYS

DBMS_FILE_TRANSFER_LIB

N

VALID

SYS

DBMS_RWEQUIV_LIB

N

VALID

SYS

DBMS_FBT_LIB

N

VALID

SYS

KUPVLIB

N

VALID

SYS

KUPP_PROC_LIB

N

VALID

SYS

KUPFLIB

N

VALID

SYS

TDE_LIBRARY

N

VALID

SYS

KUPDLIB

N

VALID

SYS

DBMS_DBLINK_LIB

N

VALID

SYS

DBMS_EXTENDED_TTS_CHECKS_LIB

N

VALID

SYS

DBMS_SCHEDULER_LIB

N

VALID

SYS

SCHEDULER_JOB_LIB

N

VALID

SYS

DBMS_SQLPLUS_SCRIPT_LIB

N

VALID

SYS

DBMS_STAT_FUNCS_AUX_LIB

N

VALID

SYS

DBMS_STAT_FUNCS_LIB

N

VALID

SYS

UTL_MAT_LIB

N

VALID

SYS

DBMS_PLSQL_WARNING_LIB

N

VALID

SYS

UTL_LMS_LIB

N

VALID

SYS

UTL_I18_LIB

N

VALID

SYS

UTL_CMP_LIB

N

VALID

SYS

UTL_SYS_CMP_LIB

N

VALID

SYS

UPGRADE_LIB

N

VALID

SYS

DBMS_OLAPI_LIB2

N

VALID

SYS

CWM2_OLAP_MESSAGE_LIBRARY

${ORACLE_HOME}/lib/libamd.so

Y

VALID

SYS

DBMS_OLAPI_LIB

N

VALID

SYS

CRYPTO_TOOLKIT_LIBRARY

N

VALID

SYS

DBMS_MAP_LIB

N

VALID

SYS

DBMS_LOGREP_LIB

N

VALID

SYS

LCR_DDL_LIB

N

VALID

SYS

LCR_ROW_LIB

N

VALID

SYS

LCR_PRC_LIB

N

VALID

SYS

DBMS_DEFER_QUERY_UTL_LIB

N

VALID

SYS

DBMS_DEFER_ENQ_UTL_LIB

N

VALID

SYS

DBMS_REPCAT_INTERNAL_PKG_LIB

N

VALID

SYS

DBMS_AW_LIB

N

VALID

SYS

DBMS_RESUMABLE_LIB

N

VALID

SYS

QXXQLIB

N

VALID

SYS

DBMS_LOGSTDBY_LIB

N

VALID

SYS

DBMS_FGA_LIB

N

VALID

SYS

DBMS_CDCAPI_LIB

N

VALID

SYS

DBMS_LDAP_API_LIB

N

VALID

SYS

UTL_XML_LIB

N

VALID

SYS

DBMS_XMLGEN_LIB

N

VALID

SYS

DBURI_LIB

N

VALID

SYS

URI_LIB

N

VALID

SYS

XMLTYPE_LIB

N

VALID

SYS

DBMS_LOGMNR_LIB

N

VALID

SYS

DBMS_OBFUSCATION_LIB

N

VALID

SYS

DBMS_REPAIR_LIB

N

VALID

SYS

DBMS_OUTLN_LIB

N

VALID

SYS

DBMS_APPCTX_LIB

N

VALID

SYS

DBMS_RLS_LIB

N

VALID

SYS

DBMS_UTL_COLL_LIB

N

VALID

SYS

DBMS_UTL_REF_LIB

N

VALID

SYS

DBMS_PLUGTS_LIB

N

VALID

SYS

DBMS_TRACE_LIB

N

VALID

SYS

DBMS_SUMAPI_LIB

N

VALID

SYS

DBMS_SNAPSHOT_LIB

N

VALID

SYS

DBMS_REPAPI_LIB

N

VALID

SYS

DBMS_XRW_LIB

N

VALID

SYS

DBMS_XMV_LIB

N

VALID

SYS

DBMS_SUMADV_LIB

/oracle/product/10.2.0.2ee/lib/libqsmashr.so

Y

VALID

SYS

DBMS_RMGR_LIB

N

VALID

SYS

DBMS_AQELM_LIB

N

VALID

SYS

DBMS_AQ_LDAP_LIB

N

VALID

SYS

DBMS_AQADM_LIB

N

VALID

SYS

DBMS_AQ_LIB

N

VALID

SYS

DBMS_RULES_LIB

N

VALID

SYS

DBMS_ANYDATASET_LIB

N

VALID

SYS

DBMS_ANYDATA_LIB

N

VALID

SYS

DBMS_ANYTYPE_LIB

N

VALID

SYS

DBMS_TRANS_LIB

N

VALID

SYS

DBMS_TRAN_LIB

N

VALID

SYS

DBMS_ZHELP_LIB

N

VALID

SYS

DBMS_TRIGGER_LIB

N

VALID

SYS

DBMS_STATS_LIB

N

VALID

SYS

ODCI_EXTOPT_LIB

N

VALID

SYS

EXTIDX_IMP_LIB

N

VALID

SYS

DBMS_SPACE_ADMIN_LIB

N

VALID

SYS

UTL_GDK_LIB

N

VALID

SYS

UTL_ENC_LIB

N

VALID

SYS

UTL_URL_LIB

N

VALID

SYS

UTL_HTT_LIB

N

VALID

SYS

UTL_SMT_LIB

N

VALID

SYS

UTL_INA_LIB

N

VALID

SYS

UTL_TCP_LIB

N

VALID

SYS

UTL_FIL_LIB

N

VALID

SYS

DBMS_PICKLER_LIB

N

VALID

XDB

XMLTM_LIB

N

VALID

XDB

XMLINDEX_LIB

N

VALID

XDB

PATH_VIEW_LIB

N

VALID

XDB

RESOURCE_VIEW_LIB

N

VALID

XDB

DBMS_XDB_LIB

N

VALID

XDB

DBMS_XMLDOM_LIB

N

VALID

XDB

PATH_INDEX_LIB

N

VALID

XDB

DBMS_XDB_VERSION_LIB

N

VALID

XDB

XMLSCHEMA_LIB

N

VALID

XDB

DBMS_XSLPROCESSOR_LIB

N

VALID

XDB

DBMS_XMLPARSER_LIB

N

VALID

XDB

SECURITY_LIB

N

VALID

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment