Database Administration (MOSC)

MOSC Banner

How does an update statement work at architecture point of view? And where do the rollback segments

edited Jun 23, 2019 7:15AM in Database Administration (MOSC) 4 commentsAnswered

Hello team,

Please help me in understanding of the internal mechanism "How does an update statement work?, And I heard that the copy of "Before Image (BI) " is kept in the SGA, and oracle allocates an empty buffer.

where do the rollback segments present? In the SGA or in the physical undo dbf files? Also explain how do we get ora-01555 snapshot too old error?

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