RE: ORA-00379: no free buffers ... ???

2002-02-27 Thread Khedr, Waleed
hat I got: SQL> select * from dba_data_files; ERROR: ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K I increased the db_block_buffers from 800 to 2000, but still have this error. The db_block_size is 4096. Hours before, I imported a tablespace from another 9i dat

ORA-00379: no free buffers ... ???

2002-02-27 Thread Leslie Lu
Hi, I'm using 9i enterprise edition on Win2000. Here is what I got: SQL> select * from dba_data_files; ERROR: ORA-00379: no free buffers available in buffer pool DEFAULT for block size 8K I increased the db_block_buffers from 800 to 2000, but still have this error. The db_block_size