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

Thread: can we stop to record log switch in Alert.log?

  1. #1
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175

    Question can we stop to record log switch in Alert.log?

    Hi All,

    Is there a way to stop log switched to record in Alert.Log.
    The file is growing very fast to lot of log switches.

    Thanks
    Sridhar
    Sridhar R Patnam

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Maybe the problem is that you are doing too many log switches not that the alert log is filling up. If you use Unix you can probably create a shell script that runs in a cron to either delete the alert log of rename and compress. Oracle will recreate the file, empty and start filling it again. Depending on the amount of DML if you are doing more than 20-30 log switches an hour during peak utilization you may want to increase the size of the log files. You may also want to add additional log groups. There are scripts that give you information in waits on this site that might give you some insight. I'm not sure how you suppress the log switch message in the alert log or why you would want to. That is one way of looking at how busy your database is and that it is doing what it is supposed to be doing. There are many other ways of finding out if your database is working properly of course.

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    Thanks for the info .. I'll write scripts to manager Alert.Log
    Sridhar R Patnam

  4. #4
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    There is no way to stop Oracle from recording log switch in Alert log. Your database is experiencing high DML activity, so you can think about increasing the size of online redologs.
    However, you must remember the downfall, checkpoints can occur less frequently, causing higher recovery time if you have not tuned other aspects to take care of recovery time (like checkpoint interval).

    Originally quoted by gandolf989:
    ......You may also want to add additional log groups.....
    How will adding additional log groups affect number of log switches??

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  5. #5
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Originally posted by Raminder
    Originally quoted by gandolf989:
    How will adding additional log groups affect number of log switches??
    I imagine that Gandolf meant that adding additional log groups would give more time to ARC process to do archive jobs since 20-30 logfile switchs per hour.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  6. #6
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Originally posted by Calvin_Qiu:
    quote:
    --------------------------------------------------------------------------------
    Originally posted by Raminder
    Originally quoted by gandolf989:
    How will adding additional log groups affect number of log switches??
    --------------------------------------------------------------------------------

    I imagine that Gandolf meant that adding additional log groups would give more time to ARC process to do archive jobs since 20-30 logfile switchs per hour
    I think the problem posed by Patnams was about the fast fill of alert log due to log switches.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.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