RE: ORA-00064: object is too large to allocate on this O/S (1,16352000)
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: Tanel Poder <tanel.poder.003@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Jan 2008 12:18:16 +0530
Thanks Tanel for responding & the support
In init.ora (at Production - Solaris 9/Oracle 9.2):-
sessions=25000
_ksmg_granule_size=33554432
Cheers
________________________________________
From: Tanel Poder [tanel.poder.003@xxxxxxx]
Sent: Thursday, January 03, 2008 11:59 AM
To: VIVEK_SHARMA; oracle-l@xxxxxxxxxxxxx
Subject: RE: ORA-00064: object is too large to allocate on this O/S
(1,16352000)
You need to increase your _ksmg_granule_size as documented in Metalink. The
session array needs to fit into contiguous piece of memory (e.g. one
extent/granule) for easy lookup, and your granule size is too small for
given number of sessions.
I would go with 256MB granule size on Solaris 10 as this supports 256M large
pages.
Note as this is an undocumented parameter, consult at least Metalink and
preferrably get blessing from Oracle Support for this. This post is only for
providing the information, it's not a recommendation.
--
Regards,
Tanel Poder
http://blog.tanelpoder.com
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA
> Sent: Thursday, January 03, 2008 12:49
> To: oracle-l@xxxxxxxxxxxxx
> Subject: ORA-00064: object is too large to allocate on this
> O/S (1,16352000)
>
>
> Folks
>
> For a BIG Benchmark Run, on increasing the sessions to 7000
> (from 5000) getting the following ORA Error
> ORA-00064: object is too large to allocate on this O/S
> (1,16352000) NOTE - increasing of the seesions parameter is
> necessary for the Benchmark Runs.
>
> $ oerr ora 64
> // *Cause: An initialization parameter was set to a value
> that required
> // allocating more contiguous space than can be
> allocated on this
> // operating system.
> // *Action: Reduce the value of the initialization parameter.
> Does this point to an O.S. Kernel parameter which needs to be
> increased? if so, which?
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
