P
Paul Koufalis
Guest
[2014/06/19@07:18:26.941-0600] Begin Physical Redo Phase at 5858304 . [2014/06/19@07:18:27.329-0600] Physical Redo Phase Completed at blk 5859327 off 16247 upd 0. [2014/06/19@07:18:27.338-0600] At end of Physical redo, transaction table size is 512. [2014/06/19@07:18:28.003-0600] Begin Physical Undo 1 transactions at block 5859328 offset 287 [2014/06/19@08:09:46.275-0600] Physical Undo Phase Completed at 4901816 . [2014/06/19@08:09:46.286-0600] Begin Logical Undo Phase, 1 incomplete transactions are being backed out. [2014/06/19@08:09:46.295-0600] Logical Undo Phase begin at Block 4901816 Offset 9095. I know there's no way to know where I am in the logical undo phase...but...If nmon is telling me that I'm reading the BI at 5K/sec, can I guestimate the amount of time it will take to read the entire BI and therefore how long the process will take? With a 95 Gb BI file, this guestimate comes out to about 5 hours. However the physical UNDO phase only took about 50 minutes and it seems to have looped through the entire BI (start block 5 859 328; end blocl 4 901 816). Can anyone add some useful information?
Continue reading...
Continue reading...