Static Data Dictionary Views, 269 of 452

FILE_LOCK

This Parallel Server view displays the mapping of PCM locks to datafiles as specified in initialization parameter GC_FILES_TO_LOCKS.

See Also:
"GC_FILES_TO_LOCKS" and Oracle8i Parallel Server Concepts.

Column	Datatype	NULL	Description
`FILE_ID`	`NUMBER`	`NOT NULL`	Datafile identifier number (to find 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