cancel
Showing results for 
Search instead for 
Did you mean: 

system hung up on sequential read

Former Member
0 Kudos

system is running normally except for one process. When the end users try to pull up customer overview in tcode cic0, the screen just hangs up. In the work process information from sm50, I see that report RECVBP02 is running and it is running a sequential read on the tableEABLG but it pauses after a while. All other transacations run just fine. Please see below for more detailed info on the work process. Buffers, CPU, memory, Index all look good. Any ideas as to what else could be causing this ?

No Ty. PID Status Reasn Start Err Sem CPU Time Cl. User

0 DIA 25932 Running Yes 14:45 3088 100 A658979

Report / Spool action

SAPLEL24

Main Program

RECVBP02

Action Table

Sequential Read EABLG

Waiting f. since

Last SQL statement

SELECT

*

FROM

SELECT

*

FROM

"EABLG" T_00 INNER JOIN "EABL" T_01 ON T_01 . "MANDT" = :A0 AND T_00 . "ABLBELNR" = T_01 . "ABLBELNR"

WHERE

T_00 . "MANDT" = :A1 AND T_00 . "ANLAGE" = :A2 AND T_01 . "ADAT" BETWEEN :A3 AND :A4 AND T_01 .

"ABLSTAT" IN ( :A5 , :A6 , :A7 , :A8 , :A9 )#

Direct Read 366 14,676

Sequential Read 267 2160329

Insert 0 0

Update 0 0

Delete 0 0

Sources 0 (Bytes)

RSQL 980,082 (Bytes)

Commit 0

DB Procedure Calls 0 0

Roles / Memory Number Time (usec)

Roll In 1 1,657

Roll Out 1 612

Roll 237,568 (Bytes)

Page 90,112 (Bytes)

Memory (Total) 25,149,844 (Bytes)

Memory(Total Private) 0 (Bytes)

Memory (used) 8,379,712 (Bytes)

Memory (Max. Transaction) 29,328,992 (Bytes)

Memory (Max. Dialog Step) 25,139,136 (Bytes)

Development Environ. Number Time (usec)

Generate 0

Load Report 55,647

Load Screen 0 (Bytes) 7,636

Load CUA 602

Read Dictionary 0

RFC 0 Calls 0.00000000000000

Queue API 0 (Bytes) 0

Ad Opcodes 0 0

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hm! check how many entries are there in table EABLG from SE16.

Also check the db stats for table EABLG in DB20 if you are oracle and you are restricting your selection while executing the report.

Former Member
0 Kudos

sunil,

it was the db stats for this big table. I recreated it and its working now !!. I have new found respect for the optimizer statistics now. Thanks for your prompt help, points awarded.

RS

Answers (0)