Oracle DBMS_ISYNCREF
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 Undocumented. The name is interesting but the nature of the functionality and why it might be valuable a bit obscure at present.
AUTHID DEFINER
Dependencies
ALL_IND_PARTITIONS DBA_INDEXES DBMS_STANDARD
ALL_IND_SUBPARTITIONS DBA_MVIEWS DBMS_SYNC_REFRESH_INTERNAL
ALL_PART_INDEXES DBA_PART_INDEXES DBMS_SYSTEM
ALL_PART_TABLES DBA_TABLES KU$_PARSED_ITEM
ALL_SUBPART_KEY_COLUMNS DBMS_ASSERT KU$_PARSED_ITEMS
ALL_TAB_PARTITIONS DBMS_LOB PLITBLM
ALL_TAB_SUBPARTITIONS DBMS_METADATA SYNCREF$_GROUPS
Documented No
First Available 12.1.0
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtsnap.plb
Subprograms
 
CREATE_INDEX
Undocumented dbms_isyncref.create_index(
owner_in       IN VARCHAR2,
table_name_in  IN VARCHAR2,
new_tablespace IN VARCHAR2,
ot_name        IN VARCHAR2,
pnum           IN NUMBER,
subpnum        IN NUMBER,
is_mv          IN NUMBER,
max_attempts   IN NUMBER);
TBD
 
CREATE_TABLE
Undocumented dbms_isyncref.create_table(
owner_in       IN  VARCHAR2,
table_name_in  IN  VARCHAR2,
new_tablespace IN  VARCHAR2,
pnum           IN  NUMBER,
subpnum        IN  NUMBER,
is_mv          IN  NUMBER,
max_attempts   IN  NUMBER,
num_attempts   OUT NUMBER,
new_table_name OUT VARCHAR2);
conn sys@pdbdev as sysdba

CREATE TABLE zzyzx AS
SELECT * FROM seq$;

DECLARE
 na NUMBER;
 ntn VARCHAR2(128);
BEGIN
  dbms_isyncref.create_table('SYS', 'ZZYZX', 'SYSTEM', 1, 1, 1, 10, na, ntn);
  dbms_output.put_line(TO_CHAR(na));
  dbms_output.put_line(ntn);
END;
/
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_ISYNCREF", line 728
ORA-06512: at line 5
 
LOCKING_PRIMITIVE
Undocumented dbms_isyncref.locking_primitive(
in_group_id       IN NUMBER,
lock_flag_set_val IN NUMBER)
RETURN NUMBER;
TBD

Related Topics
Built-in Functions
Built-in Packages
Indexes
Materialized Views
Partitioning
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