Database Administration (MOSC)

MOSC Banner

Intra-block row chaining optimization for update in 12gR2?

edited Oct 11, 2017 8:45PM in Database Administration (MOSC) 2 commentsAnswered

Hello all,

http://orasql.org/2017/04/21/intra-block-row-chaining-optimization-in-12-2/

Intra-block row chaining optimization in 12gR2

In this blog, the author did some tests and he stated:

"Before 12.2: Next row piece can be stored in the same block only with inserts. When you run update, oracle will place new row piece into another block"

"Since 12.2: Oracle optimizes updates too"

I couldn't find any 12gR2 documentation. Would you please confirm or reference me to a document.

Thank you so much!!!

- Trang

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