7 Replies Latest reply: Jun 5, 2008 11:31 AM by 534640 RSS

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

      Hi, we've imported an Oracle db into Oracle10. and want to change the init params according to the 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 is installed. The 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,