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