Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

coalescing free space

OracleGuy777Jul 9 2008 — edited Jul 9 2008

Hi,

(regarding Oracle 9i, dictionary managed tablespaces)

Am I right in assuming that Oracle will only coalesce extents that are next to one another on disk? And that Oracle will never move data around? I mean, say we have 1M free, then a data block that takes up 64KB, and then another 1M free, will Oracle not move that 64KB block somewhere else so that we can have 2M contiguosly free?

Also, will contiguous blocks always be coalesced into a big extent as possible?

thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 6 2008

Added on Jul 9 2008

#general-database-discussions

2 comments

456 views