Control file [message #493126] |
Sat, 05 February 2011 04:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hi All,
please some one help me on this.
I know it is a awkward question, but still i need to be clear.
1)How a single control file is enough to have all the transaction's SCN no for older transactions.
Eg - A transaction has the SCN 01 and after a month the new transaction's SCN is 502.
Is the control file holding all those (01 to 502) SCN in it or just will have the latest SCN no (ie - 502).
Regards:
Muktha
|
|
|
Re: Control file [message #493132 is a reply to message #493126] |
Sat, 05 February 2011 06:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
The controlfile stores the current SCN, exposed in v$database:
select current_scn from v$database;
Are you under the impression that the controlfile stores the commit SCN for transactions? Why would that be necessary?
|
|
|
|