Re: DB_BLOCK_BUFFERS * DB_BLOCK_SIZE

Here is a query from my book (see the x$ chapter of the book for elaboration) that will let you know how much of that 800Mb that you are using ... you really don't want to waste it if you're not using it...also, don't forget to save memory for the shared_pool_size (x$ksmsp to get the contiguous free mem) and sort_area_size.

select decode(state,0, 'FREE',
1,decode(lrba_seq,0,'AVAILABLE','BEING USED'), 3, 'BEING USED', state) "BLOCK STATUS", count(*)
from x$bh
group by decode(state,0, 'FREE',
1,decode(lrba_seq,0,'AVAILABLE','BEING USED'), 3, 'BEING USED', state);

BLOCK STATUS      	COUNT(*)
AVAILABLE            	779
BEING USED        	154
FREE              		167

Rich Niemiec
Oracle Performance Tips and Techniques, Oracle Press ISBN: 0078824346 Received on Tue Jun 29 1999 - 14:31:07 CDT