I read the whole thread and it is very interesting. I learned the slow checkpointing from this thread. Thank you all for exchaing useful information.

I have one question for Tamil. You are saying about INIT parameter DB_CHECKPOINT_BATCH_SIZE. I tried to set this parameter. But it is not taking.

Here is the oracle version i am using.

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production