-
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
-
the database is always doing something, whether it is your queries or system ones
-
I agree with pednekar2000. Can someone explain how scn's increment? what do you mean by "system ones"?
-
agree with what?
you know the database is doign queries all the time? just becuase you arent doing them doesnt mean the database isnt
-
ok davey, you convinced me. But I'd to know what kind of queries the system does by itself?
-
Originally Posted by pednekar2000
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.
Originally Posted by pednekar2000
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|