Oracle DBMS_GSM_COMMON
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose Global Service Manager Validation Utilities. The package header refers to it as "DBMS package for GWM fixed operations"
AUTHID DEFINER
Constants
Name Data Type Value
AQ Constants
aq_off NUMBER 0
aq_on NUMBER 1
Chunks Constants
chunk_up constant number :=0; NUMBER 0
chunk_readonly NUMBER 1
chunk_down NUMBER 2
ctrlchunk_invalidate NUMBER 11
ctrlchunk_readonly NUMBER chunk_readonly
ctrlchunk_down NUMBER chunk_down
ctrlchunk_up constant number := NUMBER chunk_up
CLB Goal Constants
  NUMBER 1
  NUMBER 2
CLB Goal Constants
clb_goal_none NUMBER 0
clb_goal_short NUMBER 1
clb_goal_long NUMBER 2
Commit Outcome Constants
commit_outcome_off NUMBER 0
commit_outcome_on NUMBER 1
Data Object Number Generator Constants
objnum_range NUMBER 1000000
objnum_wm NUMBER 10000
DataGuard Protection Mode Constants
max_protection NUMBER 0
max_availability NUMBER 1
max_performance NUMBER 2
DB Role Constants
db_role_none NUMBER 0
db_role_primary NUMBER 1
db_role_phys_stby NUMBER 2
db_role_log_stby NUMBER 3
db_role_snap_stby NUMBER 4
Default Drain Timeout Constants
drain_default NUMBER -1
srvc_context_is_db NUMBER 1
srvc_context_is_ocr NUMBER 2
Distributed Transaction Constants
dtp_off NUMBER 0
dtp_on NUMBER 1
Execute DDL Action Constants
execddl_default NUMBER 0
execddl_ignore NUMBER 1
execddl_skip NUMBER 2
Failover Method Constants
failover_none VARCHAR2(5) 'NONE'
failover_basic VARCHAR2(6) 'BASIC'
Failover Primary Constants
failover_primary_off NUMBER 0
failover_primary_on NUMBER 1
Failover Restore Constants
failover_restore_none VARCHAR2(5) 'NONE'
failover_restore_l1 VARCHAR2(6) 'LEVEL1'
Failover Type Constants
failover_type_none VARCHAR2(5) 'NONE'
failover_type_session VARCHAR2(8) 'SESSION'
failover_type_select VARCHAR2(7) 'SELECT'
failover_type_transact VARCHAR2(12) 'TRANSACTION'
failover_type_auto VARCHAR2(4) 'AUTO'
General Constants
max_ident NUMBER 128
Generic Boolean Constants
isFalse NUMBER 0
isTrue NUMBER 1
GSM Flag Constants
gsmflagpos_locality NUMBER 0
gsmflagpos_regionfo NUMBER 1
gsmflagops_orasvc NUMBER 2
HA Notification Constants
ha_notification_off NUMBER 0
ha_notification_on NUMBER 1
Instance Cardinality on RAC Constants
cardinality_uniform VARCHAR2(8) 'UNIFORM'
cardinality_singleton VARCHAR2(10) 'SINGLETON'
isPrimary Constants
is_prim NUMBER 0
is_stby NUMBER 1
is_actstby NUMBER 2
Lag Constants
specified_lag NUMBER 0
any_lag NUMBER 1
Locality Constants
service_anywhere NUMBER 0
service_local_only NUMBER 1
Move Chunk Operation Constants
movechunk_source NUMBER 0
movechunk_target NUMBER 1
movechunk_success NUMBER 0
movechunk_fail NUMBER 1
Move Constants
service_anywhere NUMBER 0
service_local_only NUMBER 1
Package Public Constants
cpu_thresh_param_name VARCHAR2(15) '_gsm_cpu_thresh'
default_cpu_thresh NUMBER 75
default_srlat_thresh NUMBER 20
gsm_parameter_name VARCHAR2(10) '_gsm'
max_inst_default NUMBER 10
max_inst_param_name VARCHAR2(25) '_gsm_max_instances_per_db'
max_regions_default NUMBER 10
max_regions_param_name VARCHAR2(20) '_gsm_max_num_regions'
region_list_parameter_name VARCHAR2(16) '_gsm_region_list'
srlat_thresh_param_name VARCHAR2(17) '_gsm_srlat_thresh'
Policy Constants
policy_manual NUMBER 1
policy_automatic NUMBER 2
Pool/Catalog Constants
pool_notsharded NUMBER 0
pool_sharded NUMBER 1
Preferred ALL DBS Constants
select_dbs NUMBER 0
prefer_all_dbs NUMBER 1
Region Failover Constants
region_failover_off NUMBER 0
region_failover_on NUMBER 1
RLB Goal Constants
rlb_goal_none NUMBER 0
rlb_goal_service_time NUMBER 1
rlb_goal_throughput NUMBER 2
Replication Type Constants
reptype_dg NUMBER 0
reptype_ogg NUMBER 1
Session State Consistency Constants
session_state_static VARCHAR2(7) 'STATIC'
session_state_dynamic VARCHAR2(8) 'DYNAMIC'
Set GSM Parameter Constants
add_gsms NUMBER 0
replace_all_gsms NUMBER 1
remove_gsms NUMBER 2
modify_gsms NUMBER 3
Set Region List Parameter Constants
add_regions NUMBER 0
remove_regions NUMBER 1
modify_regions NUMBER 2
TAF Policy Constants
taf_none constant number := 0; NUMBER 0
taf_basic constant number := 1; NUMBER 1
taf_preconnect constant number := 2; NUMBER 2
Update Mode Constants
noUpdate NUMBER 0
updNoGSM NUMBER 1
updGSM NUMBER 2
Dependencies
DBMS_GSM_ALERTS EXECASUSER PARAM_VALUE_LIST_T
DBMS_GSM_CLOUDADMIN EXECUTEDDL PARAM_VALUE_T
DBMS_GSM_COMMON_LIB EXEC_SQL PLITBLM
DBMS_GSM_DBADMIN GSM_LIST_T RAC_INSTANCE_T
DBMS_GSM_FIXED GSM_T REGION
DBMS_GSM_POOLADMIN GV_$DATABASE REGION_LIST_T
DBMS_GSM_UTILITY INSTANCE_LIST REGION_T
DBMS_LOB LOCAL_CHUNKS UTL_RAW
DBMS_UTILITY LOCAL_CHUNK_TYPES V_$PARAMETER2
DBPARAMS_LIST MESSAGE_PARAM_LIST V_$VERSION
DBPARAMS_T    
Documented No
First Available 12.2
Security Model Owned by GSMADMIN_INTERNAL with EXECUTE granted to GGSYS, GSMADMIN_ROLE, GSMROOTUSER_ROLE, GSM_POOLADMIN_ROLE and GSMUSER_ROLE
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmco.sql

See also catgwmcat.sql
Subprograms
ACTIONUET GETDBPARAMETERSTR NUM2LINEAR
ALTSYSREGISTER GETMSG ONDEMANDBACKUP
ASSERT_NUMBER GETPARAM_DB_NUM_GSM PARAMS_TO_DBPARAM_LIST
ASSERT_QUOTED_COMMA_LIST GETPARAM_GWM_DATABASE_FLAGS REGION_PARAMS_TO_REGION_LIST
BUILDSCHEMALIST GETPARAM_SHARDGROUP_NAME REMOVEBACKUPJOBS
CALLTNSPING GSM_LIST_TO_GSM_PARAMS REREGISTERDB
CALLTNSPINGMULTITARGET GSM_PARAMS_TO_GSM_LIST RESETDBPARAMETER
CHECKDBCOMPAT GWMFACTOR RUNBACKUP
CHUNKLOWHIGH GWMSUBNET RUNSNRINFOBACKUP
CLOBTOTRACE GWSPTSHDGENDDL SERVICECHANGE
CREATEBACKUPJOBS GWSPTSHDXMLTOALTER SETDBPARAMETER
CREATEBACKUPSTOREDSCRIPTS GWSPTSHDXMLTOALTERCLOBS SETGSMPARAMETER
CREATERESTOREPOINTSDB GWSPTSHDXMLTODDL SETINSPLITPSET
DBISDOWNGRADEABLE GWS_IS_DB_REGISTERED SETREGIONLISTPARAMETER
DISABLEAUTOBACKUP INST_LIST_TO_INST_STRING STATUSOFBACKUP
ENABLEAUTOBACKUP ISCDB UPDATECHUNKS
EXISTGSM ISGWMTRACING VERIFYUET
GETCONDBID ISNONORACLECLOUD WRITETOGWMTRACING
GETDBPARAMETERNUM ISUETENABLED  
 
ACTIONUET
Undocumented dbms_gsm_common.actionUET(
module  IN BINARY_INTEGER,
test    IN BINARY_INTEGER,
stage   IN BINARY_INTEGER,
action  IN BINARY_INTEGER,
use_val IN BINARY_INTEGER,
value   IN BINARY_INTEGER);
TBD
 
ALTSYSREGISTER (new 23ai)
Undocumented dbms_gsm_common.altSysRegister((reconnect IN BOOLEAN DEFAULT FALSE);
TBD
 
ASSERT_NUMBER (new 23ai)
Validates that an input is a number dbms_gsm_common.assert_number(val IN VARCHAR2) RETURN VARCHAR2;
TBD
 
ASSERT_QUOTED_COMMA_LIST (new 23ai)
Validates that an input is a comma-delimited, single-quoted list with no spaces between list items dbms_gsm_common.asssert_quoted_comma_list(val IN VARCHAR2) RETURN VARCHAR2;
TBD
 
BUILDSCHEMALIST (new 23ai)
Undocumented dbms_gsm_common.buildSchemaList(lstring IN VARCHAR2) RETURN schema_list_t;
TBD
 
CALLTNSPING (new 23ai)
Calls the TNSPING utility using gwmCallTnsping C callout dbms_gsm_common.callTNSPing(
target_name      IN  VARCHAR2,
target_host_port IN  VARCHAR2,
tnsping_results  OUT VARCHAR2);
DECLARE
 outVal dbms_id;
BEGIN
  gsmadmin_internal.dbms_gsm_common.callTNSPing'FREE', '1521', outVal);
  dbms_output.putline(outVal);
END;
/
FREE(1521)=2

PL/SQL procedure successfully completed.
 
CALLTNSPINGMULTITARGET (new 23ai)
Undocumented dbms_gsm_common.callTNSPingMultiTarget(
tnsping_targets_str IN  VARCHAR2,
tnsping_results     OUT VARCHAR2);
TBD
 
CHECKDBCOMPAT
Check that database level is compatible with GDS dbms_gsm_common.checkDBCompat RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.checkDBCompat THEN
    dbms_output.put_line('This database is compatible');
  ELSE
    dbms_output.put_line('This database is not compatible');
  END IF;
END;
/
 
CHUNKLOWHIGH
Undocumented dbms_gsm_common.chunkLowHigh(
chunk_counter IN  BINARY_INTEGER,
total_chunks  IN  BINARY_INTEGER,
chunk_low     OUT NUMBER,
chunk_high    OUT NUMBER);
TBD
 
CLOBTOTRACE
Reformats a CLOB as a trace dbms_gsm_common.clobToTrace(phrase IN CLOB)
RETURN VARCHAR2;
SELECT gsmadmin_internal.dbms_gsm_common.clobToTrace('This is a test of C2T');

GSMADMIN_INTERNAL.DBMS_GSM_COMMON.CLOBTOTRACE('THISISATESTOFC2T')
-----------------------------------------------------------------
This is a test of C2T
 
CREATEBACKUPJOBS (new 23ai)
Undocumented dbms_gsm_common.createBackupJobs(
repeat_interval_level0 IN BINARY_INTEGER,
repeat_interval_level1 IN BINARY_INTEGER,
sdb_cat_dbid           IN VARCHAR2);
TBD
 
CREATEBACKUPSTOREDSCRIPTS (new 23ai)
Undocumented dbms_gsm_common.createBackupStoredScripts(
backupLevel1Type  IN  BINARY_INTEGER,
sdb_cat_dbid      IN  VARCHAR2,
cookie            OUT BINARY_INTEGER);
TBD
 
CREATERESTOREPOINTSDB (new 23ai)
SDB backup support procedure dbms_gsm_common.createRestorePointSDB(
name IN VARCHAR2,
scn  IN NUMBER);
TBD
 
DBISDOWNGRADEABLE
Returns TRUE if the database downgradeable: Otherwise FALSE dbms_gsm_common.DBisDowngradeable RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.DBisDowngradeable THEN
    dbms_output.put_line('This database can be downgraded');
  ELSE
    dbms_output.put_line('This database cannot be downgraded');
  END IF;
END;
/
 
DISABLEAUTOBACKUP (new 23ai)
Disables jobs associated with the SDB backup dbms_gsm_common.disableAutoBackup(
restore_point_job IN  BOOLEAN,
err_code          OUT BINARY_INTEGER,
err_msg           OUT VARCHAR2);
TBD
 
ENABLEAUTOBACKUP (new 23ai)
Enables jobs associated with the SDB backup dbms_gsm_common.enableAutoBackup(
restore_point_job IN  BOOLEAN,
err_code          OUT BINARY_INTEGER,
err_msg           OUT VARCHAR2);
TBD
 
EXISTGSM
Checks if a gsm_alias already in the _gsm parameter on a database dbms_gsm_common.existGSM(gsm_alias IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.existGSM('ZZYZX') THEN
    dbms_output.put_line('Alias Exists');
  ELSE
    dbms_output.put_line('Alias Does Not Exist');
  END IF;
END;
/
 
GETCONDBID (new 23ai)
Returns the current container's DBID for SDB backups dbms_gsm_common.getConDBID(
con_dbid OUT NUMBER,
status   OUT BINARY_INTEGER);
TBD
 
GETDBPARAMETERNUM
Undocumented dbms_gsm_common.getDBParameterNum(
pname IN VARCHAR2,
pno   IN BINARY_INTEGER)
RETURN BINARY_INTEGER;
SELECT gsmadmin_internal.dbms_gsm_common.getDBParameterNum('_db_num_gsm', 1);
 
GETDBPARAMETERSTR
Undocumented dbms_gsm_common.getDBParameterStr(
pname IN VARCHAR2,
pno   IN BINARY_INTEGER)
RETURN VARCHAR2;
SELECT gsmadmin_internal.dbms_gsm_common.getDBParameterStr('_shardgroup_name', 1);
 
GETMSG
Returns the message text given message number and parameters dbms_gsm_common.getMsg(
message_NUMBER IN  BINARY_INTEGER,
message_text   OUT VARCHAR2,
params         IN  message_param_list DEFAULT message_param_list());
TBD
 
GETPARAM_DB_NUM_GSM
Undocumented dbms_gsm_common.getParam_db_num_gsm RETURN NUMBER;
SELECT gsmadmin_internal.dbms_gsm_common.getParam_db_num_gsm;

GETPARAM_DB_NUM_GSM
-------------------
                  0
 
GETPARAM_GWM_DATABASE_FLAGS
Undocumented dbms_gsm_common.getParam_gwm_database_flags RETURN VARCHAR2;
SELECT gsmadmin_internal.dbms_gsm_common.getParam_gwm_database_flags;
 
GETPARAM_SHARDGROUP_NAME
Undocumented dbms_gsm_common.getParam_shardGroup_name RETURN VARCHAR2;
SELECT gsmadmin_internal.dbms_gsm_common.getParam_shardGroup_name;
 
GSM_LIST_TO_GSM_PARAMS
Undocumented dbms_gsm_common.gsm_list_to_gsm_params(
gsm_list   IN  gsm_list_t,
gsm_params OUT param_value_list_t);
TBD
 
GSM_PARAMS_TO_GSM_LIST
Undocumented dbms_gsm_common.gsm_params_to_gsm_list(gsm_list OUT gsm_list_t);
TBD
 
GWMFACTOR
Factoring. Is GDS licensed? (currently requires enterprise edition) dbms_gsm_common.gwmFactor;
exec gsmadmin_internal.dbms_gsm_common.gwmFactor;

PL/SQL procedure successfully completed.
 
GWMSUBNET
Get subnet string for this host (RAC only) dbms_gsm_common.gwmSubnet(subnet OUT VARCHAR2);
DECLARE
 outVal VARCHAR2(30);
BEGIN
  gsmadmin_internal.dbms_gsm_common.gwmSubnet(outVal);
  dbms_output.put_line(outVal);
END;
/
 
GWSPTSHDGENDDL (new 23ai)
Undocumented dbms_gsm_common.gwsPtShdGenDDL(
object_type IN VARCHAR2,
schema_name IN VARCHAR2,
object_name IN VARCHAR2,
nversion    IN PLS_INTEGER);
TBD
 
GWSPTSHDXMLTOALTER (new 23ai)
Undocumented dbms_gsm_common.gwsPtShdXMLToAlter(
objType IN VARCHAR2,
srcXML  IN CLOB,
destXML IN CLOB)
RETURN sys.ku$_multi_ddls;
TBD
 
GWSPTSHDXMLTOALTERCLOBS (new 23ai)
Undocumented dbms_gsm_common.gwsPTShdXMLToAlterClobs
objType IN VARCHAR2,
srcXML  IN CLOB,
destXML IN CLOB)
RETURN clob_list_t;
TBD
 
GWSPTSHDXMLTODDL (new 23ai)
Undocumented dbms_gsm_common.gwsPtShdXMLToDDL(
xmlDoc  IN CLOB,
objType IN VARCHAR2 := 'TABLE',
docType IN VARCHAR2 := 'XML')
RETURN CLOB;
TBD
 
GWS_IS_DB_REGISTERED (new 23ai)
Undocumented dbms_gsm_common.gws_is_db_registered(ep OUT VARCHAR2) RETURN BOOLEAN;
TBD
 
INST_LIST_TO_INST_STRING
Converts an instance_list to string format dbms_gsm_common.inst_list_to_inst_string(instances IN instance_list) RETURN VARCHAR2;
TBD
 
ISCDB
Returns TRUE if the database is a CDB dbms_gsm_common.isCDB RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.isCDB THEN
    dbms_output.put_line('The database is a CDB');
  ELSE
    dbms_output.put_line('The database is not a CDB');
  END IF;
END;
/
The database is a CDB
 
ISGWMTRACING
Checks if GWM module tracing is enabled dbms_gsm_common.isGWMTracing RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.isGWMTracing THEN
    dbms_output.put_line('The database is Tracing');
  ELSE
    dbms_output.put_line('The database is not Tracing');
  END IF;
END;
/
The database is not Tracing
 
ISNONORACLECLOUD
Returns TRUE if the database is deployed in the Oracle Cloud dbms_gsm_common.isNonOracleCloud RETURN BOOLEAN;
BEGIN
  IF gsmadmin_internal.dbms_gsm_common.isNonOracleCloud THEN
    dbms_output.put_line('Oracle Cloud Deployment');
  ELSE
    dbms_output.put_line('Non-Oracle Cloud Deployment');
  END IF;
END;
/
Non-Oracle Cloud Deployment
 
ISUETENABLED
Undocumented dbms_gsm_common.isUETEnabled RETURN BINARY_INTEGER;
SELECT gsmadmin_internal.dbms_gsm_common.isUETEnabled;

ISUETENABLED
------------
           0
 
NUM2LINEAR
Convert numbers to a linear key representation dbms_gsm_common.num2linear(x IN NUMBER) RETURN BLOB;
DECLARE
 bVar BLOB;
BEGIN
  bVar := gsmadmin_internal.dbms_gsm_common.num2linear(42);
END;
/
 
ONDEMANDBACKUP (new 23ai)
Undocumented dbms_gsm_common.onDemandBackup(
tag            IN  VARCHAR2,
db_unique_name IN  VARCHAR2,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
TBD
 
PARAMS_TO_DBPARAM_LIST
Converts params string in NVP format to dbparams_list type dbms_gsm_common.params_to_dbparam_list(
params   IN  VARCHAR2,
dbname   OUT VARCHAR2,
dbparams OUT dbparams_list)
RETURN BOOLEAN;
TBD
 
REGION_PARAMS_TO_REGION_LIST
Return a the regions parameters in the regions list type dbms_gsm_common.region_params_to_region_list(region_list OUT region_list_t);
TBD
 
REMOVEBACKUPJOBS (new 23ai)
Undocumented dbms_gsm_common.removeBackupJobs;
exec gsmadmin_internal.dbms_gsm_common.removeBackupJobs;

PL/SQL procedure successfully completed.
 
REREGISTERDB
Re-registers database with GSM listeners after some change dbms_gsm_common.reregisterDB;
exec gsmadmin_internal.dbms_gsm_common.reregisterDB;

PL/SQL procedure successfully completed.
 
RESETDBPARAMETER
Resets a GSM parameter
Overload 1		 dbms_gsm_common.resetDBParameter(pname IN VARCHAR2);
TBD
Overload 2 dbms_gsm_common.resetDBParameter(
pname  IN VARCHAR2,
pdb_id IN BINARY_INTEGER)
TBD
 
RUNBACKUP (new 23ai)
Undocumented dbms_gsm_common.runBackup(
incr_level     IN BINARY_INTEGER,
tag            IN VARCHAR2,
db_unique_name IN VARCHAR2,
sdb_cat_dbid   IN VARCHAR2,
cookie         IN BINARY_INTEGER);
TBD
 
RUNSNRINFOBACKUP (new 23ai)
Undocumented dbms_gsm_common.runSNRInfoBackup;
TBD
 
SERVICECHANGE
Signal a service change for registration dbms_gsm_common.serviceChange;
exec gsmadmin_internal.dbms_gsm_common.serviceChange;

PL/SQL procedure successfully completed.
 
SETDBPARAMETER
Sets a GSM parameter in the database

Overload 1		 dbms_gsm_common.setDBParameter(
pname  IN VARCHAR2,
pvalue IN VARCHAR2)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
Overload 2 dbms_gsm_common.setDBParameter(
pname    IN VARCHAR2,
pvalue   IN VARCHAR2,
pdb_id   IN BINARY_INTEGER,
db_uname IN VARCHAR2)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
Overload 3 dbms_gsm_common.setDBParameter(
pname   IN VARCHAR2,
pvalues IN param_value_list_t)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
Overload 4 dbms_gsm_common.setDBParameter(
pname    IN VARCHAR2,
pvalues  IN param_value_list_t,
pdb_id   IN BINARY_INTEGER,
db_uname IN VARCHAR2)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
Overload 5 dbms_gsm_common.setDBParameter(
pname   IN VARCHAR2,
pvalues IN region_list_t)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
Overload 6 dbms_gsm_common.setDBParameter(
pname    IN VARCHAR2,
pvalues  IN region_list_t,
pdb_id   IN BINARY_INTEGER,
db_uname IN VARCHAR2)
ACCESSIBLE BY (PACKAGE dbms_gsm_dbadmin,
               PACKAGE dbms_gsm_pooladmin,
               PACKAGE dbms_gsm_common,
               PACKAGE dbms_gsm_cloudadmin,
               PACKAGE ggsys.ggsharding);
TBD
 
SETGSMPARAMETER
Changes the value of the _gsm parameter on a database dbms_gsm_common.setGSMParameter(
operation IN NUMBER,
gsms      IN gsm_list_t);
TBD
 
SETINSPLITPSET (new 23ai)
Undocumented dbms_gsm_common.setInSplitPSet(rec_val BINARY_INTEGER);
TBD
 
SETREGIONLISTPARAMETER
Changes the value of the _gsm_region_list parameter on a database dbms_gsm_common.setRegionListParameter(
operation IN NUMBER,
regions   IN region_list_t);
TBD
 
STATUSOFBACKUP (new 23ai)
Undocumented dbms_gsm_common.statusOfBackup(
selection  IN     BINARY_INTEGER,
start_time IN     TIMESTAMP DEFAULT NULL,
end_time   IN     TIMESTAMP DEFAULT NULL,
status     IN OUT CLOB);
TBD
 
UPDATECHUNKS
Refresh RDBMS chunks cache dbms_gsm_common.updateChunks;
exec gsmadmin_internal.dbms_gsm_common.updateChunks;

PL/SQL procedure successfully completed.
 
VERIFYUET
Undocumented dbms_gsm_common.verifyUET(
module IN BINARY_INTEGER,
test   IN BINARY_INTEGER,
stage  IN BINARY_INTEGER,
mesg   IN VARCHAR2);
TBD
 
WRITETOGWMTRACING
Prints using the GWM tracing mechanism

Overload 1		 dbms_gsm_common.writeToGWMTracing(phrase IN VARCHAR2);
exec gsmadmin_internal.dbms_gsm_common.writeToGWMTracing('Testing 1, 2, 3');

PL/SQL procedure successfully completed.
Overload 2 dbms_gsm_common.writeToGWMTracing(
phrase IN VARCHAR2,
gdsctl_id NUMBER);
exec gsmadmin_internal.dbms_gsm_common.writeToGWMTracing('Testing 1, 2, 3', 42);

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_DBADMIN
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
DBMS_GSM_UTILITY
DBMS_GSM_XDB
EXCHANGE
What's New In 21c
What's New In 26ai

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