where can I find the latest SCN
From: Pramod Ramachandran <pramod_at_rtimes.com>
Date: 12 Sep 2002 20:53:57 -0700
Message-ID: <6616e304.0209121953.25ae0a7f_at_posting.google.com>
Date: 12 Sep 2002 20:53:57 -0700
Message-ID: <6616e304.0209121953.25ae0a7f_at_posting.google.com>
Hi all,
In which dynamic view can I search for the latest system change number
?
TIA
(scn generated after a COMMIT, not the one shown in v$log_history
which stores scn only when a log switch takes place)