DBA Data[Home] [Help]

VIEW: SYS.V_$CLONEDFILE

Source

View Text - Preformatted

select "SNAPSHOTFILENAME","CLONEFILENAME","SNAPSHOTBLKREAD","SNAPSHOTREQUEST","FILENUMBER","CON_ID","BLOCKS_ALLOCATED" from v$clonedfile
View Text - HTML Formatted

SELECT "SNAPSHOTFILENAME"
, "CLONEFILENAME"
, "SNAPSHOTBLKREAD"
, "SNAPSHOTREQUEST"
, "FILENUMBER"
, "CON_ID"
, "BLOCKS_ALLOCATED"
FROM V$CLONEDFILE