Re: Checkpoint time

Try to force a manual checkpoint to see how long it takes. I discovered a few weeks back that a log switch checkpoint no longer completes
right away. It will wait until another event initiates it. (One event would be the next Redolog becomes 80% full) I discovered this information in a Metalink article which I have at the office, not here at home.
(I verified this on a couple of instances.)

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"EP" <ep_at_NOSPAMplusnet.pl> wrote in message news:bt93ts$jks$1_at_atlantis.news.tpi.pl...
> Hello @,
>
> I have encountered the following problem: during an import on a test
server
> some of the checkpoints take up to 50 minutes to complete - they are
> triggered by log switches - the size of redo logs is 500 MB.
> When I start the import everything seems to be OK, but afted a
considerable
> amount of the import time (i.e. 24-36 hours) this problem occurs.
> I have browsed through the metalink but found no bug/solution.
> The platform: HP-UX 64bit, Oracle: 8.1.7.4
>
> Thanks for any clues,
>
> Best Regards,
> EP
>
>
Received on Sun Jan 04 2004 - 14:42:30 CST