Database Tuning (MOSC)

MOSC Banner

oracle latches

edited Aug 26, 2018 5:08AM in Database Tuning (MOSC) 11 commentsAnswered

Dear Support,

Oracle sessions share information in the buffer cache, shared pool, and other sections of the shared memory known as the system global area (SGA). It’s essential that the integrity of SGA memory is maintained, so Oracle needs a way to prevent two sessions from trying to change the same piece of shared memory at the same time. Latches and mutexes serve this purpose.

Need your help in understanding what exactly it means by "Latches/mutes prevent two sessions from trying to change the same piece of shared memory at the same time"

Thanks for the wonderful support

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center