on 2010 Jun 03 1:42 PM
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
Update your query with more details of your hardware, application, DB, user count etc
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
104 | |
10 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.