Fw: AIX and large SGA

Thanks to all who replied to this.

We figured out this was a granule size issue and we resolved it by setting _ksmg_granule_size .

After which we promptly ran into Oracle bug #7047759.

The beat goes on........

Dan Hubler
Database Administrator
Aurora Healthcare
Cerner Support Team
414-647-3257
daniel.hubler_at_aurora.org
----- Forwarded by Daniel Hubler/HEI/AHC on 07/02/2008 03:06 PM -----

daniel.hubler_at_aurora.org
Sent by: oracle-l-bounce_at_freelists.org
07/02/2008 09:52 AM
Please respond to
daniel.hubler_at_aurora.org

To
oracle-l_at_freelists.org
cc

Subject
AIX and large SGA

AIX 5.3.2.7
Oracle 10.2.0.3 (+RAC)

We are new to AIX.

We are trying to start an Oracle instance with a large SGA (200gig+). We previously has the instance running with the SGA about 40gig.

We are seeing multiple errors:

ora-00600   (probably a bug with this one) 
ORA-04031 
ORA-03113 

We are wondering if there are AIX kernel parameters we need to modify to accommodate a large
SGA. Any help would be appreciated.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jul 02 2008 - 15:07:37 CDT