Re: Installed new ram -- recieved worse performance

Once Oracle starts up it has to fill it's DB buffers with data from disks once again, b/c they were obviously flushed when you restarted the server. Also it has to reparse every SQL statement and have it cached when you try to re-execute it (I think same goes for PL/SQL)

Also see the following article in metalink.oracle.com SGA size, sgabeg attach address and Sun architectures for increasing SGA beyond 1.7 GIG up to 2.something. be careful with your sort_area_size if you modify anything as suggested in the article.

On Thu, 02 Dec 1999 19:44:19 GMT, sam_tyler_at_my-deja.com wrote:

>We have a ES450 server and tried to install 3Gb of new RAM into the
>system. Immediately after adding the memory and reconfiguring the OS
>and Oracle, we received extremely poor performance.
>
>Because we needed known performance, we took out the new RAM and put in
>the old RAM. Now here's the clincher -- we had the same performance
>problem for about an hour and a half.
>
>Now, here's the question. If we put the new RAM in and let it chug for
>an hour and a half, are we going to see a marked performance increase?
>Why does it take an hour and a half before that happens?
>
>We're in the middle of a legacy system conversion into Oracle. We have
>a deadline to convert 8,000,000 rows - we could use the extra time to
>ensure a working system. Basically, I have to assure management that
>we are not going to suffer any more delays and that the cost of doing
>this will pay off.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email