Re: issues with oracle partitioning and SAN striping
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: ryan_gaffuri@xxxxxxxxxxx
- Date: Mon, 6 Nov 2006 07:37:52 -0800
On 11/6/06, ryan_gaffuri@xxxxxxxxxxx <ryan_gaffuri@xxxxxxxxxxx> wrote:
Someone on our team raised concerns about using both oracle table level
partitioning and SAN striping. As I have said before I am more on the
developer side of things. Has anyone had problems with this?
"SAN striping of data file and Oracle partitions) techniques we are using
will sure collide with each other creating worse performance than using
either one of the two. Since SAN is not aware of how oracle is handling the
partitions, data from two hash or range partitions can end up on the same
spindle thereby making it serial I/O."
If you are considering a system where only one session is connected
to the database and causing IO, this makes some kind of sense, though
not a lot I think.
With multiple sesssions connected to the database causing IO, I'm not
sure what they mean by 'collisions'.
Partitioning is a method to manage large amounts of data efficiently,
and improve performance where FTS and Fast Full Scan of indexes
would take place. This tends to reduce IO, no?
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts: