What is a data block?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a data block?

Rating:

A data block is the smallest logical unit of data storage in Oracle. It corresponds to a specific number of bytes of physical database space. The size of a data block is specified by the DB_BLOCK_SIZE initialization parameter at the time of database creation. It cannot be changed after database creation. The size of a data block is usually a multiple of the operating system's block size. It can vary from 2KB to 32KB, depending upon the operating system. If the size of a data block is not specified, by default it is taken as 4KB on most operating systems. Oracle requests data in multiples of data blocks. A data block is also called a logical block, Oracle block, or page.


Rating:



Other articles

Click here to Article home

 
uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.