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:

  • NONE

  • SYNC-Mapping Timeout

  • SYNC-Mapping

  • SYNC-Ranges

  • SYNC-Scheduler

  • SYNC-Postings Serial

  • SYNC-Postings Concurrent

  • SYNC-Writer

  • SYNC-Cleanup batches

  • SYNC-Inspect

  • MONITOR

  • EVENT Stats

  • EVENT Stats Clean up

  • OPTIMIZE-Scheduler Timeout

  • OPTIMIZE-Scheduler

  • OPTIMIZE-Merge
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 AI Database 26ai.