Skip to Content
0
Former Member
Sep 11, 2007 at 08:02 AM

SAP servers slow performance issues

229 Views

Hi,

I have SAP R/3 4.7 on HP-UX 11.23 & Oracle 9i. Users are facing slow performance issues while working on these SAP servers...what are the checks at the Oracle Database level, if there is any tuning can be done to improve the overall performance. Please Help.

Its 1TB of Database.

Hit Ratio is above 95 %, Swaps - 0%

CPU Idle time above 30-40%

Response Time - 6-10 ms

When I tried to run DB Check through DB16, I got some warnings & Errors...

IN_WRONG_TABLESPACE

MISSING_INDEX

MISSING_STATISTICS

TABLESPACE_FULL

ARCHIVE_TOO_OLD

BACKUP_TOO_OLD

DB_WRITER_PROCESSES

LOG_CHECKPOINT_INTERVAL

OPTIMIZER_FEATURES_ENABLE

01555

TSP_FULL

60

Checkpoint not complete

Thanx

Rupali S