Oracle8i interMedia Text Reference
Release 2 (8.1.6)

Part Number A77063-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Views, 17 of 36


CTX_SERVERS

This view displays ctxsrv servers that are currently active. It can be queried only by CTXSYS.

Column Name  Type  Description 

SER_NAME 

VARCHAR2(60) 

Server identifier 

SER_STATUS 

VARCHAR2(8) 

Server status (IDLE, RUN, EXIT) 

SER_ADMMBX 

VARCHAR2(60) 

Admin pipe mailbox name for server. 

SER_OOBMBX 

VARCHAR2(60) 

Out-of-band mailbox name for server. 

SER_SESSION 

NUMBER 

No Longer Used 

SER_AUDSID 

NUMBER 

Server audit session ID 

SER_DBID 

NUMBER 

Server database ID 

SER_PROCID 

VARCHAR2(10) 

No Longer Used 

SER_PERSON_MASK 

VARCHAR2(30) 

Personality mask for server 

SER_STARTED_AT 

DATE 

Date on which server was started 

SER_IDLE_TIME 

NUMBER 

Idle time, in seconds, for server 

SER_DB_INSTANCE 

VARCHAR2(10) 

Database instance ID 

SER_MACHINE 

VARCHAR2(64) 

Name of host machine on which server is running 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index