Work process dev_w0 too big

[Former Member]

Dear all,

After the upgrade of Oracle from 9.2.0.5 into 10.2.0.2, I've noticed my file system /usr/sap/SID is growing rapidly. I saw that one work process dev_w0 grows too much, now it's more that 1GB.

We are using SAP R/3 4.6C on HP-UX 11.23.

I'm not sure if this is because of the Oracle upgrade, but the work process started to grow just after the upgrade.

I use PSAPUNDO with NO Automatic extend option.

Does anyone knows why the work process is growing so rapidly?

Thanks in advance.

Many regards,

Ruzica

[Former Member · Accepted solution]

Hi,

From tr. SM50 you can check your trace level ( Menu <i>Process-Trace-Display File</i>). At first line you can see it. To modify it, Menu <i>Process-Trace-Active Components</i>.

If you want to delete the unnecessary trace file (and free disk space), at the same menu, select option "reset files" (with the WP selected).

Best Regards,

JC Llanes.

[Former Member · Accepted solution]

Thanks Juan,

I reset the trace and free the space from /usr/sap/<SID>

I have only trace level 1 with components -- taskhandler, but something happened because one work process started to grow very much.

Many regards,

Ruzica

[Former Member · Accepted solution]

Hi Ruzica,

did you have a look inside dev_w0? Can you post the last lines of the file here?

Best regards,

Elmar.

[Former Member · Accepted solution]

Hi Elmar,

I have reset the trace for the work process and now I this work proces has a little lines:

1. tail -100 dev_w0

M PfRollIn: rolled in act rec (c0000000cffb7540/552) of type 0

M PfRollIn: clear statistic roll area

M PfRollIn: free roll area c0000000cffb7540 for rec type 0

M PfFreeRoll: free EM_GLOBAL (c0000000cffb7540)

M PfRollIn: rolled out: 19 msec (sum=586)

M PfTraceActInterval: after roll in (is_open/num_of_int/act_index/act_depth=0/0/-1/0)

M PfRollIn: add roll out time 13251

M set task type/act rqtype = ZTTADIA/0

M Thdynpen00: call dynp handler (17) ...

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 1 >FB01 <

M PfSetTcode: set tcode >FB01 <

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 3 >SAPMF05A <

M ThSend2 (type = 0x10) from T93/M0

M ThISend: (tm/type = 93/0x80000010, mode_deleted=0)

M ThRqOutCheck: o.k.

M compress data from 222 to 162 bytes

M abap strategy ROLL / O.K.

M ThNewWpStat: hand shake, set mode rec to sys

M ThNewWpStat: new state of T93/M0 = 0x44

M ThISend: new wp stat: 0x8

M Adresse Offset Data to Terminal

M -

---

M c0000000060b98a0 000000 00001100 00020001 de000000 121f9d02 |................|

M c0000000060b98b0 000016 99009b20 83c2fffa 5fbc15db cdef9549 |... ...._......I|

M -

---

M PfAddOutputLen: add 170 bytes to output len

M make DISP owner of wp_ca_blk 14

M put request into queue (reqtype 0, prio LOW, rq_id 6573)

M -OUT- sender_id WORK_PROCESS tid 93 wp_ca_blk 14 wp_id 0

M -OUT- action SEND_TO_TM uid 20606 appc_ca_blk -1 type NOWP

M -OUT- new_stat WP_HOLD mode 0 len 170 rq_id 6573

M -OUT- req_info DP_HAND_SHAKE

M NiIDgSend: send dgram to: host 127.0.0.1, port 0C.9E/3230, fam 2 (low adr..high adr)

M ThRqWaitFor: wait for next request new time slice

M ThAlarm: reset alarm (600 secs left)

M ThRqWaitFor: wait for request

M ThAlarm: set alarm to 600 sec

M ThRqAccept: allowed rq_type = 3

M set act fields to T93/M0

