Oracle Context Option Administrator's Guide

Library

Product

Contents

Index

APPENDIX A. ConText Server and Queue Views

ConText Server Views
ConText Queue Views

This appendix provides reference information for the ConText Option views which can be used to monitor ConText servers processes and the ConText Option queues (DML and Services).

The views described in this appendix are:

ConText Servers

ConText Queues

ConText Server Views

This section describes the views provided with ConText Option for monitoring the status of ConText servers.

CTX_ALL_SERVERS

This view displays all the ConText servers that have been started, including idle servers and inactive servers. Only users assigned the CTXAPP and CTXADMIN roles can query CTX_ALL_SERVERS.

Column Name Type Description
SER_NAME VARCHAR2(60) ConText server identifier
SER_STATUS VARCHAR2(8) ConText server status (IDLE, RUN, EXIT)
SER_ADMMBX CHAR2(60) Admin pipe mailbox name for ConText server
SER_OOBMBX VARCHAR2(60) Out-of-bound mailbox name for ConText server
SER_SESSION NUMBER ConText server session ID
SER_AUDSID NUMBER ConText server audit session ID
SER_PROCID VARCHAR2(10) ConText server process ID
SER_ PERSON_MASK VARCHAR2(30) Personality mask for ConText server
SER_STARTED_ AT DATE Date on which ConText server was started
SER_IDLE_TIME NUMBER Idle time, in seconds, for ConText server
SER_DB_INSTANCE VARCHAR2(10) Database instance ID
SER_MACHINE VARCHAR2(64) Name of host machine on which ConText server is running

CTX_SERVERS

This view displays only ConText servers that are currently active. Only DBA users and users assigned the CTXADMIN role can query CTX_SERVERS.

ConText Queue Views

This section describes the views provided with ConText Option for monitoring the status of all the ConText Option queues.

CTX_ALL_DML_QUEUE

This view displays a row for each entry in the DML Queue. Only users assigned the CTXADMIN role can query CTX_ALL_DML_QUEUE.

Column Name Type Description
CID NUMBER Text column ID
POL_OWNER VARCHAR2(30) Owner of policy for text column
POL_NAME VARCHAR2(30) Name of policy for text column
SID VARCHAR2(10) Identifier for ConText server working on row (value is PENDING if a ConText server is not yet assigned)
PKEY VARCHAR2(256) Primary key of row being processed
TIME DATE Lower bound of time row was last updated

CTX_ALL_DML_SUM

This view displays the total number of entries in the DML Queue for each text column. Only users assigned the CTXADMIN role can query CTX_ALL_DML_QUEUE.

CTX_ALL_QUEUE

This view displays all of the rows (pending and in progress requests) in the DML Queue. Only users assigned the CTXADMIN role can query CTX_ALL_QUEUE.

Column Name Type Description
CID NUMBER Policy ID
SID VARCHAR2(10) ID (name) of server processing the request (if the request is pending, this column is NULL)
PKEY VARCHAR2(256) Textkey (primary key) of column policy
TIME DATE Lower boundary of time row was last updated
BATCH NUMBER ID of batch in which request is being processed (used for batch DML)

CTX_INDEX_ERRORS

This view displays a row for each document for which ConText indexing failed during a DDL or DML operation. Only users with the CTXADMIN or CTXAPP role can query CTX_INDEX_ERRORS.

When the error that caused the indexing for the document to fail is corrected, you can also use the CTX_DML.REINDEX procedure to manually reindex the errored document once the error condition has been corrected.

Note: Rows in CTX_INDEX_ERRORS are not automatically deleted when the errored documents have been corrected and reindexed. The rows must be manually cleared using CTX_SVC.CLEAR_ERROR.

Column Name Type Description
HANDLE NUMBER Handle ID for errored document
TSTAMP DATE Time stamp
POL_OWNER VARCHAR2(30) Username of Policy owner for text column in which errored document is stored
POL_NAME VARCHAR2(30) Name of Policy for text column in which errored document is stored
PK VARCHAR2(64) Textkey for errored document
ERRORS VARCHAR2(2000) Error text for errored document

CTX_INDEX_STATUS

This view displays the reindexing status of requests (rows) in the DML Queue. Only users assigned the CTXADMIN and CTXAPP roles can query CTX_INDEX_STATUS.

