Oracle Text Reference
Release 9.0.1

Part Number A90121-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

Views, 21 of 48


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-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback