Performance Issue in RFC Dialog Workprocess

[Former Member]

Hello All,

We gone live on 3rd of july 2010

We are running on

ECc6.0 EHP4 + Oracle10g

CPU - 2 X Intel Xeon 2933 MHz

With 32 GB Ram

MS clustering

We have issue with RFC Dialog workprocess

Say for example if i execute the

STAD for 00:10:00 min it tooks to much time

Analysis of time in work process

CPU time 608 ms Number Roll ins 3

RFC+CPIC time 0 ms Roll outs 3

Enqueues 0

Total time in workprocs 48,072 ms

Load time Program 16 ms

Response time 48,388 ms

Wait for work process 15 ms

Processing time 48,027 ms Roll time Out 0 ms

Load time 16 ms In 1 ms

Generating time 0 ms Wait 301 ms

Roll (in+wait) time 302 ms

Database request time 28 ms Frontend No.roundtrips 3

Enqueue time 0 ms GUI time 7 ms

Net time 97 ms

Analysis of ABAP/4 database requests (only explicitly by application)

Connection DEFAULT Request time 28 ms

Database requests total 93 Commit time 1 ms

DB Proc. Calls 0 DB Proc. Time 0 ms

Type of Database Requests Database Request Avg.time /

ABAP request rows Requests to buffer calls time (ms) row (ms)

Total 140 93 7 50 28 0.2

Direct read 24 57 7 5 0.2

Sequential read 116 36 0 50 23 0.2

Update 0 0 0 0 0.0

Delete 0 0 0 0 0.0

Insert 0 0 0 0 0.0

Terminal Out-message 12,237 Bytes

Client 300

Task type Dialog

Work process no 0

Modus 29,727 / 1

Trans.-ID: 3BE088DF4714F16896A10017A477000A

Session-ID: 0004700066DD88DF0189F19596A10017A477000A

Dialog-Step: 46

Batch-input queue time 0 ms

RFC interface time 0 ms

DDIC interface time 0 ms

Total memory used 16,548 kB

Max. memory used in roll area 181 kB

New allocated paging memory 0 kB

Max. extended memory used

In transaction 28,643 kB

In dialog step 24,547 kB

Extended memory in use 16,367 kB

Private memory in use 0 kB

Workprocess in PRIV mode No

Workprocess restarted No

TCode STAD

Dynpro No. 0120

CUA reference program RSSTAT26

CUA internal command STRT

No table requests for this record.

Profile parameter stat/tabrec is set to 0

Runtime value of stat/tabrec is set to 0

There was no recording of table accesses!

Bytes transferred

Total 581,210 Bytes

Sources + Loads 570,724 Bytes

Batch-Input queue 0 Bytes

Requested by application 10,486 Bytes

Remote Function Calls

as Client

Number Connections 1

Destinations 1

Users 1

Calls 1

Time Calling 47,854 ms

Remote execution 295 ms

Idle 0 ms

Data Sent 1,689 Bytes

Received 3,364,782 Bytes

Please check and suggest

BR,Jai

[Former Member · Accepted solution]

We have issue with RFC Dialog workprocess

One run with STAD is not enough to point out a performance problem. Be more specific.

Do you have a general performance issue or is it a more transaction specific problem?

Do you, for instance, run the jobs for update database statistics on a regular basis?

Have you followed the guidelines for Oracle 10.2 parameters?

[ Note 830576 - Parameter recommendations for Oracle 10g|https://service.sap.com/sap/support/notes/830576]