You can query on v$session_event or v$system_event and find out which event is taking the most time ; and then try to reduce the time spent on that event. regards Joseph BN <bnsarma@xxxxxxxxx> wrote: Greetings 2 CPU HP-UX 11.11 Oracle 9.2.0.7 STANDBY Database Applying 450 Archive Logs of 20 MB each took 2.30 hrs, Is there a way to tune this to cut this time? -- Regards & Thanks BN