Static Data Dictionary Views, 428 of 666

FILE_LOCK

This Oracle Real Application Cluster view displays the mapping of PCM locks to datafiles as specified in initialization parameter GC_FILES_TO_LOCKS.

Column	Datatype	NULL	Description
`FILE_ID`	`NUMBER`	`NOT NULL`	Datafile identifier number (to find the file name, query `DBA_DATA_FILES` or `V$DBFILES`)
`FILE_NAME`	`VARCHAR2(513)`		The datafile name
`TS_NAME`	`VARCHAR2(30)`	`NOT NULL`	The tablespace name for the datafile
`START_LK`	`NUMBER`		The first lock corresponding to the datafile
`NLOCKS`	`NUMBER`		The number of PCM locks allocated to the datafile
`BLOCKING`	`NUMBER`		The number of contiguous blocks protected by each PCM lock on the datafile