Transactions are taking somuch time

[amit_waghmare2]

Hi all,

i have done system copy from Production system to test system(offline backup). After that i started SAP and Scheduled SGEN on selected components(BASIS, ABAP, APPL & P3A). SGEN is running from last 10 days, it completes 48 percent only. i have cancelled SGEN and started working on it. But transactions also taking somuch time to open.

For this i have checked Tablespaces(90% used) and logs, everything is fine. But i found some developer trace files and operating system logs. please suggest me to resolve the issues.

DEVDISP

Wed Jan 20 11:50:36 2010

• ERROR => DpWPCheck: W0 (pid 4389) died (severity=0, status=0) [dpxxdisp.c 15776]

Wed Jan 20 11:53:28 2010

• ERROR => DpWPCheck: W0 (pid 4559) died (severity=0, status=0) [dpxxdisp.c 15776]

Wed Jan 20 12:07:59 2010

• ERROR => DpWPCheck: W0 (pid 4562) died (severity=0, status=0) [dpxxdisp.c 15776]

ORA-24909: call in progress. Current operation cancelled [dbrepo#5 @ 2657] [dbrepo 2657 ]

ERROR => ORA-3114 occurred when executing SQL stmt (parse error offset=0)

regards

Ramesh

Edited by: Lokesh Krishna on Jan 20, 2010 8:55 AM

Edited by: Lokesh Krishna on Jan 20, 2010 8:56 AM

[markus_doehr2]

> i have done system copy from Production system to test system(offline backup).

If you do a database copy the load will also be copied, why do you run SGEN then?

> After that i started SAP and Scheduled SGEN on selected components(BASIS, ABAP, APPL & P3A). SGEN is running from last 10 days, it completes 48 percent only. i have cancelled SGEN and started working on it. But transactions also taking somuch time to open.

How big is that machine sized? Is that 32bit?

Markus

[JPReyes]

Cancel SGEN, update statistics and run it again.

Regards

Juan