| General Information |
| Purpose |
Internal functions used by SYS during upgrade/downgrade |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmscr.sql |
| First Available |
2006 |
| Dependencies |
| DBA_SEGMENTS |
PLITBLM |
| DBA_TRIGGERS |
REGISTRY$ |
| DBMS_ASSERT |
REGISTRY$HISTORY |
| DBMS_OUTPUT |
REGISTRY$LOG |
| DBMS_REGISTRY |
REGISTRY$SCHEMAS |
| DBMS_SESSION |
USER$ |
| DBMS_STATS |
UTL_FILE |
| DBMS_SYSTEM |
V$INSTANCE |
| DBMS_SYS_ERROR |
V$OPTION |
| DUAL |
X$KSPPCV |
| OBJ$ |
X$KSPPI |
|
| Security Model |
Owned by SYS with no granted privileges |
| |
| CHECK_COMPONENT_DOWNGRADES |
| Undocumented |
dbms_registry_sys.check_component_downgrades; |
| exec dbms_registry_sys.check_component_downgrades; |
| |
| CPU_SCRIPT |
| Undocumented |
dbms_registry_sys.cpu_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.cpu_script('APEX')
FROM dual; |
| |
| DBDWG_SCRIPT |
| Returns the name of the script that downgrades the component |
dbms_registry_sys.dbdwg_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.dbdwg_script('APEX')
FROM dual; |
| |
| DBUPG_SCRIPT |
| Returns the name of the script that upgrades the component |
dbms_registry_sys.dbupg_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.dbupg_script('APEX')
FROM dual; |
| |
| DIAGNOSTICS |
| Undocumented |
dbms_registry_sys.diagnostics RETURN NUMBER; |
SELECT dbms_registry_sys.diagnostics
FROM dual; |
| |
| DROP_USER |
| One might assume that this can be used to drop a user. One might assume so incorrectly it would seem. |
dbms_registry_sys,drop_user(username IN VARCHAR2); |
SQL> exec dbms_registry_sys.drop_user('MECHID');
PL/SQL procedure successfully completed.
SQL> select username from dba_users where username like 'M%';
USERNAME
------------------------------
MLIB
MGMT_VIEW
MECHID
MDDATA
MDSYS |
| |
| GATHER_STATS |
| Undocumented |
dbms_registry_sys.gather_stats(comp_id IN VARCHAR2); -- Default (NULL) gathers for all components |
-- see also {$ORACLE_HOME}/rdbms/admin/cmpupend.sql
exec dbms_registry_sys.gather_stats(NULL); |
| |
| PATCH_SCRIPT |
| Returns the name of the script that patches the component |
dbms_registry_sys.patch_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.patch_script('APEX')
FROM dual;
SELECT dbms_registry_sys.patch_script('XDB')
FROM dual; |
| |
| POPULATE |
| Undocumented |
dbms_registry_sys.populate; |
| exec dbms_registry_sys.populate; |
| |
| POPULATE_101 |
| Undocumented |
dbms_registry_sys.populate_101; |
| exec dbms_registry_sys.populate_101; |
| |
| POPULATE_102 |
| Undocumented |
dbms_registry_sys.populate_102; |
| exec dbms_registry_sys.populate_102; |
| |
| POPULATE_92 |
| Undocumented |
dbms_registry_sys.populate_92; |
| exec dbms_registry_sys.populate_92; |
| |
| RECORD_ACTION |
| Undocumented |
dbms_registry_sys.record_action(
action IN VARCHAR2,
action_id IN NUMBER,
comments IN VARCHAR2); |
| TBD |
| |
| RELOD_SCRIPT |
| Returns the name of the script that reloads the component |
dbms_registry_sys.relod_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.relod_script('APEX')
FROM dual; |
| |
| REMOVAL_SCRIPT |
| Returns the name of the script that removes the component |
dbms_registry_sys.removal_script(comp_id IN VARCHAR2) RETURN VARCHAR2; |
SELECT dbms_registry_sys.removal_script('APEX')
FROM dual; |
| |
| SET_REGISTRY_CONTEXT |
| Undocumented |
dbms_registry_sys.set_registry_context(ctx_variable IN VARCHAR2, ctx_value IN VARCHAR2); |
| TBD |
| |
| TIME_STAMP |
| Undocumented |
dbms_registry_sys.time_stamp(comp_id IN VARCHAR2) RETURN VARCHAR2; |
-- see {$ORACLE_HOME}/rdbms/admin/cmpupend.sql.
This example collects optimizer stats for all server component schemas
SELECT dbms_registry_sys.time_stamp('STATS_BGN') as timestamp FROM dual;
-- STATS_BGN is not a registry component last time I looked |
| |
| VALIDATE_CATALOG |
| Undocumented |
dbms_registry_sys.validate_catalog; |
| exec dbms_registry_sys.validate_catalog; |
| |
| VALIDATE_CATJAVA |
| Undocumented |
dbms_registry_sys.validate_catjava; |
| exec dbms_registry_sys.validate_catjava; |
| |
| VALIDATE_CATPROC |
| Undocumented |
dbms_registry_sys.validate_catproc; |
| exec dbms_registry_sys.validate_catproc; |
| |
| VALIDATE_COMPONENTS |
| Undocumented |
dbms_registry_sys.validate_components; |
| exec dbms_registry_sys.validate_components; |
