遇见一个怪问题，ORA-00379错误？

显示全部楼层 · 2007-10-20 08:38:44

我是以sys身份登陆的，数据库是 10.2.01
执行SQL> select file_name from dba_data_files;
ERROR:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 2K

no rows selected
但执行别的时，可以，什么原因呀
SQL> select * from v$log;
GROUP#THREAD#SEQUENCE#BYTESMEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1
1 29 52428800
1 YES INACTIVE
1948682 18-DEC-07
2
1 30 52428800
1 NOCURRENT
2022229 25-DEC-07
3
1 28 52428800
1 YES INACTIVE
1885240 16-DEC-07

千问 · 2007-10-20 08:38:44

ORA-00379 no free buffers available in buffer pool string for block size stringK

Cause: All buffers in the specified buffer pool for the specified block size are in use and no free buffers are available.
Action: Increase the number of buffers in the specified pool for the specified block size.

千问 · 2007-10-20 08:38:44

是否设置过非标准大小数据块的表空间？

千问 · 2007-10-20 08:38:44

有道理，看下你表空间，有没有什么5k，10k的，或者太小，2k的