Column Name Type Description
STATUS VARCHAR2(1) Status of DML request
POL_OWNER VARCHAR2(30) Username of policy owner for DML request
POL_NAME VARCHAR2(30) Name of policy for DML request
PK VARCHAR2(256) ID for the document being processed by the DML request

CTX_LING_ERRORS

This view displays all the Linguistic Services requests that have a status of ERROR. Only users with the CTXADMIN or CTXAPP role can query CTX_LING_ERRORS.

Note: Rows in CTX_LING_ERRORS are not automatically deleted when the errored documents have been corrected and reprocessed through the Linguistic Services. The rows must be manually cleared using CTX_SVC.CLEAR_ERROR.

Column Name Type Description
HANDLE NUMBER Handle ID
TSTAMP DATE Time stamp
POL_OWNER VARCHAR2(2000) Username of Policy owner for text column in which document with errored request is stored
POL_NAME VARCHAR2(2000) Name of Policy for text column in which document with errored request is stored
PK VARCHAR2(64) Textkey for document with errored request
ERRORS VARCHAR2(2000) Error text for errored request

CTX_USER_DML_QUEUE

This view displays a row for each of the user's entries in the DML Queue. All users can query CTX_INDEX_STATUS.

Column Name Type Description
CID NUMBER Text column ID
POL_NAME VARCHAR2(30) Name of policy for text column
SID VARCHAR2(10) Identifier for ConText server working on row (value is PENDING if a ConText server is not yet assigned)
PKEY VARCHAR2(256) Primary key of row being processed
TIME DATE Lower bound of time row was last updated

CTX_USER_DML_SUM

This view displays the total number of user's entries in the DML Queue for each text column. All users can query CTX_INDEX_STATUS.

Column Name Type Description
CID NUMBER Text column ID
POL_NAME VARCHAR2(30) Name of policy for text column
CNT NUMBER Count of rows in DML Queue
TSTAMP DATE Minimum time stamp for rows

CTX_USER_QUEUE

This view displays all of the rows (pending and in progress requests) in the DML Queue for policies owned by the current user. Only users assigned the CTXADMIN and CTXAPP roles can query CTX_USER_QUEUE.

CTX_USER_SVCQ

This view displays a row for each Linguistic Services request, as well as a row for each DML or DDL reindexing request, that has a status of ERROR. Only users with the CTXADMIN or CTXAPP role can query CTX_USER_SVCQ.

Column Name Type Description
SVCNO NUMBER
STATUS VARCHCHAR2(1)
SID NUMBER
SERVICE NUMBER
PRIORITY NUMBER
TSTAMP DATE
USERNAME VARCHAR2(30)
PAR1 VARCHAR2(2000)
PAR2 VARCHAR2(2000)
PAR3 VARCHAR2(2000)
PAR4 VARCHAR2(2000)
PAR5 VARCHAR2(2000)
PAR6 VARCHAR2(2000)
PAR7 VARCHAR2(2000)
PAR8 VARCHAR2(2000)
PAR9 VARCHAR2(2000)
PAR10 VARCHAR2(2000)
ERRORS VARCHAR2(2000)

Prev Next

Library

Product

Contents

Index

`Column Name`	`Type`	`Description`
`SER_NAME`	`VARCHAR2(60)`	`ConText server identifier`
`SER_STATUS`	`VARCHAR2(8)`	`ConText server status (IDLE, RUN, EXIT)`
`SER_ADMMBX`	`CHAR2(60)`	`Admin pipe mailbox name for ConText server`
`SER_OOBMBX`	`VARCHAR2(60)`	`Out-of-bound mailbox name for ConText server`
`SER_SESSION`	`NUMBER`	`ConText server session ID`
`SER_AUDSID`	`NUMBER`	`ConText server audit session ID`
`SER_PROCID`	`VARCHAR2(10)`	`ConText server process ID`
`SER_ PERSON_MASK`	`VARCHAR2(30)`	`Personality mask for ConText server`
`SER_STARTED_ AT`	`DATE`	`Date on which ConText server was started`
`SER_IDLE_TIME`	`NUMBER`	`Idle time, in seconds, for ConText server`
`SER_DB_INSTANCE`	`VARCHAR2(10)`	`Database instance ID`
`SER_MACHINE`	`VARCHAR2(64)`	`Name of host machine on which ConText server is running`