DB_multiblock_read_count
I am analysing db_multiple_read_count which is set to 64 currently.So what should be the block size on tablespace level ?Any syntax to create block size or change the block size for optimal performance.my memory details are below:--
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 4G
sga_target big integer 4G
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target big integer 6G
SQL> select sum(bytes/1024/1024/1024) from dba_data_files;
SUM(BYTES/1024/1024/1024)
-------------------------
1473.22961
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
__db_cache_size big integer 1392M
db_16k_cache_size big integer 0