This discussion is archived
7 Replies Latest reply: Jun 5, 2008 9:31 AM by 534640 RSS

ALTER SYSTEM SET processes=1000 generates ORA-00064: object is too large to

FredS. Newbie
Currently Being Moderated
Hi, we've imported an Oracle 8.1.7.4 db into Oracle10.2.0.3.0 and want to change the init params according to the 8.1.7.4. production db.

When performing:
=============
ALTER SYSTEM SET processes=10000 SCOPE=SPFILE;

We can't start the 10g DB: ORA-00064: object is too large to allocate on this O/S (1,5150880)

When reducing the size to 500 there is no problem starting the db.

Question: The node has the same configuration as the one on which the 8.1.7.4 is installed. The 8.1.7.4. does actually run with processes=10000. Can you give me a hint where to search? Should we alter extra parameter(s)?

Node=Sun Sparc

Best Regards,

Fred