Oracle DBMS_INTERNAL_ROLLING
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Utilities supporting rolling upgrades and patches
AUTHID DEFINER
Dependencies
DBMS_ROLLING_LIB ROLLING$DIRECTIVES ROLLING$PLAN
ROLLING$CONNECTIONS ROLLING$EVENTS ROLLING$STATISTICS
ROLLING$DATABASES ROLLING$PARAMETERS ROLLING$STATUS
Documented No
First Available 12.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtrupgis.plb
Subprograms
 
DESTROY_META
Undocumented dbms_internal_rolling.destroy_meta;
exec dbms_internal_rolling.destroy_meta;

PL/SQL procedure successfully completed.
 
INSERT_DGLRDDIR
Undocumented dbms_internal_rolling.insert_dglrddir(
directid_i    IN NUMBER,
phase_i       IN NUMBER,
taskid_i      IN NUMBER,
feature_i     IN VARCHAR2,
description_i IN VARCHAR2,
target_i      IN NUMBER,
flags_i       IN VARCHAR2,
opcode_i      IN NUMBER,
p1_i          IN VARCHAR2,
p2_i          IN VARCHAR2,
p3_i          IN VARCHAR2,
spare1_i      IN NUMBER,
spare2_i      IN NUMBER,
spare3_i      IN VARCHAR2);
TBD
 
INSERT_DGLRDEVT
Undocumented dbms_internal_rolling.insert_dglrdevt(
eventid_i    IN NUMBER,
instid_i     IN NUMBER,
revision_i   IN NUMBER,
event_time_i IN TIMESTAMP,
type_i       IN VARCHAR2,
status_i     IN NUMBER,
message_i    IN VARCHAR2,
spare1_i     IN NUMBER,
spare2_i     IN NUMBER,
spare3_i     IN VARCHAR2);
TBD
 
IS_IDX_UNSUPPORTED
Undocumented dbms_internal_rolling.is_idx_unsupported(is_unsupported OUT BOOLEAN);
DECLARE
 outVal BOOLEAN;
BEGIN
  dbms_internal_rolling.is_idx_unsupported(outVal);
  IF outVal THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
IS_PLSQL_PRAGMA (new 21c)
Undocumented dbms_internal_rolling.is_plsql_pragma(is_pragmad OUT BOOLEAN);
DECLARE
 outVal BOOLEAN;
BEGIN
  dbms_internal_rolling.is_plsql_pragma(outVal);
  IF outVal THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
SET_UPGRADE_FLAGS
Set the rolling upgrade flag dbms_internal_rolling.set_upgrade_flag(
dgid_i  IN NUMBER,
flags_i IN NUMBER,
value_i IN NUMBER);
TBD
 
UPDATE_DGLRDINS_PROGRESS
Undocumented dbms_internal_rolling.jupdate_dglrdins_progress(
progress_i  IN NUMBER,
exec_info_i IN VARCHAR2,
instid_i    IN NUMBER,
revision_i  IN NUMBER);
TBD
 
UPSERT_DGLRDCON
Undocumented dbms_internal_rolling.upsert_dglrdcon(
source_rdbid_i    IN NUMBER,
dest_rdbid_i      IN NUMBER,
attributes_i      IN NUMBER,
service_name_i    IN VARCHAR2,
conn_handle_i     IN NUMBER,
connect_time_i    IN TIMESTAMP,
send_time_i       IN TIMESTAMP,
disconnect_time_i IN TIMESTAMP,
update_time_i     IN TIMESTAMP,
source_pid_i      IN NUMBER,
dest_pid_i        IN NUMBER,
spare1_iI         IN NUMBER,
spare2_i I        IN NUMBER,
spare3_i I        IN VARCHAR2);
TBD
 
