Increase the DB_BLOCK_BUFFERS parameter in init.ora file and restart your instance.

Make sure that you have at least DB_BLOCK_BUFFERS >= 4*PROCESSES in order to avoid ORA-00379 error. That is because each Oracle process can pin up to from 4 to DB_BLOCK_BUFFERS/PROCESSES number of buffers at any time.

Hope that helps,

clio_usa
OCP DBA 8/8i/9i
visit our Web Site