OraFAQ Forum: Server Administration » RESETLOGS

Home » RDBMS Server » Server Administration » RESETLOGS_CHANGE#

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RESETLOGS_CHANGE# [message #163115]

Tue, 14 March 2006 23:58

gajini
Messages: 262
Registered: January 2006

Senior Member

what does the parameter 'RESETLOGS_CHANGE#' of the view 'V$ARCHIVED_LOG' mean?

Can anyone explain me briefly?

When this parameter is useful?

Thanks,
Malru

Report message to a moderator

Re: RESETLOGS_CHANGE# [message #163162 is a reply to message #163115]

Wed, 15 March 2006 04:19

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

It indicates if the log file is part of the current incarnation of the database or nor:

SQL> SELECT resetlogs_change#, count(*) FROM v$archived_log group by resetlogs_change#;

       RESETLOGS_CHANGE#   COUNT(*)
------------------------ ----------
       5,206,108,727,029        921

SQL> SELECT resetlogs_change# FROM v$database;

       RESETLOGS_CHANGE#
------------------------
       5,206,108,727,029

Report message to a moderator

Re: RESETLOGS_CHANGE# [message #163540 is a reply to message #163115]

Fri, 17 March 2006 03:08

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi Frank Naude ,

Thanks.

Can you please explain this with an example or in layman terms?

Thanks in advance,
Malru

Report message to a moderator

Previous Topic:	query doing full table scan
Next Topic:	How do u overwrite a scheme of tables with another schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:37:28 CDT 2024