| General Information |
| Library Note |
Morgan's Library Page Header
|
| 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 |
23ai |
| 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 (new 23ai)  |
| 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 23ai) |
| 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; |
| TBD |