Home » RDBMS Server » Performance Tuning » IO Performance Problems
IO Performance Problems [message #286660] Sun, 09 December 2007 10:26 Go to next message
Bob.Smith
Messages: 1
Registered: December 2007
Location: United States
Junior Member
We have many heavy transactions that cause our database to run very slow.

The transactions are taking up most of the IO bandwidth.

We are running oracle 10G on Oracle Unbreakable Linux, and have already tuned, indexed and optimized these transactions several times - resulting in very little gain.

Do you know of a way I can control the load these heavy transactions are creating?
Re: IO Performance Problems [message #286665 is a reply to message #286660] Sun, 09 December 2007 11:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How to Identify Performance Problem and Bottleneck

Regards
Michel
Re: IO Performance Problems [message #286674 is a reply to message #286660] Sun, 09 December 2007 12:42 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
We ...
Quote:

have already tuned, indexed and optimized these transactions several times


apparently not enough

Michael
Re: IO Performance Problems [message #287248 is a reply to message #286660] Tue, 11 December 2007 10:58 Go to previous messageGo to next message
Alex.Golomb
Messages: 1
Registered: December 2007
Location: Ukraine
Junior Member
If you already tuned (as you say) the next logical place to check is the database, have you checked your cache hit ratio, etc...?

If you are looking for another solution - At my company, we had similar problem on Oracle Apps environment installed in a RAC configuration.

We installed an application called MoreVRP (www.more-resource.com) that allows us to control how much of the CPU and IO each transaction in the DB takes. There is a nice slider for choosing.
maybe it can help you.

There is a link on the site to a short video that can probably explain this better than my english Embarassed
(here is a direct link -> short video).

hope it helps...
Re: IO Performance Problems [message #287250 is a reply to message #286660] Tue, 11 December 2007 11:20 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>have you checked your cache hit ratio, etc...?
You are joking, right?

http://www.oracledba.co.uk/tips/choose.htm
The Buffer Cache Hit Ratio is mythical indicator of performance
Previous Topic: How to disable archivelog generation for a patricular session ?
Next Topic: Need to improve query performance
Goto Forum:
  


Current Time: Sat Dec 03 04:10:09 CST 2016

Total time taken to generate the page: 0.10014 seconds