10.133 V$TEXT_WAITING_EVENTS

V$TEXT_WAITING_EVENTS displays information about Oracle Text index maintenance events that have been delayed due to errors or contentions.

Column	Datatype	Description
OWNER#	NUMBER	Text index owner number
TABLE#	NUMBER	Base table object number
INDEX#	NUMBER	Text index object number
TABLE_PARTITION#	NUMBER	Table partition object number
INDEX_PARTITION#	NUMBER	Index partition object number
EVENT_TYPE	VARCHAR2(26)	Text index maintenance event type: EVENT Stats EVENT Stats Clean up MONITOR OPTIMIZE-Merge OPTIMIZE-Scheduler OPTIMIZE-Scheduler Timeout SYNC-Cleanup batches SYNC-Inspect SYNC-Mapping SYNC-Mapping Timeout SYNC-Postings Concurrent SYNC-Postings Serial SYNC-Ranges SYNC-Scheduler SYNC-Writer
ITERATION	NUMBER	Event retry iteration number This value is a number between 0 and 10.
WAIT_TIME	NUMBER	Total time (in milliseconds) that the event will be waiting
ELAPSED_TIME	NUMBER	Elapsed time (in milliseconds) since the event started waiting The difference between WAIT_TIME and ELAPSED_TIME indicates how much longer the event will be left waiting.
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note:

This view is available starting with Oracle Database 23ai.