Re: scn number
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