Oracle Developer Question:
Download Job Interview Questions and Answers PDF
How to define Data Block size?
Answers:
Answer #1A data block size is specified for each ORACLE database when the database is
created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cannt be changed latter.
created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cannt be changed latter.
Answer #2The standard block size is specified by the initialization parameter DB_BLOCK_SIZE. In addition, you can specify of up to five nonstandard block sizes. The data block sizes should be a multiple of the operating system\\'s block size within the maximum limit to avoid unnecessary I/O. Oracle data blocks are the smallest units of storage that Oracle can use or allocate.
Download Oracle Developer Interview Questions And Answers
PDF
Previous Question | Next Question |
What is Data Block? | What are the components of Physical database structure of Oracle Database? |