[Home] [Help] [Dependency Information]
Object Name: | V_$LOGMNR_PROCESS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
PID | NUMBER | |||
SPID | VARCHAR2 | (24) | ||
ROLE | VARCHAR2 | (32) | ||
USERNAME | VARCHAR2 | (15) | ||
SID | NUMBER | |||
SERIAL# | NUMBER | |||
LATCHWAIT | VARCHAR2 | (16) | ||
LATCHSPIN | VARCHAR2 | (16) | ||
WORK_MICROSEC | VARCHAR2 | (21) | ||
OVERHEAD_MICROSEC | VARCHAR2 | (21) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, PID
, SPID
, ROLE
, USERNAME
, SID
, SERIAL#
, LATCHWAIT
, LATCHSPIN
, WORK_MICROSEC
, OVERHEAD_MICROSEC
, CON_ID
FROM SYS.V_$LOGMNR_PROCESS;
|
|
|