OCP-1Z0-053-V12.02-674题
来源:互联网 发布:网络公司名称 编辑:程序博客网 时间:2024/06/06 09:05
674.View the Exhibit to observe the error.
You receive this error regularly and have to shutdown the database instance to overcome the error.
Automatic Shared Memory Management is configured for the instance. What can you do to reduce the
chance of this error in the future?
A. Increase the value of SGA_MAX_SIZE
B. Enable automatic memory management
C. Set the PRE_PAGE_SGA parameter to true
D. Lock the System Global Area (SGA) in memory
Answer: B
答案解析:
使用自动内存管理来自动扩大SHARED_POOL_SIZE的尺寸。
- [oracle@rtest ~]$ 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 or Streams 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.
- // If the error is issued from an Oracle Streams or XStream process,
- // increase the initialization parameter STREAMS_POOL_SIZE or increase
- // the capture or apply parameter MAX_SGA_SIZE.
自动内存管理http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#BGBJAHEJ
- OCP-1Z0-053-V12.02-674题
- OCP-1Z0-053-V12.02-679题
- OCP-1Z0-053-V12.02-591题
- OCP-1Z0-053-V12.02-590题
- OCP-1Z0-053-V12.02-552题
- OCP-1Z0-053-V12.02-551题
- OCP-1Z0-053-V12.02-549题
- OCP-1Z0-053-V12.02-548题
- OCP-1Z0-053-V12.02-234题
- OCP-1Z0-053-V12.02-584题
- OCP-1Z0-053-V12.02-595题
- OCP-1Z0-053-V12.02-184题
- OCP-1Z0-053-V12.02-59题
- OCP-1Z0-053-V12.02-676题
- OCP-1Z0-053-V12.02-667题
- OCP-1Z0-053-V12.02-660题
- OCP-1Z0-053-V12.02-580题
- OCP-1Z0-053-V12.02-323题
- 详细解析Java中抽象类和接口的区别
- gcc 编译器命令总结
- ubuntu 循环登陆(闪退,登陆成功后又跳回登陆界面)
- HDU-1233 还是畅通工程 并查集加Kruskal
- [AIR Android] Flex开发Android应用,用命令行打包APK
- OCP-1Z0-053-V12.02-674题
- 2.WebService之AXIS定制发布
- Asp出现不允许的父路径
- oprofile
- 实现多线程下载(android)
- 内核态和用户态
- Mysql入门笔记
- Spring事务传播特性实例解析
- java 包和访问权限小结