A
ConText Server and Queue Views

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

The topics discussed in this appendix are:

ConText Server Views

This section describes the views provided with ConText 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 or 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 CTXADMIN can query CTX_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

ConText Queue Views

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

CTX_ALL_DML_QUEUE

This view displays a row for each entry in the DML Queue. Only users assigned CTXADMIN 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 policy. Only users assigned CTXADMIN 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
CNT	NUMBER	Count of rows in DML Queue
TSTAMP	DATE	Minimum time stamp for rows

CTX_ALL_QUEUE

This view displays all of the rows (pending and in progress requests) in the DML Queue. Only users assigned CTXADMIN 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 assigned CTXADMIN or CTXAPP can query CTX_INDEX_ERRORS.

When the error that caused the indexing for the document to fail is corrected and automatic DML is enabled, once the table that contains the document has been updated, the document is automatically reindexed.

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 CTXADMIN or CTXAPP 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 assigned CTXADMIN or CTXAPP 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)	Policy owner for column in which document with errored request is stored
POL_NAME	VARCHAR2(2000)	Policy name for 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 CTXADMIN or CTXAPP can query CTX_USER_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 (for batch DML)

CTX_USER_SVCQ

This view displays a row for each Linguistic Services request and each reindexing request (DML or DDL) that has a status of ERROR. Only users assigned CTXADMIN or CTXAPP can query CTX_USER_SVCQ.

Column Name	Type	Description
SVCNO	NUMBER	Services Queue number
STATUS	VARCHCHAR2(1)	Request status
SID	NUMBER	Identifier of server that processed request
SERVICE	NUMBER	Requested service
PRIORITY	NUMBER	Priority of request
TSTAMP	DATE	Lower boundary of time row was last updated
USERNAME	VARCHAR2(30)	Policy owner who submitted request
PAR1-10	VARCHAR2(2000)	Parameters (internal use only)
ERRORS	VARCHAR2(2000)	Error text

A ConText Server and Queue Views