DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: log sequence number recycling?

  1. 01-31-2003, 02:51 PM #1
    a128
    a128 is offline Senior Member
    Join Date
    Apr 2001
    Posts
    257

    log sequence number recycling?

    What is the max for log sequence number? What happen when it reaches the max? Will it start from the beginning again?

    Thanks,
    Reply With Quote Reply With Quote
  2. 02-01-2003, 05:13 AM #2
    seelan
    seelan is offline Member
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Hi a128,

    Which Sequence number u mean?

    Log Sequence number which got created whehn Log Switch occurs
    or

    Database Object-Sequence Number


    Seelan
    Reply With Quote Reply With Quote
  3. 02-01-2003, 11:56 PM #3
    agasimani
    agasimani is offline Senior Member
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    As per metalink:

    A log sequence number is an unsigned integer which on most ports supports (2^32)-1. Generating a logfile a minute would take many thousands of years to reach the maximum.

    So dont worry about this issue.
    Agasimani
    OCP(10g/9i/8i/8)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width