Help - Search - Members - Calendar
Full Version: ORA-27102
Oracle DBA Forums > Oracle > Oracle Forum
Manny
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.
andrew kerber
What is your Oracle version and Operating system?
Manny
QUOTE (andrew kerber @ Jun 19 2008, 09:18 AM) *
What is your Oracle version and Operating system?



Oracle 10.2.0.3 on windows 2003
SUDIZ
i have the same problem:(

---------------------------------------------
support @ sucretemplates.com
support @ SUDIZ.COM
Arthritic Toe
I assume you do mean 1544 Megabytes - right? (sga_target)
burleson
>> 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. "
Manny
QUOTE (Arthritic Toe @ Jun 19 2008, 03:30 PM) *
I assume you do mean 1544 Megabytes - right? (sga_target)



yes
Manny
QUOTE (Manny @ Jun 20 2008, 08:52 AM) *
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
Manny
QUOTE (Manny @ Jun 20 2008, 01:38 PM) *
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....
DearJohn
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.