oracle 中pga 与sga的大小怎样来设置? 正常情况下 pga 比sga小许多. 谢谢
解决方案 »
- Oracle SQL Developer连接linux上的11G R2时提示错误
- 创建表空间时,一些选项的问题
- oracle 作业定期执行作业,如某月的1号0辰更新表的数据某一字段为0
- varchar char 问题
- 关于交叉表与FULL JOIN-达人进
- 大家好,高分请教一个Java工程连接 oracle9i 数据库的问题,急!
- [SOS 急急急] oracle日志文件被误删,怎么办哪?
- commit work 与 commit work release的区别
- 散分,从www.Oracle.com上下载的Oracle9i是不是免费的?
- Oracle根据IN字句条件查询显示结果
- orcale安装问题
- 请问ORACLE可不可以run某个日志(比如redo.log)执行日志中所记录的操作
System Global Area (SGA)
• The SGA consists of several memory structures:
– Shared pool
– Database buffer cache
– Redo log buffer
– Other structures (e.g. lock and latch management,statistical data)
• There are two optional memory structures that can be configured within the SGA:
– Large pool
– Java poolProgram Global Area (PGA)
The PGA is memory reserved for each user process
that connects to an Oracle database.