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