partitioning for Oracle

From: Yura Pismerov (ypismerov@tucows.com)
Date: Fri May 24 2002 - 09:17:39 EDT


        Sorry for off-topic,
I'm trying to "fight" DBA regarding partitioning method they propose for
our Oracle boxes.
Every time they request a few dozen (!) partitions such as data[0-N],
arch[0-N], redolog[0-N],
trace[0-N] etc etc.

In my opinion it does not make sense since the mentioned partitions are
located on
RAID1+0 so nothing is gained in terms of performance. Also I have to
mess around with moving data once
one of the partitions gets full. Not to mention fewer number of
partitions is obviously easier to
maintain in such events as manual filesystem check.

        Could anybody tell me if there are real advantages of doing that crazy
partitioning ?
Our DBA manager is going to conduct "educational" session with
operations team to explain the reasons
they keep doing this. I just need some more arguments...

Thanks in advance.

-- 
Yuri Pismerov, Sr. System Administrator, 
TUCOWS.COM INC.	(416) 535-0123  ext. 1352
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers


This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:24:22 EDT