RE: Out of Memory

2002-08-17 Thread Ji, Richard
Your db_block_buffers=1048576 times your db_block_size. If your db_block_size is 8k, you need 8gb of RAM. If db_block_size is 4k, you need 4gb of RAM. Richard -Original Message- Sent: Saturday, August 17, 2002 11:13 PM To: Multiple recipients of list ORACLE-L I am getting: SQL

Re: Out of Memory

2002-08-17 Thread ltiu
Aha!!! I actually copied the init.ora file over from a Oracle9i database and I had to rename db_cache_size to db_block_buffers. Guess, what, now I remember - db_block_buffers are in blocks and db_cache_size are in bytes. So I simply renamed the parameter without changing the number : Thanks