Database Tuning (MOSC)

MOSC Banner

DB_multiblock_read_count

edited Jul 6, 2010 1:15AM in Database Tuning (MOSC) 8 commentsAnswered
Hi All,

 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center