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

DBA_DIRECTORIES

Thank you for visiting Spatial DBA - Oracle and ArcSDE.

Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.

==================================================================


DBA_DIRECTORIES describes all directory objects in the database. Its columns are the same as those in "ALL_DIRECTORIES".

Related View

·         ALL_DIRECTORIES describes all directories accessible to the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the directory (always SYS)
DIRECTORY_NAME	VARCHAR2(30)	NOT NULL	Name of the directory
DIRECTORY_PATH	VARCHAR2(4000)		Operating system pathname for the directory

Note:

1.       SQL statements for directories:

System privileges	GRANT create any directory TO ; GRANT drop any directory TO ;
Create a directory	CREATE OR REPLACE DIRECTORY AS '';
Grant read on a directory	GRANT READ ON DIRECTORY TO
Grant write on a directory	GRANT WRITE ON DIRECTORY TO
Revoke read on a directory	REVOKE READ ON DIRECTORY FROM
Revoke write on a directory	REVOKE WRITE ON DIRECTORY FROM
Drop a directory	DROP DIRECTORY ;

2.       When creating a directory, sqlplus cannot interpret environment variable ORACLE_HOME. If a directory is created (eg. create directory dpump_dir1 as '%ORACLE_HOME%\admin\dpdump';), any reference to the directory fails. Specifying environment variables in the 'create directory' statement is not a supported / documented feature. There are two reasons: 1). Different platforms like Windows, Unix and VMS specify environment variables differently. It would therefore be difficult to implement generically; 2) It is also a potential security hazard, since if it would work for $ORACLE_HOME it would also work for other environment variables, which would allow to the directory to be placed at another location on disk. Hence, the solution has to be to specify directories using a full (hardcoded) path.

3.       Example of contents of DBA_DIRECTORIES

select * from DBA_DIRECTORIES;

               

OWNER	DIRECTORY_NAME	DIRECTORY_PATH
SYS	DATA_PUMP_DIR	/oracle/product/10.2.0.1ee/rdbms/log/
SYS	ADMIN_DIR	/oracle/product/10.2.0.1ee/md/admin
SYS	TIMEZDIF_DIR	/oracle/product/10.2.0.2ee/oracore/zoneinfo

 Oracle data dictionary views

Oracle dynamic performance views

Last updated: 2009-11-02 Monday

DBA_DIMENSIONS

DBA_DIMENSIONS represents dimension objects. Its columns are the same as those in "ALL_DIMENSIONS".

Related Views

· ALL_DIMENSIONS describes dimension objects accessible to the current user.

· USER_DIMENSIONS describes dimensions in the current user's schema.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the dimension
DIMENSION_NAME	VARCHAR2(30)	NOT NULL	Name of the dimension
INVALID	VARCHAR2(1)		Indicates whether the dimension is invalid (Y) or valid (N)
COMPILE_STATE	VARCHAR2(13)		Compile status of the dimension: · INVALID · NEEDS_COMPILE · ERROR
REVISION	NUMBER		Dimension revision level

Oracle data dictionary views

Oracle dynamic performance views

DBA_CUBES

DBA_CUBES describes all OLAP cubes in the database. Its columns are the same as those in ALL_CUBES.

Related Views

· ALL_CUBES describes the OLAP cubes accessible to the current user.

· USER_CUBES describes the OLAP cubes owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)		Owner of the cube
CUBE_NAME	VARCHAR2(30)	NOT NULL	Name of a cube, such as UNITS_CUBE
AW_NAME	VARCHAR2(30)		Name of the analytic workspace that contains the cube, such as GLOBAL
CONSISTENT_SOLVE_SPEC	CLOB		Default aggregation rules for the cube
DESCRIPTION	NVARCHAR2(300)		Description of the cube in the session language
SPARSE_TYPE	VARCHAR2(80)		Text value indicating the type of sparsity for the OLAP cube
PRECOMPUTE_CONDITION	CLOB		Condition syntax representing the precompute condition of the OLAP cube
PRECOMPUTE_PERCENT	NUMBER		Percentage of aggregate data values that are calculated and stored during data maintenance. If the cube is partitioned, then this percentage is for the bottom partitions.
PRECOMPUTE_PERCENT_TOP	NUMBER		Percentage of aggregate data values in the top partition that are calculated and stored during data maintenance
PARTITION_DIMENSION_NAME	VARCHAR2(30)		Name of the dimension used to partition the cube, such as TIME
PARTITION_HIERARCHY_NAME	VARCHAR2(30)		Name of the dimension hierarchy used to partition the cube, such as CALENDAR
PARTITION_LEVEL_NAME	VARCHAR2(30)		Name of the level used to partition the cube, such as QUARTER

Oracle data dictionary views

Oracle dynamic performance views

DBA_CLUSTERS

DBA_CLUSTERS describes all clusters in the database. Its columns are the same as those in "ALL_CLUSTERS".

Related Views

· ALL_CLUSTERS describes all clusters accessible to the current user.

· USER_CLUSTERS describes all clusters 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 cluster
CLUSTER_NAME	VARCHAR2(30)	NOT NULL	Name of the cluster
TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the cluster
PCT_FREE	NUMBER		Minimum percentage of free space in a block
PCT_USED	NUMBER		Minimum percentage of used space in a block
KEY_SIZE	NUMBER		Estimated size of cluster key plus associated rows
INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
MIN_EXTENTS	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
MAX_EXTENTS	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
PCT_INCREASE	NUMBER		Percentage increase in extent size
FREELISTS	NUMBER		Number of process freelists allocated to this segment
FREELIST_GROUPS	NUMBER		Number of freelist groups allocated to this segment
AVG_BLOCKS_PER_KEY	NUMBER		Number of blocks in the table divided by number of cluster keys
CLUSTER_TYPE	VARCHAR2(5)		Type of cluster: B*-Tree index or hash
FUNCTION	VARCHAR2(15)		If a hash cluster, the hash function
HASHKEYS	NUMBER		If a hash cluster, the number of hash keys (hash buckets)
DEGREE	VARCHAR2(10)		Number of threads per instance for scanning the cluster
INSTANCES	VARCHAR2(10)		Number of instances across which the cluster is to be scanned
CACHE	VARCHAR2(5)		Indicates whether the cluster is to be cached in the buffer cache (Y) or not (N)
BUFFER_POOL	VARCHAR2(7)		Default buffer pool for the cluster
SINGLE_TABLE	VARCHAR2(5)		Indicates whether this is a single-table cluster (Y) or not (N)
DEPENDENCIES	VARCHAR2(8)		Indicates whether row-level dependency tracking is enabled (ENABLED) or disabled (DISABLED)

Oracle data dictionary views

Oracle dynamic performance views