Re: Tuning questions (may be stupid)

> How do I know how much additional memory each buffer I add will take?

• =

Normally, you have a parameter DB_BLOCK_SIZE in INIT.ORA or INITxxxx.ORA (instance initialization file). You CANNOT change this paramater if your database has been created !

The default size is OS dependant but is often 4096 (bytes). Is you add 1 buffer, you use DB_BLOCK_SIZE bytes of memory.

Best regards.

Fr=E9d=E9ric JUGE
Tarkus_at_Wanadoo.fr
"There's nothing to try, you do it, or you don't" Yoda. Received on Mon Nov 17 1997 - 00:00:00 CST