Re: where can I find the latest SCN

pramod_at_rtimes.com (Pramod Ramachandran) wrote in news:6616e304.0209152135.3fd50d26_at_posting.google.com:

> 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

Which version of Oracle?
Which field in V$LOG is not changing? Received on Tue Sep 17 2002 - 03:48:19 CEST