You will have to forgive me, I am a db2 dba. How do I increase the log buffer?

-----Original Message-----
From: "Rüdiger J. Schulz" [mailto:oracledba-ezmlmshield-x69368490.[Email address protected]
Sent: Friday, June 29, 2007 9:26 AM
To: LazyDBA Discussion
Subject: Re: oracle errors

increase log_buffer and / or increase amount of redo-log-groups and-size
hth
Rüdiger J. Schulz
sosys-berlin.de

Schleicher Jeremy D. schrieb:

>I am seeing a ton of these errors in my database, any idea what I need
>to do to fix them?
>
>
>
>Jun 29, 2007 8:56:13 AM Metrics "Database Time Spent Waiting (%)" is at
>92.75452 for event class "Commit" -
>
> Jun 29, 2007 8:53:12 AM Metrics "Database Time Spent Waiting (%)" is at
>9.3135 for event class "Commit" -
>
> Jun 29, 2007 8:29:12 AM Metrics "Database Time Spent Waiting (%)" is at
>56.29599 for event class "Commit" -
>
> Jun 29, 2007 7:57:05 AM Metrics "Database Time Spent Waiting (%)" is at
>5.98784 for event class "Commit" -
>
> Jun 29, 2007 7:50:02 AM Metrics "Database Time Spent Waiting (%)" is at
>70.79859 for event class "Commit" -
>
> Jun 29, 2007 7:48:02 AM Metrics "Database Time Spent Waiting (%)" is at
>43.99604 for event class "Commit" -
>
> Jun 29, 2007 7:02:32 AM Metrics "Database Time Spent Waiting (%)" is at
>69.77716 for event class "Commit" -
>
> Jun 29, 2007 7:01:32 AM Metrics "Database Time Spent Waiting (%)" is at
>38.07206 for event class "Commit" -
>
> Jun 29, 2007 6:42:13 AM Metrics "Database Time Spent Waiting (%)" is at
>81.01243 for event class "Commit" -
>
> Jun 29, 2007 6:40:13 AM Metrics "Database Time Spent Waiting (%)" is at
>37.00963 for event class "Commit"
>
>
>
>
>
>Thanks!
>
>
>
>
>
>Jeremy Schleicher
>
>ERP Database Administrator
>
>Florida State University
>
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>

--
Rüdiger J. Schulz
Normannenstraße 4
D-14129 Berlin
mobil: +49 (0) 178 / 815 13 36
fax/ab: +49 (0) 30 / 80 40 47 56
eMail: [Email address protected]
im web: sosys-berlin.de





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page