|
-
 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
|
Reply With Quote