truncate table XML_DOC
ERROR at line 1:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 16K
<A href="mailto:sys@>select">sys@>select tablespace_name,block_size from dba_tablespaces;TABLESPACE_NAME BLOCK_SIZE
------------------------------ ----------
SYSTEM 8192
UNDOTBS1 8192
SYSAUX 8192
TEMP 8192
USERS 8192
AUDIT_DATA 8192
DBA_ADMIN 8192
TOOLS 8192
UNDOTBS2 8192
ACTIVE_ASSM 8192
IDX 8192
ACTIVE 8192
ARCHIVE 8192
T_RO 8192
ARCHIDX 8192
LRG_DATA 8192
STATIC 8192
MEDIUM_DATA 8192
ARCHIVE1 8192
ACTIVE_LOB 16384
ARCHIVE_LOB 1638421 rows selected.
show parameter cache_sizeNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_cache_size big integer 0
db_keep_cache_size big integer 0
db_recycle_cache_size big integer 0
show parameter db_block_sizeNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_block_size integer 8192
alter system set db_cache_size=100M scope=both;
alter system set db_16K_cache_size=50M;
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞1
添加新评论0 条评论