DBA_PROCEDURES

Oracle 11gR1

DBA_PROCEDURES lists all functions and procedures along with their associated properties. Its columns are the same as those in "ALL_PROCEDURES".

Related Views

· ALL_PROCEDURES lists all functions and procedures, along with associated properties. For example, ALL_PROCEDURES indicates whether or not a function is pipelined, parallel enabled or an aggregate function. If a function is pipelined or an aggregate function, the associated implementation type (if any) is also identified.

· USER_PROCEDURES lists all functions and procedures, along with associated properties. It does not contain the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(30)	NOT NULL	Owner of the procedure
OBJECT_NAME	VARCHAR2(30)	NOT NULL	Name of the object: top-level function, procedure, or package name
PROCEDURE_NAME	VARCHAR2(30)		Name of the procedure
OBJECT_ID	NUMBER		Object number of the object
SUBPROGRAM_ID	NUMBER		Unique subprogram identifier
OVERLOAD	VARCHAR2(40)		Overload unique identifier
OBJECT_TYPE	VARCHAR2(19)		The typename of the object
AGGREGATE	VARCHAR2(3)		Indicates whether the procedure is an aggregate function (YES) or not (NO)
PIPELINED	VARCHAR2(3)		Indicates whether the procedure is a pipelined table function (YES) or not (NO)
IMPLTYPEOWNER	VARCHAR2(30)		Name of the owner of the implementation type, if any
IMPLTYPENAME	VARCHAR2(30)		Name of the implementation type, if any
PARALLEL	VARCHAR2(3)		Indicates whether the procedure or function is parallel-enabled (YES) or not (NO)
INTERFACE	VARCHAR2(3)		YES, if the procedure/function is a table function implemented using the ODCI interface; otherwise NO
DETERMINISTIC	VARCHAR2(3)		YES, if the procedure/function is declared to be deterministic; otherwise NO
AUTHID	VARCHAR2(12)		Indicates whether the procedure/function is declared to execute as DEFINER or CURRENT_USER (invoker)

Oracle data dictionary views

Oracle dynamic performance views

DBA_SERVER_REGISTRY

Oracle 11gR1

DBA_SERVER_REGISTRY displays information about the components loaded into the database.

Column	Datatype	NULL	Description
COMP_ID	VARCHAR2(30)	NOT NULL	Component identifier
COMP_NAME	VARCHAR2(255)		Component name
VERSION	VARCHAR2(30)		Component version loaded
STATUS	VARCHAR2(11)		Component status: · INVALID · VALID · LOADING · LOADED · UPGRADING · UPGRADED · DOWNGRADING · DOWNGRADED · REMOVING · REMOVED
MODIFIED	VARCHAR2(20)		Time when the component was last modified
CONTROL	VARCHAR2(30)	NOT NULL	User that created the component entry
SCHEMA	VARCHAR2(30)	NOT NULL	User that contains the objects for the component
PROCEDURE	VARCHAR2(61)		Validation procedure
STARTUP	VARCHAR2(8)		Indicates whether the component requires a startup after the upgrade (REQUIRED) or not
PARENT_ID	VARCHAR2(30)		Parent component identifier

Note:

1.

select COMP_ID, COMP_NAME, STATUS, MODIFIED, CONTROL, SCHEMA, PROCEDURE

from DBA_SERVER_REGISTRY;

