| SGA [message #63738] |
Wed, 03 November 2004 18:35  |
IA
Messages: 91
Registered: March 2004
|
Member |
|
|
Hi Everyone,
Can some one please explain to me which is which???
Total System Global Area 186616096 bytes
Fixed Size 731424 bytes
Variable Size 150994944 bytes
Database Buffers 33554432 bytes
Redo Buffers 1335296 bytes
I know redo buffers is for the redo log buffer, I know that database buffers is for the db buffer. Which one is the shared pool buffer?
ie, what is fixed size buffer and what is variable size buffer?
Thanks ... IA
|
|
|
|
| Re: SGA [message #63739 is a reply to message #63738] |
Wed, 03 November 2004 19:53  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
Total System Global Area : This is the total size of the SGA which u have allocated it depends on the parameter sga_max_size.
Fixed Size : This is fixed pool which is basically used by oracle itself. It contains some internal info abt the allocated SGA which is used by oracle processes internally and user has no control on it.
Variable Size : This is sum of SHARED_POOL_SIZE, LARGE_POOL_SIZE and JAVA_POOL_SIZE of ur SGA.
Database Buffers : This is the buffer cache and it depends on the parameter db_cache_size + db_*k_cache_size in 9i or higher versions, prior to 9i it depends on db_block_buffers * db_block_size.
Redo Buffers : This is the redo buffer and it depends on the parameter log_buffer.
Daljit Singh.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
