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

Dependencies

Only STANDARD

Documented

Yes. Not in the TYPES and PACKAGES reference but rather in the ADMINISTRATOR'S GUIDE E49631-11

Note the warnings and errors. They are not just about sharding. They are a good idea in all cases.

dbms_gsm_fix.validateShard(reptype IN VARCHAR2 DEFAULT 'DG');

SQL> exec dbms_gsm_fix.validateShard('OGG');
INFO: Golden Gate shard validation requested.
INFO: Database role is PRIMARY.
INFO: Database name is ORABASE2.
INFO: Database unique name is orabase2.
INFO: Database ID is 549318987.
INFO: Database open mode is READ WRITE.WARNING: Database not in archivelog mode.
WARNING: Flashback is off.
WARNING: Force logging is off.INFO: Database platform is Microsoft Windows x86 64-bit.
INFO: Database character set is AL32UTF8. This value must match the character set of the catalog database.
INFO: 'compatible' initialization parameter validated successfully.
INFO: Database is a multitenant container database.
INFO: Current container is CDB$ROOT.
INFO: Database is using a server parameter file (spfile).WARNING: db_create_file_dest is not set.
INFO: db_recovery_file_dest set to: 'C:\app2\oracle\recovery_area'
INFO: db_files=200. Must be greater than the number of chunks and/or tablespaces to be created in the shard.
INFO: remote_login_passwordfile set to EXCLUSIVE.WARNING: db_file_name_convert is not set.ERROR: GSMUSER account status is invalid: EXPIRED & LOCKED
ERROR: GSMADMIN_INTERNAL does not have READ privilege on DATA_PUMP_DIR.
ERROR: GSMADMIN_INTERNAL does not have WRITE privilege on DATA_PUMP_DIR.
INFO: DATA_PUMP_DIR is 'C:\app2\oracle\admin\orabase2\dpdump\'.