eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$CPOOL_CONN_INFO

Object Details

Object Name:	V_$CPOOL_CONN_INFO
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
CMON_ADDR	RAW	(8)
SESSION_ADDR	RAW	(8)
CONNECTION_ADDR	RAW	(8)
USERNAME	VARCHAR2	(1024)
PROXY_USER	VARCHAR2	(1024)
CCLASS_NAME	VARCHAR2	(1024)
PURITY	VARCHAR2	(1024)
TAG	VARCHAR2	(1024)
SERVICE	VARCHAR2	(64)
PROCESS_ID	VARCHAR2	(24)
PROGRAM	VARCHAR2	(48)
MACHINE	VARCHAR2	(64)
TERMINAL	VARCHAR2	(30)
CONNECTION_MODE	VARCHAR2	(1024)
CONNECTION_STATUS	VARCHAR2	(10)
CLIENT_REGID	NUMBER
CURSTATUS_TIME	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CMON_ADDR
,      SESSION_ADDR
,      CONNECTION_ADDR
,      USERNAME
,      PROXY_USER
,      CCLASS_NAME
,      PURITY
,      TAG
,      SERVICE
,      PROCESS_ID
,      PROGRAM
,      MACHINE
,      TERMINAL
,      CONNECTION_MODE
,      CONNECTION_STATUS
,      CLIENT_REGID
,      CURSTATUS_TIME
,      CON_ID
FROM SYS.V_$CPOOL_CONN_INFO;

Dependencies

[top of page]

SYS.V_$CPOOL_CONN_INFO references the following:

SYS.V_$CPOOL_CONN_INFO is referenced by following:

PUBLIC: V$CPOOL_CONN_INFO