Kbase P20675: Performance of Oracle DataServer is 2x slower after migrated from one machine to another
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/16/2010 |
|
Status: Verified
SYMPTOM(s):
Performance of Oracle DataServer is 2x slower after migrated from one machine to another
Oracle database is on the same machine as the Oracle DataServer machine
Connecting to the oracle database directly without using SQL*NET
The oracle daemon that gets spawned when _progres is spawned gets high CPU time but _progres stays at low CPU time
An important index is missing from the Oracle database
CHANGE:
Transferred the oracle database from less powerful processor to more powerful processor with more memory and the storage capacities.
CAUSE:
During the transfer process of the Oracle database to a newer machine one of the important index was omitted in the oracle database. The omission of that important index caused the bad performance. After the creation of that index, the performance has improved drastically.
FIX:
Create the omitted index.