How SCN increment?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How SCN increment?

  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Angry How SCN increment?

    When ever I see the current scn number, it increases by some amount, even if I am not doing any transaction. What makes SCN increment. Where can I see the cause of SCN increase in any trace file?
    Last edited by pednekar2000; 10-30-2009 at 03:43 AM. Reason: grammer mistake

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the database is always doing something, whether it is your queries or system ones

  3. #3
    Join Date
    Jun 2009
    Posts
    40
    I agree with pednekar2000. Can someone explain how scn's increment? what do you mean by "system ones"?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    agree with what?

    you know the database is doign queries all the time? just becuase you arent doing them doesnt mean the database isnt

  5. #5
    Join Date
    Jun 2009
    Posts
    40
    ok davey, you convinced me. But I'd to know what kind of queries the system does by itself?

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by pednekar2000 View Post
    What makes SCN increment.
    As far as I remember there are two reasons why SCN increments...

    1- Each time a transaction is commited.
    2- Every other second when checkpoint daemon syncs datafiles and controlfile.

    Quote Originally Posted by pednekar2000 View Post
    Where can I see the cause of SCN increase in any trace file?
    I would look at Oracle documentation rather than looking for a trace file.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

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



Click Here to Expand Forum to Full Width