V$LOG_HISTORY information
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: V$LOG_HISTORY information

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    V$LOG_HISTORY information

    Hi All,

    Today i was preparing report like whats Average Archive generation on my DB's so that i can arrange arch dests accordingly.

    While doing this i was pulling data from v$log_history for date wise archive files count that got generated.

    I know this much that v$log_history pulls data from control file.

    But interesting thing i found that on each DB the number of entries in v$log_history are different. What i meant is some had data for last 150+ days while some had till 100 days only.

    I mean its not a problem for me but Why is it like this?

    My guess is Oracle internally manages control file and over writes/deletes data which is not needed as per the load activity on that DB to accomodate new data.

    One thought also touched my mind is concept of "resetlogs opening of DB" but doesnt apply here as all the DB i checked are Prod DB's and they are in no way opened with resetlogs in last 1 yr or 2yr.


    Anybody want to through light on this ??????
    Rgds
    Parag

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    ok i searched on metalink with different terms and i got this...

    Doc ID: 1060139.6

    How to Clean-Up Entries in V$LOG_HISTORY and/or V$ARCHIVED_LOG:
    ==============================================================

    The number of archived redo log files maintained in the controlfile and
    available through V$LOG_HISTORY is determined by the MAXLOGHISTORY parameter of
    the create database command. The archived redo log records are maintained up to
    the value of MAXLOGHISTORY, then wraps and overwrites any previous entries starting
    from the beginning.

    ===================================================

    That explains it . thought might be usefull for somebody...
    Rgds
    Parag

  3. #3
    Join Date
    Oct 2009
    Location
    London
    Posts
    1

    Offcourse yes

    Hi,

    Data stored in v$log_history table depends on maxloghistory parameter of controlfile. This parameter set during database creation or controlfile re-creation. Means if data would be more than it will overwrite and if you want to change value of same parameter and want to store more data in v$log_history then you should need to re-create controlfile.


    Thanks and regards,
    Rahul Jain
    http://www.dbametrix.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width