UPSERT_DGLRDDAT
Undocumented dbms_internal_rolling.upsert_dglrddat(
rdbid_i         IN NUMBER,
attributes_i    IN NUMBER,
attributes2_i   IN NUMBER,
dbun_i          IN VARCHAR2,
dbid_i          IN NUMBER,
prod_rscn_i     IN NUMBER,
prod_rid_i      IN NUMBER,
prod_scn_i      IN NUMBER,
cons_rscn_i     IN NUMBER,
cons_rid_i      IN NUMBER,
cons_scn_i      IN NUMBER,
engine_status_i IN NUMBER,
version_i       IN VARCHAR2,
redo_source_i   IN NUMBER,
update_time_i   IN TIMESTAMP,
revision_i      IN NUMBER,
spare1_i        IN NUMBER,
spare2_i        IN NUMBER,
spare3_i        IN VARCHAR2);
TBD
 
UPSERT_DGLRDINS
Undocumented dbms_internal_rolling.upsert_dglrdins(
instid_i      IN NUMBER,
batchid_i     IN NUMBER,
directid_i    IN NUMBER,
taskid_i      IN NUMBER,
revision_i    IN NUMBER,
phase_i       IN NUMBER,
status_i      IN NUMBER,
progress_i    IN NUMBER,
source_i      IN NUMBER,
target_i      IN NUMBER,
rflags_i      IN NUMBER,
opcode_i      IN NUMBER,
p1_i          IN VARCHAR2,
p2_i          IN VARCHAR2,
p3_i          IN VARCHAR2,
p4_i          IN VARCHAR2,
description_i IN VARCHAR2,
exec_status_i IN NUMBER,
exec_info_i   IN VARCHAR2,
exec_time_i   IN TIMESTAMP,
finish_time_i IN TIMESTAMP,
post_status_i IN NUMBER,
spare1_i      IN NUMBER,
spare2_i      IN NUMBER,
spare3_i      IN VARCHAR2);
TBD
 
UPSERT_DGLRDPAR
Undocumented dbms_internal_rolling.upsert_dglrdpar(
scope_i      IN NUMBER,
name_i       IN VARCHAR2,
id_i         IN NUMBER,
descrip_i    IN VARCHAR2,
type_i       IN NUMBER,
datatype_i   IN NUMBER,
attributes_i IN NUMBER,
curval_i     IN VARCHAR2,
lstval_i     IN VARCHAR2,
defval_i     IN VARCHAR2,
minval_i     IN NUMBER,
maxval_i     IN NUMBER,
spare1_i     IN NUMBER,
spare2_i     IN NUMBER,
spare3_i     IN VARCHAR2);
TBD
 
UPSERT_DGLRDSTA
Undocumented dbms_internal_rolling.upsert_dglrdsta(
statid_i      IN NUMBER,
rdbid_i       IN NUMBER,
attributes_i  IN NUMBER,
type_i        IN NUMBER,
name_i        IN VARCHAR2,
valuestr_i    IN VARCHAR2,
valuenum_i    IN NUMBER,
valuets_i     IN TIMESTAMP,
valueint_i    IN INTERVAL DAY TO SECOND,
update_time_i IN TIMESTAMP,
spare1_i      IN NUMBER,
spare2_i      IN NUMBER,
spare3_i      IN VARCHAR2);
TBD
 
UPSERT_DGLRDSTS
Undocumented dbms_internal_rolling.upsert_dglrdsts(
revision_i     IN NUMBER,
phase_i        IN NUMBER,
batchid_i      IN NUMBER,
status_i       IN NUMBER,
coordid_i      IN NUMBER,
oprimary_i     IN NUMBER,
fprimary_i     IN NUMBER,
pid_i          IN NUMBER,
instance_i     IN NUMBER,
dbtotal_i      IN NUMBER,
dbactive_i     IN NUMBER,
location_i     IN VARCHAR2,
init_time_i    IN TIMESTAMP,
build_time_i   IN TIMESTAMP,
start_time_i   IN TIMESTAMP,
switch_time_i  IN TIMESTAMP,
finish_time_i  IN TIMESTAMP,
last_instid_i  IN NUMBER,
last_batchid_i IN NUMBER,
spare1_i       IN NUMBER,
spare2_i       IN NUMBER,
spare3_i       IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_ROLLING
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx