Oracle DBMS_GSM_FIXED
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Global Service Manager Validation Utilities. The package header refers to it as "DBMS package for GWM fixed operations"
AUTHID DEFINER
Data Types TYPE name_list IS TABLE OF VARCHAR2(gsmadmin_internal.dbms_gsm_common.max_ident)
INDEX BY BINARY_INTEGER;

TYPE connect_list IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
Dependencies
ATTRCOL$ DBMS_METADATA USER$
COL$ DBMS_SYS_ERROR V$DATABASE
DBMS_ASSERT DUAL V$DG_BROKER_CONFIG
DBMS_DRS KU$_DDL V$FS_FAILOVER_OBSERVERS
DBMS_GSM_COMMON KU$_DDLS V$LOG
DBMS_GSM_DBADMIN OBJ$ V$PARAMETER
DBMS_GSM_UTILITY PLITBLM V$STANDBY_LOG
Documented Yes. Not in the TYPES and PACKAGES reference but rather in the ADMINISTRATOR'S GUIDE E49631-11
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL, GSMUSER. GGSYS, and SYSDG
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
Subprograms
 
FIXBC (new 18c)
Undocumented dbms_gsm_fixed.fixBC(
standby_db       IN  VARCHAR2,
standby_conn_str IN  VARCHAR2,
old_db_name      IN  VARCHAR2,
prot_mode        IN  NUMBER,
err_num          OUT NUMBER,
err_string       OUT VARCHAR2);
TBD
 
GETCOLUMNINFOEX (new 18c)
Undocumented dbms_gsm_fixed.getColumnInfoEx(
object_owner IN  VARCHAR2,
object_name  IN  VARCHAR2,
column_name  IN  VARCHAR2,
col_type     OUT NUMBER,
adt_num      OUT NUMBER);
TBD
 
GETTABLESPACEDDLINTERNAL
Undocumented dbms_gsm_fixed.getTablespaceDDLInternal(
tablespaceName  IN VARCHAR2,
remapName       IN VARCHAR2 DEFAULT NULL)
RETURN VARCHAR2;
TBD
 
SETUPBC
Undocumented dbms_gsm_fixed.setupBC(
primary_db       IN VARCHAR2,
prim_conn_str    IN VARCHAR2,
prot_mode        IN NUMBER,
standby_dbs      IN name_list,
standby_conn_str IN  connect_list,
err_num          OUT NUMBER,
err_string       OUT VARCHAR2);
TBD
 
VALIDATEPARAMETERS
Undocumented dbms_gsm_fixed.validateParameters(reptype IN NUMBER);
exec dbms_gsm_fixed.validateParameters(1);

Related Topics
Built-in Functions
Built-in Packages
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_COMMON
DBMS_GSM_DBADMIN
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_GSM_XDB
What's New In 12cR2
What's New In 18cR3

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