I have set my SGA to automatic memory management. The SGA_target is set at 1544 and SGA_max_size at 1944. The server has total memory of 6 gb.

Also, i get this recommendation from dbconsole..The SGA was inadequately sized, causing additional I/O or hard parses .. recommendation to increase sga to 1930...

Can some explain to me what is the cause of this error and how I can prevent it from occurring in the future.

Thank you.

What is your Oracle version and Operating system?

Oracle 10.2.0.3 on windows 2003

i have the same problem:(

---------------------------------------------
support @ sucretemplates.com
support @ SUDIZ.COM

I assume you do mean 1544 Megabytes - right? (sga_target)

>> The server has total memory of 6 gb.

Gee, my PC has 8 gig. . . .

That's not much RAM . . . .

******************************************************************
>> Can some explain to me what is the cause of this error

I see the ORA-27102 a lot with a too small SGA_MAX_SIZE

http://www.dba-oracle.com/t_ora_27102_out_of_memory.htm

The Oracle docs note this on the ora-27102 error:

ORA-27102: out of memory

Cause: Out of memory

Action: Consult the trace file for details

Also see this thread:

http://dba.ipbhost.com/index.php?showtopic=3690

"reduced sga_max_size from 1.8g to 1g. restarted db and it is open now. "

yes

I have modified my boot.ini to

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise"

/noexecute=optout /fastdetect /3GB

Do I have to set use_indirect_data_buffer=true also.... currently its set to false. And do I have to include /PAE switch to the boot.ini file also.....


Thank you all

Any help on this issue....

Yes, you do. However, you wont get a huge performance increase because of the additional overhead that is added to address the additional memory in a 32 bit OS. The easiest solution is to upgrade to a 64 bit operating system and software.