Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Locks and latches

The following views provide information about the status of locks and latches within the instance:

*$ACCESS

Lists all locked objects in the database and the sessions accessing these objects.

*$BUFFER_POOL

Provides information about the available buffer pools. The number of buffer pools is related to the initialization parameter DB_BLOCK_LRU_LATCHES.

*$ENQUEUE_LOCK

Lists all locks owned by enqueue state objects.

*$LATCH

Provides statistics for all latches. If the latch is a parent latch, provides a summation of the statistics for each of its children latches. Available after database is opened.

*$LATCH_CHILDREN

Provides statistics for all children latches.

*$LATCH_MISSES

Provides statistics about all failures to acquire a latch.

*$LATCH_PARENT

Provides statistics for all parent latches.

*$LATCHHOLDER

Provides information about current latch holders.

*$LATCHNAME

Provides a decoded latch name for every latch listed in *$LATCH. Available after database is mounted.

*$LOCK

Lists all locks held and all outstanding requests for locks or latches.

*$LOCKED_OBJECT

Lists all objects currently locked by transactions within the system.

*$RESOURCE

Contains the names, types, and addresses of all resources in the system.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page