关于内存的两个错误
ORA-04030: out of process memory when trying to allocate string bytes (string,string)
Cause: Operating system process private memory was exhausted.
Action: None
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
Cause: Operating system process private memory was exhausted.
Action: None
ORA-04031: unable to allocate string bytes of shared memory ("string","string","string","string")
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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE.
If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
分页/page
在操作系统中，内存分页（英语：Paging）是一种用来管理内存的技术。它的功用主要在于让电脑主内存，可以使用储存在次级内存中的资料。操作系统将次级内存中的资料，分割成固定大小的区块，这被称为分页（pages）。应用分页技术在内存区段上的最大好处，是它允许储存资料的实体位址，可以是不连续的
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25448460/viewspace-742606/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
一则SQL语句调优的问题
下一篇：
解决sqlplus删除方向键等动作乱码
请登录后发表评论
登录
全部评论
