Re: [Q] archive log list from tables

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/21
Message-ID: <5guku3$ce8@gw.PacBell.COM>#1/1

> HI,

> Using 'archive log list' from SQLDBA results in lines like

> Database log mode ARCHIVELOG
> Automatic archival ENABLED
> Archive destination /tmp/xxx
> Oldest online log sequence 59
> Next log sequence to archive 61
> Current log sequence 61

> How do I query 'Oldest online log sequence' and 'Current log sequence'
> from a table? From which table?

Oldest online log sequence:

select min(sequence#) from v$log;

Current log sequence:

select sequence# from v$log where status = 'CURRENT';

Johnny Chan
Independent Oracle Specialist Received on Fri Mar 21 1997 - 00:00:00 CST