Database Administration (MOSC)

MOSC Banner

why undoblocksdone is greater than undoblockstotal in v$fast_start_transactions

edited May 1, 2011 10:10AM in Database Administration (MOSC) 1 commentAnswered
hi:

  i have a db of version 8.1.7.4 which is doing parallel transaction recovery now.

  i'm watching it's processing,now the following sql return strange result:

  select undoblocksdone completed,
       undoblockstotal total,
       undoblockstotal - undoblocksdone left, round(undoblocksdone / undoblockstotal * 100, 2) pct_completed
  from v$fast_start_transactions;

completed      total         left         pct_completed
  62499         61073     -1426    102.33

so how can i hnow when will the parallel transaction recovery finished? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center