Re: scn number

From: Denis Do <nospam.denisdo_at_yahoo.com>
Date: Sun, 19 Dec 2004 10:40:07 GMT
Message-ID: <slrncsamjv.1gk.nospam.denisdo_at_denisdo.news.google.com>


Hi Michael!

I gave the same answer - and just couple seconds later realised it was not exactly what has been asked:-)

Have a look here:
  1 select current_scn, flashback_on, CONTROLFILE_CHANGE#, CHECKPOINT_CHANGE#   2* from v$database
SQL> / CURRENT_SCN FLA CONTROLFILE_CHANGE# CHECKPOINT_CHANGE#

----------- --- ------------------- ------------------
     386884 NO               386780             386617

SQL> / CURRENT_SCN FLA CONTROLFILE_CHANGE# CHECKPOINT_CHANGE#

----------- --- ------------------- ------------------
     386886 NO               386780             386617

SQL> commit;

Commit complete.

SQL> / Commit complete.

SQL> select current_scn, flashback_on, CONTROLFILE_CHANGE#, CHECKPOINT_CHANGE#   2 from v$database;

CURRENT_SCN FLA CONTROLFILE_CHANGE# CHECKPOINT_CHANGE#

----------- --- ------------------- ------------------
     386898 NO               386780             386617

SQL> select distinct CHECKPOINT_CHANGE# from v$datafile_header;

CHECKPOINT_CHANGE#


            386617
So, I would say correct answer is :
- on open instance - v$database.CURRENT_SCN column - on mounted instance - v$datafile_header

Cheers!

On 2004-12-19, Michel Cadot <micadot{at}altern{dot}org> wrote:
>
> "Michel Cadot" <micadot{at}altern{dot}org> a écrit dans le message de
> news:41c16f14$0$7556$636a15ce_at_news.free.fr...

> select checkpoint_change# from v$database; -- from control file
> select checkpoint_change#, last_changes# from v$datafile; -- from control file
> select checkpoint_change# from v$datafile_header; -- from datafile headers
Received on Sun Dec 19 2004 - 11:40:07 CET

Original text of this message