DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_FILESTATXS

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","FILE#","CREATION_CHANGE#","FILENAME","TS#","TSNAME","BLOCK_SIZE","PHYRDS","PHYWRTS","SINGLEBLKRDS","READTIM","WRITETIM","SINGLEBLKRDTIM","PHYBLKRD","PHYBLKWRT","WAIT_COUNT","TIME","OPTIMIZED_PHYBLKRD","CON_DBID","CON_ID" from INT$DBA_HIST_FILESTATXS
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "FILE#"
, "CREATION_CHANGE#"
, "FILENAME"
, "TS#"
, "TSNAME"
, "BLOCK_SIZE"
, "PHYRDS"
, "PHYWRTS"
, "SINGLEBLKRDS"
, "READTIM"
, "WRITETIM"
, "SINGLEBLKRDTIM"
, "PHYBLKRD"
, "PHYBLKWRT"
, "WAIT_COUNT"
, "TIME"
, "OPTIMIZED_PHYBLKRD"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_FILESTATXS