Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Static Data Dictionary Views, 138 of 452


DBA_DDL_LOCKS

DBA_DDL_LOCKS lists all DDL locks held in the database and all outstanding requests for a DDL lock.

Column  Datatype  NULL  Description 

SESSION_ID 

NUMBER 

 

Session identifier 

OWNER 

VARCHAR2(30) 

 

Owner of the lock 

NAME 

VARCHAR2(30) 

 

Name of the lock 

TYPE 

VARCHAR2(40) 

 

Lock type: CURSOR, TABLE/PROCEDURE/TYPE, BODY, TRIGGER, INDEX, CLUSTER 

MODE_HELD 

VARCHAR2(9) 

 

Lock mode: NONE, NULL, SHARE, EXCLUSIVE 

MODE_REQUESTED 

VARCHAR2(9) 

 

Lock request type: NONE, NULL, SHARE, EXCLUSIVE 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index