Oracle Database - Internal Locks

> Database > Oracle Database

1 - About

Internal locks are higher-level, more complex mechanisms than latches and mutexes and serve various purposes.

3 - Type

The database uses the following types of internal locks:

3.1 - Dictionary cache locks

These locks are of very short duration and are held on entries in dictionary caches while the entries are being modified or used. They guarantee that statements being parsed do not see inconsistent object definitions. Dictionary cache locks can be shared or exclusive. Shared locks are released when the parse is complete, whereas exclusive locks are released when the DDL operation is complete.

3.2 - File and log management locks

These locks protect various files.

For example:

Because file and log locks indicate the status of files, these locks are necessarily held for a long time.

Advertising

3.3 - Tablespace and undo segment locks

These locks protect tablespaces and undo segments.

For example:

  • all instances accessing a database must agree on whether a tablespace is online or offline.
  • Undo segments are locked so that only one database instance can write to a segment.

4 - Documentation / Reference

db/oracle/internal_lock.txt · Last modified: 2017/10/27 15:54 by gerardnico