Oracle Internals

JulianDyke.com

Acknowledgements

Fixed View: X$DNFS_FILES

Versions

Oracle Version	X$ Version
11.1.0.6.0	2

Columns

Version 2

Column Name	Data Type
ADDR	RAW(4)
INDX	NUMBER
INST_ID	NUMBER
FILENAME	VARCHAR2(513)
FILESIZE	NUMBER
SEQNO	NUMBER
PNUM	NUMBER
VERSION	NUMBER
SVR_ID	NUMBER
FLAGS	NUMBER

Indexes

Version 2

Version 2 of this fixed view does not have any indexes