Oracle | DBMS_GSM

Oracle DBMS_GSM_SHDUSR Version 23c

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 Global Workload Management Sharding User

AUTHID CURRENT_USER

Dependencies

DBA_OBJECTS	DBMS_GSM_COMMON	DUPLICATED_TABLE$
DBMS_ASSERT	DBMS_GSM_UTILITY	V_$PARAMETER2

Documented No

First Available 23.2

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by GSMADIN_INTERNAL with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsgwmut.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmut.plb

Subprograms

CREATEDBLINK

GETDUPTABLEREFRESHRATE

CREATEDBLINK (new 23c)

Create dblink if chunk_id_old and hunk_id_new are not on the same shard dbms_gsm_shdusr.createDBLink( chunk_id_old IN NUMBER, chunk_id_new IN NUMBER, dblink OUT VARCHAR2);

TBD

GETDUPTABLEREFRESHRATE (new 23c)

Returns the refresh rate of a duplicated table

Returns 0 for tables with REFRESH ON DEMAND dbms_gsm_shdusr.getDupTableRefreshRate(table_objn IN NUMBER) RETURN NUMBER; PRAGMA SUPPLEMENTAL_LOG_DATA(getDupTableRefreshRate, READ_ONLY);

TBD

Related Topics