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

  • How to Calculate Oracle Database Size

    Over time Oracle databases grow incrementally in size. Depending on the size of the organization the growth factor can be such that...

  • Oracle Database Characteristics

    Oracle databases are used with many applications, for large and small organizations operating in a variety of sectors. Powerful, secure and reliable...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

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