How to See the Size of Database Block in Oracle

Save

The Oracle database allocates space for all the data in the database. This space is contained in units called database blocks, extents and segments. The data blocks are the smallest units of storage. Although the each operating system also stores data in blocks, Oracle requests data in multiples of the Oracle data blocks. The standard block is held in the DB_BLOCK_SIZE initialization parameter. This parameter is held in the v$parameter view.

Things You'll Need

  • Oracle Database
  • Open a terminal window if you are using a Unix operating system. Open a command prompt window if you are using the Windows operating system. You will be presented with a command prompt where you will type the following commands.

  • Type "sqlplus" to access the SQL*Plus command prompt ("SQL>").

  • Type the command "select value from v$parameter where name = 'db_block_size';" to view the size of the database block.

  • Type "quit" to close SQL*Plus.

  • Type "exit" to close the terminal window or command prompt window.

References

Promoted By Zergnet

Comments

Resources

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!