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

VIEW: SYS.GV_$LOBSTAT

Object Details
Object Name: GV_$LOBSTAT
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INST_ID NUMBER

LOBTSN NUMBER

LOBRDBA NUMBER

LOBOBJID NUMBER

LOBCURRTIME NUMBER

LOBEXPMQL NUMBER

LOBSQLMQL NUMBER

LOBSPCANALTIME NUMBER

LOBUNDORETTIME NUMBER

CON_ID NUMBER

Query Text

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


SELECT INST_ID
,      LOBTSN
,      LOBRDBA
,      LOBOBJID
,      LOBCURRTIME
,      LOBEXPMQL
,      LOBSQLMQL
,      LOBSPCANALTIME
,      LOBUNDORETTIME
,      CON_ID
FROM SYS.GV_$LOBSTAT;

Dependencies

[top of page]

SYS.GV_$LOBSTAT references the following:

SYS.GV_$LOBSTAT is referenced by following:

SchemaPUBLIC
SynonymGV$LOBSTAT