Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2

    Unanswered: How much disk is used for archive logs

    Hi,

    Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
    PL/SQL Release 11.2.0.2.0 - Production
    "CORE 11.2.0.2.0 Production"
    TNS for Linux: Version 11.2.0.2.0 - Production
    NLSRTL Version 11.2.0.2.0 - Production


    I am trying to find out some info from Oracle database Server....Please suggest....

    how to find out the Logfile size and number?
    How often are log changes done?
    How much disk is used for archive logs/
    Total size of disk?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    If you are writing to the RECOVERY_FILE_DEST, then use this:
    Code:
    col name for a20
    SELECT NAME, ROUND(SPACE_LIMIT/1024/1024,1) MB_LIMIT,
       ROUND(SPACE_USED/1024/1024,1) MB_USED,
       ROUND(SPACE_RECLAIMABLE/1024/1024,1) MB_RECLAIMABLE,
       NUMBER_OF_FILES
       FROM V$RECOVERY_FILE_DEST
    /
    COL FILE_TYPE FOR A32
    SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE
    /
    Otherwise use the unix command:
    Code:
    $ df -h /my/archive_logs/backup/path
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Feb 2013
    Posts
    39
    Provided Answers: 2
    Thanks for the quick reply....i am just curious is there a way to find out the

    how often the redo log files switching . like how much time they are taking to archive the logs....

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    query DBA_HIST_LOG
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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