+ Reply to Thread
Results 1 to 6 of 6
  1. 10-30-2009 03:42 AM #1
    pednekar2000
    pednekar2000 is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 10-30-2009 04:38 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    the database is always doing something, whether it is your queries or system ones
    Reply With Quote Reply With Quote
  3. 10-30-2009 09:51 AM #3
    lulon
    lulon is offline Junior Member
    Join Date
    Jun 2009
    Posts
    40
    I agree with pednekar2000. Can someone explain how scn's increment? what do you mean by "system ones"?
    Reply With Quote Reply With Quote
  4. 10-30-2009 10:10 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    agree with what?

    you know the database is doign queries all the time? just becuase you arent doing them doesnt mean the database isnt
    Reply With Quote Reply With Quote
  5. 10-30-2009 10:41 AM #5
    lulon
    lulon is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  6. 10-30-2009 01:03 PM #6
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,482
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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