On Mon, 05 Nov 2007 13:40:09 -0800, chris <cboivin_at_jlr.ca> wrote:
>On Nov 5, 4:37 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>> On Nov 5, 3:10 pm, chris <cboi..._at_jlr.ca> wrote:
>>
>>
>>
>>
>>
>> > Hi everyone,
>>
>> > Id' just setup a new server for our Database, here's the Spec :
>>
>> > Win Server 2003 Ent. Edition (64 bit)
>> > 2 CPUs
>> > 24 Gb of RAM
>> > Oracle 10.0.2.3 (64 bit)
>>
>> > My SGA is 11040 MB and the PGA 4095 MB
>> > so, around 17GB for the instance, and it left 7GB of RAM for the OS
>> > suppose to be Ok, but i have the message : Significant virtual memory
>> > paging was detected on the host operating system in the EM ...
>>
>> > Do i do something wrong ?
>>
>> > Thanks
>> > Chris
>>
>> I have trouble understanding why you need an 11 gig SGA.
>>
>> David Fitzjarrell- Hide quoted text -
>>
>> - Show quoted text -
>
>I'm not an expert DBA, so i think if the memory is available, i can
>give it to the database
>is it better to reduce it ? , i'd change my server bcause the old one
>crash many time because of a lack of memory
>
>Thanks
- The memory is not available.
- Your calculation is wrong, as you forget to include the memory
client processes will be using on the database server. So : you are
not using 17Gb, you are using more. Please consult the task manager to
verify memory used by Oracle.exe
- Is there any advisor in Oracle which told you to configure such
outrageous amounts of memoryl, or do you belong to the 'More is better
school of tuning'
- Likely you have an untuned application.
Fix it.
Stop symptom fighting.
Contrary to what some 'gurus' state, it won't work, ever.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Nov 06 2007 - 00:38:13 CST
