Prev: Incorrect Query
Next: Partitioning Best Practices
From: rgvguplb on 8 Jul 2008 17:05
Hi

Our database generated an alert with a message that reads:

Disk Utilization for 1 D: is 98.61%

This was generated by the default rules available in 10g. We think it
means there's more activity than normal on the disk, but not too sure
what to do about it. I don't think we've changed our application in
any significant way lately. is there a way we can track down what's
happening?

we're using 10g 10.2.0.3.0 on windows 2003 server.

thanks
From: Michael Austin on 8 Jul 2008 20:46
rgvguplb wrote:
> Hi
>
> Our database generated an alert with a message that reads:
>
> Disk Utilization for 1 D: is 98.61%
>
> This was generated by the default rules available in 10g. We think it
> means there's more activity than normal on the disk, but not too sure
> what to do about it. I don't think we've changed our application in
> any significant way lately. is there a way we can track down what's
> happening?
>
> we're using 10g 10.2.0.3.0 on windows 2003 server.
>
> thanks

How many disk devices are in the system? If your db is on one drive
(drive d:) and you have too many connections or requests - you could
easily saturate the drive's bandwidth - and therefore receive the message.

From: rgvguplb on 9 Jul 2008 12:54
On Jul 8, 5:46 pm, Michael Austin <maus...(a)firstdbasource.com> wrote:
> How many disk devices are in the system?  If your db is on one drive
> (drive d:) and you have too many connections or requests - you could
> easily saturate the drive's bandwidth - and therefore receive the message..- Hide quoted text -
>
> - Show quoted text -
hi

well, it's one logical drive, but it's a raid configuration, so
there's more than 1 physical drive.

there should be no other applications running on the server other than
the oracle database. so if it were just oracle, how do we tell what
session/process/program/whatever is chewing up the disks?

thanks

 | 
Pages: 1
Prev: Incorrect Query
Next: Partitioning Best Practices