| Control file [message #493126] |
Sat, 05 February 2011 04:32  |
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  |
John Watson
Messages: 8964
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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
