very slow system problem

[Former Member]

Dear All,

I am facing very slow system problem . I am not able to find the rout cause of the problem

there is no wp probem and it is for abaper are facing the most most they say it take hr to active any problem.

Please suggest .

St02 details

Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs

Nametab (NTAB) 0

Table definition 99.58 6,799 4 0.07 20,000 35,062 67,651

Field definition 99.60 31,563 2,334 7.78 20,000 11,839 59.20 31,683 41,108

Short NTAB 99.84 3,625 1,999 66.63 5,000 1,639 32.78 0 3,364

Initial records 82.32 6,625 304 5.07 5,000 748 14.96 20,334 24,616

0

program 99.82 600,000 2,133 0.38 150,000 134,729 89.82 41,706 188,784

CUA 99.69 4,000 772 23.55 2,000 1,864 93.20 130,014 4,651

Screen 99.72 4,297 1,381 34.16 2,500 2,334 93.36 308 6,363

Calendar 54.41 488 367 76.78 200 54 27.00 0 146

OTR 33.33 4,096 3,374 99.97 2,000 1,998 99.90 0

0

Tables 0

Generic Key 99.84 29,297 1,551 5.59 5,000 1,089 21.78 549 237,572

Single record 98.67 10,000 241 2.45 500 459 91.80 1,250 125,511

0

Export/import 66.72 8,000 153 2.47 5,000 3,194 63.88 33,139

Exp./ Imp. SHM 85.81 4,096 3,150 93.33 2,000 1,999 99.95 0

SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %

Roll area 0.09 232 3,864 262,144 0 IDs 99.83

Page area 0.02 56 102,984 131,072 131,072 Statement 95.00

Extended memory 6.75 565,248 1,671,168 8,372,224 0 0.00

Heap memory 0 0 0 0 0.00

Regards,

Kumar

[Former Member · Accepted solution]

Update your query with more details of your hardware, application, DB, user count etc

Regards,

Nick Loy

[Former Member · Accepted solution]

Hi,

we are using ecc6 , oracle 9i and windows 2003 sp2.

St04

DB instance dev Day, Time 04.06.2010 11:58:32

DB node DEV Start up at 09.04.2010 17:11:52

DB release 10.2.0.4.0 Sec. since start 4,819,600

Sec. btw. snaps. 4,819,600

Size (kB) 638,976 Logical reads 8,218,882,213

Quality (%) 94.0 Physical reads 491,632,854

Size default pool (kB) 638,976 Physical writes 5,166,285

Size keep pool (kb) 0 Buffer busy waits 32,500,942

Size others (kb) 0 Buffer wait time (s) 92,653

Size (kB) 638,976 Size (kB) 14,360

DD-cache Quality (%) 98.6 Entries 34,450,319

SQL area getratio(%) 95.9 Allocation retries 7,335

SQL area pinratio(%) 99.8 Alloc fault rate(%) 0.0

SQLA.Reloads/pins(%) 0.0223 Redo log wait (s) 382

Log files (in use) 8 ( 8 )

User calls 71,473,290 Recursive calls 33,300,008

User commits 721,094 Parse count 2,253,180

User rollbacks 9,835 User/recursive calls 2.1

Log.Reads/User Calls 115.0

Busy wait time (s) 1,494,126 Sessions busy (%) 1.24

CPU time session (s) 213,327 CPU usage (%) 2.21

Time/User call (ms) 24.00 Number of CPUs 2

Redo writes 1,185,958 Redo write time (s) 1,521

OS blocks written 38,235,714 MB written 17,765

Latching time (s) 2

Short table scans 29,873,487 Sorts (memory) 7,169,264

Long table scans 14,880 Sorts (disk) 0

Table fetch by rowid 850,534,376 Sorts (rows) 231,276,241

Fetch by contin. row 971,993 WA exec. optim. mode 3,371,031

WA exec. one pass m. 0

WA exec. multipass m 0

Soft parse ratio 0.9824 Parse CPU to Total 0.9994

In-memory sort ratio 1.0000 PTime CPU / PT elps. 0.1756

Parse to exec. ratio 0.9688

ST06

CPU

Description Value Description Value

Utilization user % 0 Count 2

system % 0 Load average 1 min 0.26

idle % 100 5 min 0.27

io wait % 0 15 min 0.20

System calls/s 2600 Context switches/s 877

Interrupts/s 141

Memory

Description Value Description Value

Physical mem avail Kb 8376128 Physical mem free Kb 2454456

Pages in/s 0 Kb paged in/s 0

Pages out/s 0 Kb paged out/s 0

Swap

Description Value Description Value

Commit charge limit Kb 56209624 Maximum swap-space Kb 51691520

Commit charge free Kb 38391008 Actual swap-space Kb 49627136

Disk with highest response time

Description Value Description Value

Name 0 C: E: K: F: H: N: Response time ms 0

Regards,

Kumar

[Former Member]

Hi,

As per your query your system is slow due to operating widows system. Please increase your RAM to process .

Anil

[Former Member]

Hi,

Have you check your Z development code?

Do performance tunning for your customized report and also schedule performance review session with SAP.

It will help you to improve the performance.

Regards,

Nisit.

[Former Member]

Do not copy and paste screen shot details, we don't have analyzer tool to provide the root cause.

You are using 8GM RAM, but what is the active user count on your system during peak hours?

And what is the count of your work processed, where you are getting much time in ST03 for dialog ?

Regards,

Nick Loy