1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Redo log file

Discussion in 'General' started by nguyendhoan, Sep 10, 2009.

  1. nguyendhoan

    nguyendhoan Guest

    I have some question about redo log file.

    When commit a transaction , The changes data will be write to redo log file???

    I check my redo log file by command " select * from v$logfile;"
    result is folow:

    after that I run commands :

    after that i check redo file log. All redo log file are not updated

    Please explain !!!!
    Thank you for your reading.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You're looking for change in the wrong view; you should be querying v$log instead:

    set numwidth 15
    set linesize 200

    select group#, thread#, sequence#, bytes, members, archived, status, first_change#, first_time
    from v$log;

    You'll see something similar to this:


    GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
    -------------- --------------- --------------- --------------- --------------- --- ---------------- --------------- --------------------
    1 1 9052 52428800 1 NO CURRENT 10518649878607 09-SEP-2009 10:00:15
    2 1 9050 52428800 1 NO INACTIVE 10518649845611 09-SEP-2009 08:13:24
    3 1 9051 52428800 1 NO INACTIVE 10518649859049 09-SEP-2009 08:13:36

    which will show when the log groups switched. You can use DBMS_LOGMNR to 'mine' the redo logs for changes, including the date/time of the change, which will give you, I believe, the information you want. Other than using Logminer there isn't a data dictionary view which logs each change to a redo log.