doc

    Name:    filelock.sql

    Author:  Mark Gurry

    The following query shows the number of locks per datafile.

#

SELECT ts_name "Tablespace", file_name, frequency 
  FROM file_ping;

SELECT ts_name "Tablespace", file_name, start_lk, nlocks, blocking
  FROM file_lock;