A DB2 DBA! hehe. Oh my! Phew! Ouch! Hehe. Jeremy, how have you been? Hehe.

It's Fridayyyyyyy! Partyyyyyyy!

Have a great Day and Weekend!





Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Jeanine Blomberg is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: Schleicher Jeremy D. [mailto:oracledba-ezmlmshield-x20705313.[Email address protected]
Sent: Friday, June 29, 2007 9:50 AM
To: LazyDBA Discussion
Subject: RE: oracle errors

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




---------------------------------------------------------------------
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