December 2002
Intermediate to advanced
928 pages
85h 29m
English
The following views provide information about the current status of locks in the database:
Lists all sessions holding locks for whose release others are waiting.
Shows which locks the current user has allocated.
Lists all existing DDL locks.
Lists all existing DML locks.
Lists all KGL (Kernel Generic Library cache) locks in the database.
Contains internal information for each lock defined in *_LOCKS.
Lists all locks held or requested in the database.
Lists all sessions that are waiting on a lock held by another session.