Trivia question - file date.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 27 Nov 2002 11:03:18 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702FAE3F5@lnewton.leeds.lfs.co.uk>

Hi Richard,

you had to get one in about the cricket didn't you :o) Niall will have something to say on the matter - and he'll probably be very scathing towards a certain Mr Bowie as well.

Yep the checkpointing of temp files isn't much good - I eventually figured that one out. I must be getting old.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Richard Foote [mailto:richard.foote_at_bigpond.com] Posted At: Wednesday, November 27, 2002 11:48 AM Posted To: server
Conversation: Trivia question - file date. Subject: Re: Trivia question - file date.

Hi Norman, Joel and all cricket loving DBAs ;)

Remember that the purpose of a checkpoint is to have a point from which to
commence instance recoveries. However, if you had an instance failure, what
precisely within a temp file would be worth recovering. Not a lot. Therefore
if Oracle is not going to concern itself with recovering a temp file, then
there's really no point in checkpointing it either. Received on Wed Nov 27 2002 - 05:03:18 CST