DBA Data[Home] [Help]

VIEW: SYS.FILE_LOCK

Source

View Text - Preformatted

select file_id, file_name,
       tablespace_name ts_name,
       0 start_lk, 0 nlocks, 0 blocking
       from dba_data_files
View Text - HTML Formatted

SELECT FILE_ID
, FILE_NAME
, TABLESPACE_NAME TS_NAME
, 0 START_LK
, 0 NLOCKS
, 0 BLOCKING
FROM DBA_DATA_FILES