[Home] [Help] [Dependency Information]

TABLE: SYS.DBMS_LOCK_ALLOCATED

Object Details

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00110736

1. NAME

Unique Key: SYS_C00277486

1. LOCKID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00110736	NORMAL	UNIQUE	SYSTEM	NAME
SYS_C00277486	NORMAL	UNIQUE	SYSTEM	LOCKID
DBMS_LOCK_EXPIRATION_IND	NORMAL	NONUNIQUE	SYSTEM	EXPIRATION

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT NAME
,      LOCKID
,      EXPIRATION
FROM SYS.DBMS_LOCK_ALLOCATED;

Dependencies

[top of page]

SYS.DBMS_LOCK_ALLOCATED does not reference any database object

SYS.DBMS_LOCK_ALLOCATED is referenced by following:

GSMADMIN_INTERNAL

DBMS_GSM_UTILITY - show dependent code

SYS

DBMS_LOCK - show dependent code