What is Oracle Block

Published on Author bloggerfiveLeave a comment

The block is small logical storage area

The block is primarily used to store, read and write all oracle data

The oracle data’s are tables, cluster, Index, views and so on

The single data block can hold many table rows

The block size is configurable generally 4kb, 8kb or 32kb

Each data block corresponds to specific number of bytes on physical hard disk

It also know as logical block or page

The Extent is set of neighboring data blocks

The one or more Extent form a Segment



Leave a Reply

Your email address will not be published. Required fields are marked *