| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Eats RAM, none left for Gods
A copy of this was sent to JoshNarins <joshnarins_at_my-dejanews.com>
(if that email address didn't require changing)
On Mon, 26 Apr 1999 18:18:59 GMT, you wrote:
>We had 100% RAM filled ( constantly 50-100M in swap ) and horrid performance
>with Oracle8 and Solaris2.6 with 3G of RAM.
>
>We added a GIG of RAM.
>
>We STILL have 50-100M in swap.
>
I run Oracle on 2.6 with 512meg of RAM. I have typically 50-100 meg in swap as well constantly. SWAP is allocated to many processes upon startup. Having allocated swap is OK, *swapping* may not be.
How big is your SGA? Each of the components of the SGA?
What else do you do on the machine?
How many connected users do you typically have? What are they typically doing?
>What configuration setting is allowing Oracle to consume all available memory?
>OR, since we aren't running anything else on the machine, is using all memory
>this way better than limiting what this greedy monster consumes.
>
>Performace is better with the new RAM, but I still think Oracle's behaviour
>is wrong. We used to page out under heavy stress. We haven't seen loads like
>before yet (we saw mid 20s) and no one has complained yet withg the new RAM
>HOWEVER
>
>an answer exists.
>
>Thank you in advance for any assistance in providing it,
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |