Oracle DBMS_INTERNAL_ROLLING
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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.0
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;
 
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
 
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 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved