RE: Long Transaction

From: William Rice <ricew@operamail.com> > >Comments embedded > > >===== Original Message From "Obnoxio The Clown" <obnoxio@hotmail.com> >===== > >From: Edward Rosenthal <edrosenthal@home.com> > >> > >>physical log > >>to keep the before image handy, for a rollback(?). this comes from the > >>buffer > >>from > >>the read cache ...as each buffer modification takes place the physical >log > >>is > >>keeping before image rows by having the cache write to it. > >>when the 75% is reached,or a checkpoint, the physlog is written to the > >>database, > > > >Well, no. The physical log isn't written to the database at all. It's >only > >used for rollback. Once the flush of modified buffers is complete, the > >physical log is simply truncated. > >I thought the physical log was only used for fast recovery. Well, duh...! I wish this bloody keyboard would put in what I mean and not what I type... :-)))) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com