Dear Experts,
We are on 4.7 EE, Oracle 10.2.0.4 and Windows 2003 (32 Bit with 2GB RAM) (QLY system)and our database size is close to 600 GB.
I have successfully restored my PRD data to QLY and now my QLY is running fine with no hiccups.
I wanted to do the same to my DEV(which was on 9.2.0.5 now upgraded to 10G) but things are not moving good as expected.
I first tried a database backup/restore which was not successful, then i tried a system copy from QLY--> DEV but the system copy failed due to some memory issues. Finally i opted for a client export which also is failing.
All i assume is that the QLY memory is not sufficient for these activities. I have also set the parameter recommendations for 10G based on the SAP Note: 830576.
The following is the error during a client export
=====================================================================================================
2EETW000 sap_dext called with msgnr "2":
2EETW000 -
db call info -
2EETW000 function: db_setget
2EETW000 fcode: RT_GET (0)
2EETW000 tabname: COEP
2EETW000 len: 3
2EETW000 key:
2EETW000 ok fetches: 33871957
2EETW000 last entry: 08710000305427330002010
2EETW000 retcode: 2
2EETW125 SQL error "4030" during "" access: "ORA-04030: out of process memory when trying to allocate 64528 bytes (sort subheap,sort key)"
4 ETW000 ROLLBACK (1852108487).
2EETP200 Export with errors, request will not be imported
1 ETP150 MAIN EXPORT
1 ETP110 end date and time : "20100512075209"
1 ETP111 exit code : "12"
=====================================================================================================
When i searched based on the SQL error 4030 i had many replies suggesting to increase my pga and other memory related parameters.
Can anyone suggest me the optimal parameter recommendations based on the size of my RAM(2GB) for my Oracle and SAP please.
We are in the process of increasing it to 4GB very soon.
Awaiting a helpful reply
Thanks in advance
Hunky