奇怪，好好的怎么会出现这个错误，在查询表空间的时候
SELECT A.TABLESPACE_NAME "表空间名",
A.TOTAL_SPACE "总空间(M)",
NVL(B.FREE_SPACE, 0) "剩余空间(M)",
A.TOTAL_SPACE - NVL(B.FREE_SPACE, 0) "使用空间(M)",
trunc(NVL(B.FREE_SPACE, 0) / A.TOTAL_SPACE * 100, 2) "剩余百分比%"
FROM (SELECT TABLESPACE_NAME, trunc(SUM(BYTES) / 1024 / 1024 ,2) TOTAL_SPACE
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME, trunc(SUM(BYTES / 1024 / 1024),2) FREE_SPACE
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) B
WHERE A.TABLESPACE_NAME = B.TABLESPACE_NAME(+)
ORDER BY 5
ORA-00379: 缓冲池 DEFAULT 中无法提供 4K 块大小的空闲缓冲区
SQL>
SQL> show parameter sga
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
lock_sga
boolean FALSE
pre_page_sga
boolean FALSE
sga_max_size
big integer 584M
sga_target
big integer 584M
SQL>
SQL> show parameter cache
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
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_advice
stringON
db_cache_size
big integer 0
db_keep_cache_size
big integer 0
db_recycle_cache_size
big integer 0
object_cache_max_size_percentinteger 10
object_cache_optimal_size
integer 102400
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
session_cached_cursors
integer 20
SQL>
|
