Hi,
How to check the database block size in oracle? I can not see any db_block_size or db_cache_size parameter and value in init parameter file. It has only db_block_buffers. The database is oracle 9.2.0.4.0.
Thanks
Printable View
Hi,
How to check the database block size in oracle? I can not see any db_block_size or db_cache_size parameter and value in init parameter file. It has only db_block_buffers. The database is oracle 9.2.0.4.0.
Thanks
It should be .
Connect to db & Just check in sqlprompt
show parameter db_block_size
show parameter db_cache_size
U can find the parameter in init.ora