| System Gobal Area [message #56525] |
Sun, 06 April 2003 10:17  |
reshma
Messages: 10
Registered: January 2003
|
Junior Member |
|
|
Hi,
I didn't understand this.
what parameter configures the memory area in SGA which buffers recovery information in memory before being written to disk
thanks
reshma
|
|
|
|
| Re: System Gobal Area [message #56530 is a reply to message #56525] |
Mon, 07 April 2003 02:52  |
SK
Messages: 26
Registered: March 2001
|
Junior Member |
|
|
SGA is combination of memory structures and at the time db creation we define the parameters like shared pool size, log buffers etc.
Kindly elaborate your question what exactly u want to do.
|
|
|
|
| Re: System Gobal Area [message #56537 is a reply to message #56525] |
Mon, 07 April 2003 11:14 |
Anand
Messages: 161
Registered: August 1999
|
Senior Member |
|
|
The online redologs and archive logs record recovery data in the disk.
The following parameters/components are part of the SGA:
1. Buffer Cache
2. Shared pool
3. Large pool
4. Redo Log buffer
The memory structure you were referring to ( my guess !) is the 4th item (Redo Log buffer) which holds recovery data in the memory before being committed to online redo log files. They are written in batches.
The size of Redo log buffer is set via the init parameter "LOG_BUFFER".
Hope it's clear.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
