快速顯示oracle錯誤號的含義

以前出現ORA-XXXXX的錯誤資訊時，都要翻聯機文件才知道這個錯誤是什麼含義。這次偶然知道可以直接使用oerr命令顯示錯誤含義。記錄一下。

OS: AIX 5L

ORACLE: 9.2.0.7

$ oerr ora 4031
04031, 00000, "unable to allocate %s bytes of shared memory ("%s","%s","%s","%s")"
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: If the shared pool is out of memory, either use the
// dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// INIT.ORA parameters "shared_pool_reserved_size" and
// "shared_pool_size".
// If the large pool is out of memory, increase the INIT.ORA
// parameter "large_pool_size".

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9842/viewspace-156312/，如需轉載，請註明出處，否則將追究法律責任。