| Server Manager Monitors (Lock and Latch Monitors) | The Monitor feature of Server Manager provides two monitors for displaying lock information of an instance. Refer to the Oracle7 Server Manager User's Guide for complete information about the Server Manager monitors. |
| UTLLOCKT.SQL | The UTLLOCKT.SQL script displays a simple character lock wait-for graph in tree structured fashion. Using any ad hoc SQL tool (such as SQL*Plus) to execute the script, it prints the sessions in the system that are waiting for locks and the corresponding blocking locks. The location of this script file is operating system dependent. (You must have run the CATBLOCK.SQL script before using UTLLOCKT.SQL.) |