2 Replies Latest reply: Sep 21, 2011 3:07 AM by Nicolas.Gasparotto RSS

    11gr2 (Peoplesoft Tools 8.48 /9.0) Memory Settings

    user3344498
      Hello

      is there documentation that indicates what the minimum memory_max_target value should be for an 11gr2 database that uses Peoplesoft Tools 8.48 /9.0?

      We have a setting of 1G(recommended), however both peoplesoft data mover and datapump load fail with

      mporting AAP_TBL
      Creating Table AAP_TBL
      Import AAP_TBL 0
      Building required indexes for AAP_TBL
      - SQL Error. Error Position: 0 Return: 12801 - ORA-12801: error signaled in parallel query server P134 ORA-12853: insufficient memory for PX buffers: current 19328K, max needed 4120704K ORA-04031: unable to allocate 65560 bytes of shared memory ("large pool","unknown object","large pool","PX msg pool

      CREATE UNIQUE iNDEX PS_AAP_TBL ON PS_AAP_TBL (ESTABID) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING
      Error: Unable to process create statement for AAP_TBL
      SQL Spaces: 0 Tables: 1 Triggers: 0 Indexes: 0 Views: 0
      Ended: Wed Sep 14 11:22:52 2011
      Unsuccessful completion

      Thanks