COMP_ID	COMP_NAME	STATUS	MODIFIED	CONTROL	SCHEMA	PROCEDURE
XOQ	Oracle OLAP API	VALID	11-FEB-2007 07:39:14	SYS	SYS	XOQ_VALIDATE
APS	OLAP Analytic Workspace	VALID	11-FEB-2007 07:39:13	SYS	SYS	APS_VALIDATE
CATJAVA	Oracle Database Java Packages	VALID	11-FEB-2007 07:39:11	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
XML	Oracle XDK	VALID	11-FEB-2007 07:39:11	SYS	SYS	XMLVALIDATE
JAVAVM	JServer JAVA Virtual Machine	VALID	11-FEB-2007 07:39:10	SYS	SYS	INITJVMAUX.VALIDATE_JAVAVM
CATPROC	Oracle Database Packages and Types	VALID	11-FEB-2007 07:39:10	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATPROC
CATALOG	Oracle Database Catalog Views	VALID	11-FEB-2007 07:39:09	SYS	SYS	DBMS_REGISTRY_SYS.VALIDATE_CATALOG
ORDIM	Oracle interMedia	VALID	11-FEB-2007 07:39:11	SYS	ORDSYS	VALIDATE_ORDIM
SDO	Spatial	VALID	11-FEB-2007 07:39:11	SYS	MDSYS	VALIDATE_SDO
CONTEXT	Oracle Text	VALID	11-FEB-2007 07:39:11	SYS	CTXSYS	VALIDATE_CONTEXT
XDB	Oracle XML Database	VALID	11-FEB-2007 07:39:12	SYS	XDB	DBMS_REGXDB.VALIDATEXDB
OWM	Oracle Workspace Manager	VALID	11-FEB-2007 07:39:10	SYS	WMSYS	VALIDATE_OWM
WK	Oracle Ultra Search	VALID	11-FEB-2007 07:39:13	SYS	WKSYS	VALIDATE_WK

Oracle data dictionary views

Oracle dynamic performance views

DBA_RGROUP

v

Oracle 11gR1

DBA_RGROUP lists all refresh groups.

Column	Datatype	NULL	Description
REFGROUP	NUMBER		Internal identifier of refresh group
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object in the refresh group
NAME	VARCHAR2(30)	NOT NULL	Name of the object in the refresh group
IMPLICIT_DESTROY	VARCHAR2(1)		(Y or N) If Y, then destroy the refresh group when its last item is removed
PUSH_DEFERRED_RPC	VARCHAR2(1)		(Y or N) If Y, then push changes from snapshot to master before refresh
REFRESH_AFTER_ERRORS	VARCHAR2(1)		(Y or N) If Y, proceed with refresh despite error when pushing deferred RPC's
ROLLBACK_SEG	VARCHAR2(30)		Name of the rollback segment to use while refreshing
JOB	NUMBER	NOT NULL	Identifier of job used to refresh the group automatically
PURGE_OPTION	NUMBER(38)		The method for purging the transaction queue after each push. 1 indicates quick purge option; 2 indicates precise purge option
PARALLELISM	NUMBER(38)		The level of parallelism for transaction propagation
HEAP_SIZE	NUMBER(38)		The size of the heap

Oracle data dictionary views

Oracle dynamic performance views

DBA_TAB_COMMENTS

Oracle 11gR1

DBA_TAB_COMMENTS displays comments on all tables and views in the database. Its columns are the same as those in ALL_TAB_COMMENTS.

Related Views

· ALL_TAB_COMMENTS displays comments on the tables and views accessible to the current user.

· USER_TAB_COMMENTS displays comments on the tables and views 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 object
TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object
TABLE_TYPE	VARCHAR2(11)		Type of the object
COMMENTS	VARCHAR2(4000)		Comment on the object

Note:

1.

select * from dba_tab_comments;

OWNER	TABLE_NAME	TABLE_TYPE	COMMENTS
SYS	DBA_WARNING_SETTINGS	VIEW	warning settings for all objects
SYS	PRODUCT_COMPONENT_VERSION	VIEW	version and status information for component products
SYS	USER_EVALUATION_CONTEXT_VARS	VIEW	variables in user rule evaluation contexts
SYS	ALL_EVALUATION_CONTEXT_VARS	VIEW	variables in all rule evaluation contexts seen by the user
SYS	DBA_EVALUATION_CONTEXT_VARS	VIEW	variables in all rule evaluation contexts in the database
SYS	USER_TUNE_MVIEW	VIEW	tune_mview catalog view owned by the user

Oracle data dictionary views

Oracle dynamic performance views