Re: where can I find the latest SCN

From: Pramod Ramachandran <pramod_at_rtimes.com>
Date: 18 Sep 2002 02:54:42 -0700
Message-ID: <6616e304.0209180154.7bbeec36_at_posting.google.com>

Even I use Oracle 8i. I queried the v$log for the latest SCN. It has columns,
It has a column FIRST_CHANGE# which becomes a new value larger than the previous one. But this does not happen when I do a COMMIT - it seems to update on a log switch.

Thanks again and regards

Pramod Received on Wed Sep 18 2002 - 11:54:42 CEST

This message: [ Message body ]
Next message: D.Y.: "Re: where can I find the latest SCN"
Previous message: Charlie Edwards: "Re: Counting two columns with where causes for each"
Maybe in reply to: Pramod Ramachandran: "where can I find the latest SCN"
Next in thread: D.Y.: "Re: where can I find the latest SCN"
Reply: D.Y.: "Re: where can I find the latest SCN"
Reply: Ban Spam: "Re: where can I find the latest SCN"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message