Re: where can I find the latest SCN

Hi Ban

The SCN listed in the V$log view does'nt change after I COMMIT a transaction. Does this mean that an SCN is updated only when a log switch takes place ?

TIA Pramod

Ban Spam <ban-spam_at_operamail.com> wrote in message news:<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 Mon Sep 16 2002 - 07:35:44 CEST