OraFAQ Forum: Unix » High Disk utilisation

Home » Infrastructure » Unix » High Disk utilisation (10.2.0.3 HP unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

High Disk utilisation [message #514914]

Thu, 07 July 2011 04:51

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Hi
I have a database in which the disk utilisation of server is 100% for 90% of the time.How to find out which process is causing high I/O and is there any way to tune it....

Report message to a moderator

Re: High Disk utilisation [message #514918 is a reply to message #514914]

Thu, 07 July 2011 04:59

cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester

Senior Member

Where did you get those figures from?
Are you sure it's the DB and not something else on the server causing the problem?

If you are sure it's the DB - statspack or awr might be a good place to start.

[Updated on: Thu, 07 July 2011 05:00]

Report message to a moderator

Re: High Disk utilisation [message #514919 is a reply to message #514914]

Thu, 07 July 2011 05:01

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You should better post this question in a Unix forum.
It does not matter it is an Oracle process.
And how do you know it is not another one?

Regards
Michel

Report message to a moderator

Re: High Disk utilisation [message #514925 is a reply to message #514919]

Thu, 07 July 2011 05:10

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

It is the oracle processes...I can see it in glance....Actually I found out that two segments are contributing to high physical reads in all the awr reports...Any solution

Report message to a moderator

Re: High Disk utilisation [message #514926 is a reply to message #514925]

Thu, 07 July 2011 05:13

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If you know it is Oracle processes then you know which process it is otherwise you don't know you just think it is.

Regards
Michel

Report message to a moderator

Re: High Disk utilisation [message #514929 is a reply to message #514926]

Thu, 07 July 2011 05:15

sekar52
Messages: 141
Registered: May 2010
Location: Mumbai

Senior Member

Actually we are using shared server architecture so the shared server processes are present in it and the Disk I/O is 100% most of the time...

Report message to a moderator

Re: High Disk utilisation [message #514932 is a reply to message #514929]

Thu, 07 July 2011 05:39

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And there are no other processes?

Regards
Michel

Report message to a moderator

Previous Topic:	need suggestion
Next Topic:	Error in script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 06:07:05 CST 2024