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