Oracle DBMS_XDBT
Version 19.2.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 Utilities for creating and managing conText indexes on the XDB repository.
AUTHID DEFINER
Constants
Name Data Type Value
Filtering Options
USE_NULL_FILTER PLS_INTEGER 1
USE_INSO_FILTER PLS_INTEGER 2
SKIP_DATA PLS_INTEGER 3
Synchronization Options
SYNC_BY_PENDING_COUNT PLS_INTEGER 1
SYNC_BY_TIME PLS_INTEGER 2
SYNC_BY_PENDING_COUNT_AND_TIME PLS_INTEGER 3
Configuration Settings
IndexName VARCHAR2(32) 'XDB.XDB$CI'
IndexMemory VARCHAR2(32) '50M'
Dependencies
CTX_DDL DBMS_LOB PLITBLM
CTX_DOC DBMS_SCHEDULER UTL_GDK
CTX_OUTPUT DBMS_STANDARD XDB$RESOURCE
CTX_STOPWORDS DBMS_XDB XDB_DATASTORE_PROC
CTX_USER_PENDING DBMS_XDBZ0 XMLTYPE
DBMS_ASSERT    
Documented Yes
First Available Not Known
Security Model Owned by XDB with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/dbmsxdbz.sql
Subprograms
 
AUTOSYNCJOBBYCOUNT
Procedure used by dbms_job to automatically sync up the context dbms_xdbt.autoSyncJobByCount(
myIndexName       IN VARCHAR2,
myMaxPendingCount IN NUMBER,
myIndexMemory     IN VARCHAR2);
TBD
 
AUTOSYNCJOBBYTIME
Procedure used by dbms_job to automatically sync up the context index dbms_xdbt.autoSyncJobByTime(
myIndexName   IN VARCHAR2,
myIndexMemory IN VARCHAR2);
TBD
 
CONFIGUREAUTOSYNC
Configures for automatic index synchronization dbms_xdbt.configureAutoSync;
exec xdb.dbms_xdbt.configureAutoSync;
 
CREATEDATASTOREPREF
Creates the datastore preference dbms_xdbt.createDatastorePref;
exec xdb.dbms_xdbt.createDatastorePref;
 
CREATEFILTERPREF
Creates the filter preference dbms_xdbt.createFilterPref;
exec xdb.dbms_xdbt.createFilterPref;
 
CREATEINDEX
Creates the index dbms_xdbt.createIndex;
exec xdb.dbms_xdbt.createIndex;
 
CREATELEXERPREF
Creates the lexer preference dbms_xdbt.createLexerPref;
exec xdb.dbms_xdbt.createLexerPref;
 
CREATEPREFERENCES
Creates all preferences required by the context index on the XDB repository dbms_xdbt.createPreferences;
exec dbms_xdbt.createPreferences;
 
CREATESECTIONGROUPPREF
Creates the section group dbms_xdbt.createSectionGroupPref;
exec xdb.dbms_xdbt.createSectionGroupPref;
 
CREATESTOPLISTPREF
Creates the stoplist dbms_xdbt.createStoplistPref;
exec xdb.dbms_xdbt.createStoplistPref;
 
CREATESTORAGEPREF
Creates the storage preferences dbms_xdbt.createStoragePref;
exec xdb.dbms_xdbt.createStoragePref;
 
CREATEWORDLISTPREF
Creates the wordlist dbms_xdbt.createWordlistPref;
exec xdb.dbms_xdbt.createWordlistPref;
 
DROPPREFERENCES
Drops all preferences required by the context index dbms_xdbt.dropPreferences;
exec dbms_xdbt.dropPreferences;
 
OPTIMIZEINDEX
Optimizes the index dbms_xdbt.optimizeIndex;
exec xdb.dbms_xdbt.optimizeIndex;
 
SETSYNCTIMEOUT
Set a suggested time limit on the SYNC operation, in minutes dbms_xdbt.setSyncTimeout(timeout IN INTEGER := NULL);
exec xdb.dbms_xdbt.setSyncTimeout(10);
 
SYNCINDEX
Syncronize the index dbms_xdbt.syncindex(
myIndexName   IN VARCHAR2 := Indexname,
myIndexMemory IN VARCHAR2 := IndexMemory);
exec xdb.dbms_xdbt.syncindex('UWIdx', '500M');
 
XDB_DATASTORE_PROC
The user-datastore procedure. Oracle recommends that this not be called directly dbms_xdbt.xdb_datastore_proc(
rid    IN            ROWID,
outlob IN OUT NOCOPY CLOB);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_XDBZ
What's New In 18cR3
What's New In 19cR2

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