> Upon looking in knldiag file, I see a lot of DATACACH LRU
> OVERFLOW:32.
can you increase the DATA_CACHE?
If have seen this once too here on our system but it didn't impact
performance.
Check with
# x_cons <SID> show active 1
what the DB is doing...
> The partition where the archived logs are written to is not
> full(I delete them at regular intervals because they are not
> needed, a full database backup will be taken at the end), the
> datafiles are not full either.
You can configure the DB so that no logs at all are written, this will make
inserting/deleting/changing faster (in DBMGui Change LogMode)...
Greetz,
SIEGENIA-AUBI KG
Informationswesen
i.A.
Markus Döhr
SAP-CC/BC, SAPDB-DBA
Tel.: +49 6503 917-152
Fax: +49 6503 917-7152
E-Mail: markus.doehr@stripped
Internet: http://www.siegenia-aubi.com
