Error Description:
-------------------------------
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-00379: no free buffers available in buffer pool DEFAULT for block size 4K
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235
Cause of the Problem:
---------------------------------------------
With using oracle message we get,
SQL> !oerr ora 00379
00379, 00000, "no free buffers available in buffer pool %s for block size %sK"
// *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
So we get ORA-00379 when for the specified block size there is no free buffers are available. Here we see from error message we get block size 4K.
Solution of The problem:
----------------------------
As oracle recommends increase the size of the 4K buffer pool.
SQL> alter system set db_4k_cache_size=100M;
System altered.
No comments:
Post a Comment