Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Init.ora Parameters
Mill wrote:
> "g300" <ian_cpt_at_yahoo.com> wrote in message
> news:nI2dnRYVec063yrdRVn-jg_at_is.co.za...
>
>>Hi, >> >>I agree with Daniel, throwing more memory at the database does not
>>mean it will perform any better. I am currently supporting around 10 >>databases on Windows 2000, and the largest SGA is around 1GB. We've tested >>really big SGA's (Up to 5GB) but we did not receive any SIGNIFICANT >>performance gain by having it set so large. >> >>Just from what I've seen, I have the following comments: >> >>- Why is your shared pool so large? I know this is something that varies >>from environment to environment but 600MB is extremely large. Remember,
>>is a cache for SQL statements so unless you have gigantic SQL statements >>being thrown at your system, it does not have to be so large. You may >>actually have this in reverse, in that your buffer cache is only around >>100MB. Try and find a balance by lowering the shared pool and increasing
>>buffer cache. >>- From your top wait events, db file sequential read is tops. This
>>points to index scans. Are you running a packaged app or something
>>in-house. Again, this is dependant on your environment. >>- Finally, you've provided a STATSPACK report that is fairly old and does >>not span a great deal of time. I would recommend looking at more recent >>data, and making comparisons between different periods of activity on your >>system. >> >>Regards >> >>P.S. What is your disk configuration like? Size of DB? >> >>
You thought ... or think ... correctly. RAID 5 is the worst possible choice.
The chances of the single DBA course being sufficient to help you with the questions you are asking is rather small. I'd suggest getting finding a local resource. Do you have a local Oracle user's group?
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat May 29 2004 - 12:53:41 CDT
![]() |
![]() |