M ThIsAsyncInput (T93, M0, ..), allowed rq_type = TH_MSG_RQ

M LOCK WP ca_blk 14

M set act fields to T93/M0

M ThClearNextFields ()

M rq_id 6574 for T93 U20606 M0 I4 recv 50 (Mstat 66, len -1) (from dispatcher)

M resCheck=0 Tname: SK-FIN-SONJA

M set MSG_HAND_SHAKE_RC after hand shake

M ThRqInCheck: o.k.

M Delete Int Mode

M ThCallHooks: call hook >dyRollInOutHook< for event BEFORE_DELETE_INT_MODE

M ThCallHooks: call hook >SpoolHandleHook< for event BEFORE_DELETE_INT_MODE

M ThResFree: free resources of U20606 M0 I4 (normal mode, complete free) at level 1, db_action=TH_DB_NO_ACTION

M ThEmFree: call EmContextPop

M ThRollIn: roll in T93/U20606/M0 (level=6, abap_level=2, attach_em=1)

M ThRollIn: U20606 M0 I3 (Level 6) ok

M ThRollIn: roll in abap all

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 1 >FEBP <

M PfSetTcode: set tcode >FEBP <

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 3 >SAPMSSY0 <

M ThCreateIntMode: create internal mode

M ThRollOut: roll out T93/U20606/M0/I3 (level=7, short_roll_out=0)

M ThRollOut: call rrol_out

M ThRollOut: act roll state = DP_ROLLED_OUT

M ThRollOut: roll level <> 0, don't call ab_rollout

M ThRollOut: full roll out of U20606 M0 I3 (Level 7) ok

M ThCreateIntMode: call EmContextPush ()

M ThCallHooks: call hook >dyRollInOutHook< for event AFTER_CREATE_INT_MODE

M ThCallHooks: call hook >IMCClearSpaDummy< for event AFTER_CREATE_INT_MODE

M ThInitNewSpa: reinitialize spa

M ThNewEnqKey: new dia/update enqueue key

M ThNewEnqKey: new dia/update enqueue key

M ThCommit (16)

M ThICommit3: commit and free resources

M ThCheckComOrRb (event=1, full_commit=1)

M ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT

M ThCheckComOrRb (event=3, full_commit=1)

M ThCallHooks: call hook >ThVBICmRbHook< for event AFTER_COMMIT

M ThVBICmRbHook: called for commit

M ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT

M ThNoClearPrevErr: clear prev no err

M ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT

M ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT

M ThrClearMemory o.k.

M ThCallHooks: call hook >rsts_storage_free< for event AFTER_STORAGE_FREE

M ThAlarm: set alarm to 600 sec

M ThICommit3 o.k.

M

M ********* W0 LOOP (DIA) *********

M short jmp (12): return to abap using SAP-stack

M set task type/act rqtype = ZTTADIA/0

M Thdynpen00: call dynp handler (16) ...

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 1 >FB01 <

M PfSetTcode: set tcode >FB01 <

M ThGetRfcCliId2: got local client info from sysid >PR2 <

M ThSetRfcCliAction: set action 3 >SAPMF05A

Do you see something?

Thanks,

Ruzica

[Former Member · Accepted solution]

Hi Ruzica,

looks like you are still running with a trace level > 1.

Can you double check (in sm50 and in report RSPFPAR) that your trace level is set to 1 (check for profile parameter rdisp/TRACE in RSPFPAR).

Best regards,

Elmar.

[Former Member · Accepted solution]

Hi,

I checked in SM50 and the profile parameter rdisp/TRACE and it was set to 1.

Regards,

Ruzica

[Former Member · Accepted solution]

running out of ideas now - sorry...

Best regards,

Elmar.

[Former Member · Accepted solution]

Thanks for all ideas ,

Many regards,

Ruzica

[Former Member]

Hi,

Chk the trace level of workprocess

Regrds

Umesh K