Oracle9 db_block_size? (Solaris9 64bit O/S)

[marrow]

Created a simple 2Gb database via dbca and the db_block_size defaults to 8192. The system has 2Gb Mem. with each dbase we create we "lose" 350Mb, if we drop the 8192 to 4096 we half our memory usage. Any recommendations or advice please? 4096 has been used on all our 32 bit systems and each databases is allocated?

Thanks

Marrow

 

[SantaMufasa]

Marrow,

By what measure do you "lose" 350MB? Although you can have block sizes of 4096, 2048, or 1024, we usually don't even go there, if anything, we increase to 16384 or 24576 for the sake of speed.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[LKBrwnDBA]

2G is more than enough memory -- Check your initialization parameters, Particularly those related to the SGA (you can ignore db_block_size).

How many databases do you expect to create?



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[marrow]

Hello SantaMufasa,

(I don't really lose memory, please ignore that comment). We are talking about developement dbases, speed is not really the essence but memory is. If 3 db's run separately they can take up too much memory resource and not leave much change. It appears that some of our live system are only using the 4K option, and we are defaulting to 8K.

Many Thanks for comments, I will have rethink.
Marrow

 

[marrow]

Hello LKB,

We are planning 3 -> 4 dbases per dev. system.
This is the SGA of a typical 2Gb Databases running on a 64 bit O/S - 2Gb memory. Processes such as smon/pmon are 390Mb each. Database created via dbca using defaults:-

Total System Global Area 320309648 bytes
Fixed Size 731536 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes

Some other parameters
java_pool_size=115343360
large_pool_size=8388608
shared_pool_size=115343360

We changed shared_pool on another dbase to 60,000,000 and less memory was used, we also removed java_pool the pmon/smon drop to 180MB


Thanks also for your help

Marrow

 

[LKBrwnDBA]

That's the idea, tweek the SGA.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[marrow]

Thanks again to both of you for your help. Looks like I'm almost there.

Marrow