| Configure SGA urgent [message #171918] |
Fri, 12 May 2006 05:02  |
reyazan
Messages: 53
Registered: February 2005
|
Member |
|
|
I have oracle 8i(datawarehouse) 1.7.0 dedicated server on
windows2000 server with 2 gb ram,Intel Xeon 3.00GHz.
Now i want to configure sga as below
shared pool 531305533 bytes
database buffer cache 64856 blocks
redo log buffer 118067896 bytes
sort area 11806789 bytes
shared pool reserved size 26565276 bytes
Is it right or any idea
|
|
|
|
| Re: Configure SGA urgent [message #171941 is a reply to message #171918] |
Fri, 12 May 2006 07:21  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Nobody here will be able to tell you it's right or wrong. These areas must be sized according to your workload.
PS: Why don't you upgrade to 10g and let Oracle size these areas for you?
|
|
|
|
|
|
| Re: Configure SGA urgent [message #172014 is a reply to message #171942] |
Sat, 13 May 2006 03:01 |
SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium
|
Junior Member |
|
|
Hi
Why a log buffer of 112 Mb ? I' ve never seen situations which justifies such a high value, I think to know in 8i there is no further benefit of increasing the log buffer once it has reached 5M.
A part from that your main sga components shared pool and buffer cache takes 50% of the overall RAM. That' s not bad as a start. However, are you sure you need a shared pool of 520Mb ?
I assume you didn' t set the hash_area_size which defaults to sort_area_size * 2. Your sort_area is about 10Mb resulting in hash area of 20 Mb ( can be OK )
I would certainly lower the log_buffer and have taken statspack snapshots and reports to be informed what the shared pool usgae is about to be informed what the expensive sql is, to further adjust the sizing of the sga components ( and to tune the bad sql, cursor sharing, ... )
As a start it seems not bad
Regards
Guy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
