Re: where can I find the latest SCN
From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 13 Sep 2002 11:20:00 GMT
Message-ID: <Xns92882C14FD1B3SunnySD_at_68.6.19.6>
Date: Fri, 13 Sep 2002 11:20:00 GMT
Message-ID: <Xns92882C14FD1B3SunnySD_at_68.6.19.6>
pramod_at_rtimes.com (Pramod Ramachandran) wrote in
news:6616e304.0209121953.25ae0a7f_at_posting.google.com:
> Hi all,
>
> In which dynamic view can I search for the latest system change number
> ?
> (scn generated after a COMMIT, not the one shown in v$log_history
> which stores scn only when a log switch takes place)
>
> TIA
>
> Pramod
>
try V$LOG Received on Fri Sep 13 2002 - 13:20:00 CEST