Skip to Content
0
Former Member
Mar 30, 2009 at 11:33 AM

Performance issue in PRD

69 Views

Dear All,

The over all Rating is change to RED. The main cause is performance.

Please find the some point of EVA .

Performance Evaluation

Task Steps

Dia 746899

Upd 56979

2 Table Reorganization

Table / Index Name Size of Table / Index [MByte]

ACCTIT 3656,0

3 Database server load from expensive SQL statements

Rating Buffer Load [%] Disk Load [%]

55 69

Analysis of DB SQL CACHE

EXPENSIVE SQL STATEMENTS OVERVIEW

Object Name CPU Load [%] I/O Load [%] Elapsed Time [%] Executions Records Processed

BSIS 1 9 0 22 90462

CDEF$ 6 6 0 2131113 2575694

BSAD 1 3 0 21 408576

MKPF 1 32 0 180 3899

ICOL$ 9 1 0 2575694 8703798

OBJ$ 6 1 0 3405254 3400023

COL$ 12 0 0 2138793 22919657

MKPF 1 13 0 75 396

MCHB 7 0 0 366543 41708

TBTCO 0 4 0 21 8943625

USER_INDEXES 11 0 0 38 2011872

Please suggest .

Regards,