What is Data Block?

          

What is Data Block?

<<Previous  Next>>

Oracle - What is Data Block? - Feb 23, 2010 at 11:00 PM by Rajmeet Ghai

What is Data Block?  

Data block is the optimum level of storage. Also known as pages, each data block corresponds to a specific number of bytes. Adjacent data blocks form an extent.

Oracle - What is Data Block? - April 10, 2009 at 11:00 AM

What is Data Block?  

  • Data blocks are also called logical blocks, Oracle blocks, or pages.
  • At the finest level of granularity, Oracle stores data in data blocks.
  • A data block corresponds to a specific number of bytes of physical database space on disk. 

Also read
How are extents allocated to a segment?

An extent is stored some specific information. This information is stored using specific number of adjoining data blocks. A collection of extent is called as a segment stored in the same tablespace.............

Explain the difference between a data block, an extent and a segment.

A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks..............

<<Previous  Next>>



Write your comment - Share Knowledge and Experience


 

 
Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring