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?
Printable View
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?
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?
As far as I remember there are two reasons why SCN increments...Quote:
Originally Posted by pednekar2000
1- Each time a transaction is commited.
2- Every other second when checkpoint daemon syncs datafiles and controlfile.
I would look at Oracle documentation rather than looking for a trace file.Quote:
Originally Posted by pednekar2000