DBA Data[Home] [Help]

VIEW: SYS.V_$LOBSTAT

Source

View Text - Preformatted

select "INST_ID","LOBTSN","LOBRDBA","LOBOBJID","LOBCURRTIME","LOBEXPMQL","LOBSQLMQL","LOBSPCANALTIME","LOBUNDORETTIME","CON_ID" from v$lobstat
View Text - HTML Formatted

SELECT "INST_ID"
, "LOBTSN"
, "LOBRDBA"
, "LOBOBJID"
, "LOBCURRTIME"
, "LOBEXPMQL"
, "LOBSQLMQL"
, "LOBSPCANALTIME"
, "LOBUNDORETTIME"
, "CON_ID"
FROM V$LOBSTAT