Progress
DataServer
for ORACLE Guide


Monitoring Locks

Since the DataServer relies only on ORACLE locks, the Progress PROMON utility cannot provide you with information on locks in your database applications. Instead, you can use the SQL MONITOR LOCKS statement to view the current locks for an ORACLE instance. Follow these steps:

  1. Run SQL*DBA.
  2. CONNECT to the database with a DBA user name. For example, this command connects to a database with the DBA user name SYSTEM and password MANAGER.
  3. SQLDBA> CONNECT SYSTEM/MANAGER 
    

  4. Enter the following command.
  5. SQLDBA> MONITOR LOCKS 
    


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095