Locking / Documentos / Soporte Técnico / Servicios / Tilsor
 
 

HOW TO SETUP LOCK VIEWS SUCH AS DBA_LOCKS AND DBA_BLOCKERS

Creation Date: 30-JUL-1998
Last Revision Date: 13-DEC-2001

Problem Description:
====================

Your documentation refers to Locking views such as dba_locks and dba_blockers,
but they do not exist.


Search Words:
=============

dba_kgllock, dba_lock, dba_lock_internal, dba_dml_locks, dba_ddl_locks,
dba_waiters

Solution: RUN SCRIPT "CATBLOCK.SQL" TO SET UP LOCK VIEWS

Solution Description:
=====================

You need to run the script called "catblock.sql". This script can be found
in:

$ORACLE_HOME/rdbms/admin/catblock.sql


Solution Explanation:
=====================

The script creates these views, dba_locks and dba_blockers, along with the
following views:

dba_kgllock
dba_lock (dba_locks is synonym for this)
dba_lock_internal
dba_dml_locks
dba_ddl_locks
dba_waiters