DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: archive logs

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    anybody know how i can figure out how many archive logs i can generate in 1 day or 1 hr?
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Do you want to count them, or find out how much throughput your system has?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    v$log_history
    Jeff Hunter

  4. #4
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    I saw a script somebody had written which told me how many average archive logs were written for 1 day. thanks 4 ur help
    "High Salaries = Happiness = Project Success."

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you dont need a script fot that, it is recorded in control file therefore V$ views

  6. #6
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Just check creation time for archive log files using shell commands.

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