db_32k_cache_size 发现只在第一个节点修改,第二个节点没有修改,发现问题,修改之~~
sql> select file_name,tablespace_name,bytes/1024/1024/1024 G,status,autoextensible from dba_data_files order by tablespace_name; select file_name,autoextensible from dba_data_files order by tablespace_name ERROR at line 1: ORA-00379: no free buffers available in buffer pool DEFAULT for block size 32K sql> show parameter 32k NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_32k_cache_size big integer 0 sql> sql> alter system set db_32k_cache_size=1024m sid='hxrundb2'; System altered. sql> sql> select TABLESPACE_NAME,AUTOEXTENSIBLE from dba_data_files ; TABLESPACE_NAME AUT ------------------------------ --- SYSTEM YES SYSAUX YES UNDOTBS1 YES 略................原文链接:/oracle/205766.html