Menu
Is there a way I can tell the block size of my Oracle database if I don't have access to the v$parameter view?
Thanks!
f.
436
DB_BLOCK_SIZE specifies (in bytes) the size of Oracle database blocks. Typical values are 4096 and 8192 . The value of this parameter must be a multiple of the physical block size at the device level. The value for DB_BLOCK_SIZE in effect at the time you create the database determines the size of the blocks.
Block size also affects the total amount of data that an Oracle database can store. As of Oracle 10g, each data file of the database can store 4 billion blocks, and each database can have up to 65,536 files. With these limits, the maximum database size is shown for each block size in Table 9.
The block size in an Oracle database CANNOT be changed after the database is created. The reason is because Oracle tracks a lot of information based on block number.
The DB block size is one of the Oracle system parameters. The default DB block size cannot be changed once the database is created, but multiple DB block sizes can be set up to meet the requirement.
You could do this:
select distinct bytes/blocks from user_segments; If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
