Kbase P75877: How to make reads faster on target database than on source database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to make reads faster on target database than on source database
FACT(s) (Environment):
Fathom High Availability Replication 2.0A
FIX:
Find below some advice.
. Make sure you do have the same I/O efficiency for the target database's files as for the source database's files. The replication agent needs to access in write mode database blocks and the Before Image file.
. Have an adequate sized buffer pool so that there is enough but not too much database blocks in memory.
. Check with promon if you have enough bi buffers, i.e. there is no BI Buffer Wait.
. Try if starting a BIW and/or a APW increases the performance.