Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index