Thank you for visiting Spatial DBA - Oracle and ArcSDE.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
==================================================================
DBA_REGISTRY displays information about the components loaded into the database.
USER_REGISTRY displays information about the components loaded into the database that are owned by the current user.
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
| |
NAMESPACE | VARCHAR2(30) | NOT NULL |
Component namespace
|
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. scripts using DBA_REGISTRY
--script to determine the status of the Oracle JVM and required packages
select comp_name, version, status
from dba_registry;
select owner, status, count(*)
from all_objects
where object_type like '%JAVA%' group by owner, status;
select owner, object_type, count(*)
from all_objects
where object_type like '%JAVA%' and status <> 'VALID'
group by owner, object_type;
select owner, status, object_type, object_name
from all_objects
where object_name like'%DBMS_JAVA%';
select owner, status, object_type, object_name
from all_objects
where object_name like'%INITJVMAUX%';
select *
from v$sgastat
where POOL = 'java pool' or NAME = 'free memory';
show parameter pool_size
show parameter sga
select owner, object_type, status, dbms_java.longname(object_name)
from all_objects
where object_type like '%JAVA%' and status <> 'VALID'; |
2. Example in Oracle Enterprise Edition
select comp_id, comp_name, version, status, schema, procedure
from DBA_REGISTRY;
|
COMP_ID
|
COMP_NAME
|
VERSION
|
STATUS
|
SCHEMA
|
PROCEDURE
|
CATALOG
|
Oracle Database Catalog Views
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATALOG
|
CATPROC
|
Oracle Database Packages and Types
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATPROC
|
OWM
|
Oracle Workspace Manager
|
10.2.0.1.0
|
VALID
|
WMSYS
|
VALIDATE_OWM
|
JAVAVM
|
JServer JAVA Virtual Machine
|
10.2.0.2.0
|
VALID
|
SYS
|
INITJVMAUX.VALIDATE_JAVAVM
|
XML
|
Oracle XDK
|
10.2.0.2.0
|
VALID
|
SYS
|
XMLVALIDATE
|
CATJAVA
|
Oracle Database Java Packages
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
|
ORDIM
|
Oracle interMedia
|
10.2.0.2.0
|
VALID
|
ORDSYS
|
VALIDATE_ORDIM
|
SDO
|
Spatial
|
10.2.0.2.0
|
VALID
|
MDSYS
|
VALIDATE_SDO
|
CONTEXT
|
Oracle Text
|
10.2.0.2.0
|
VALID
|
CTXSYS
|
VALIDATE_CONTEXT
|
XDB
|
Oracle XML Database
|
10.2.0.2.0
|
VALID
|
XDB
|
DBMS_REGXDB.VALIDATEXDB
|
WK
|
Oracle Ultra Search
|
10.2.0.2.0
|
VALID
|
WKSYS
|
VALIDATE_WK
|
APS
|
OLAP Analytic Workspace
|
10.2.0.2.0
|
VALID
|
SYS
|
APS_VALIDATE
|
XOQ
|
Oracle OLAP API
|
10.2.0.2.0
|
VALID
|
SYS
|
XOQ_VALIDATE
|
3. Oracle Standard Edition: For components that are not supported by the Standard Edition, i.e., Oracle Data Mining, Oracle OLAP Catalog, Oracle OLAP Analytic Workspace, Oracle OLAP API, Oracle Spatial, the STATUS in the DBA_REGISTRY view is set to OPTION OFF.
select comp_id, comp_name, version, status, schema, procedure
from DBA_REGISTRY;
|
COMP_ID
|
COMP_NAME
|
VERSION
|
STATUS
|
SCHEMA
|
PROCEDURE
|
CATALOG
|
Oracle Database Catalog Views
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATALOG
|
CATPROC
|
Oracle Database Packages and Types
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATPROC
|
OWM
|
Oracle Workspace Manager
|
10.2.0.1.0
|
VALID
|
WMSYS
|
VALIDATE_OWM
|
JAVAVM
|
JServer JAVA Virtual Machine
|
10.2.0.2.0
|
VALID
|
SYS
|
INITJVMAUX.VALIDATE_JAVAVM
|
XML
|
Oracle XDK
|
10.2.0.2.0
|
VALID
|
SYS
|
XMLVALIDATE
|
CATJAVA
|
Oracle Database Java Packages
|
10.2.0.2.0
|
VALID
|
SYS
|
DBMS_REGISTRY_SYS.VALIDATE_CATJAVA
|
ORDIM
|
Oracle interMedia
|
10.2.0.2.0
|
VALID
|
ORDSYS
|
VALIDATE_ORDIM
|
SDO
|
Spatial
|
9.2.0.7.0
|
OPTION OFF
|
MDSYS
| |
CONTEXT
|
Oracle Text
|
10.2.0.2.0
|
VALID
|
CTXSYS
|
VALIDATE_CONTEXT
|
XDB
|
Oracle XML Database
|
10.2.0.2.0
|
VALID
|
XDB
|
DBMS_REGXDB.VALIDATEXDB
|
Oracle data dictionary views
Last updated: 2009-10-22 Thursday
|
