[bbk5138] 第48集 - 第五章 管理内存 03

Java Pool and Streams Pool

• Java pool memory is used in server memory for all session-specific Java code and data in the JVM.
• Streams pool memory is used exclusively by Oracle Streams to:
  • Store buffered queue messages
  • Provide memory for Oracle Streams processes

Redo Log Buffer

• Is a circular buffer in the SGA
• Holds information about changes made to the database
• Contains redo entries that have the information to redo changes made by operations such as DML and DDL

Content transferred by log writer process(LGWR):

• When a user process commits a transaction
• When the redo log buffer is one-third full
• Before a DBWn process writes modified buffers to disk

Oracle Database Memory Parameters

使用Spfile的好处:

spfile是二进制文件.Oracle在运行的过程中，会自动调整各个参数大小，已达到最优的目标；在进行shutdown的时候Oracle会将参数数据保存到spfile中，等下次再启动的时候，会直接使用spfile中的数据.

转载于:https://www.cnblogs.com/arcer/archive/2013/05/27/3102099.html