Re: Oracle Book Mal-practice...

The answer, as it frequently happens, is 'It depends.'  Separation and physical 
striping of the index storage did improve the performance of a database that 
has enormous performance problems.  Since this is vendor code, the ultimate 
answer is for the vendor to rewrite the code.  Based on our experience with the 
vendor - fat chance!

The storage changes only brought the database performance to minimally 
acceptable.  As others have said on this forum many times, manage by data.  We 
had the data before we made this move.  The SAN team hated the conclusion, but 
one set of the data was their own performance data that they had collected.

There is always that possibility that some of the old axioms do apply so don't 
not arbitrarily throw them out.

Pete Barnett
Database Technologies Lead
Regence


--- On Fri, 5/22/09, Thomas Day <tomdaytwo@xxxxxxxxx> wrote:

> From: Thomas Day <tomdaytwo@xxxxxxxxx>
> Subject: Re: Oracle Book Mal-practice...
> To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
> Date: Friday, May 22, 2009, 8:03 AM
> I was having a discussion with a
> junior DBA the other day about whether tables and
> indexes need to be in separate tablespaces and the issue of
> concurrent access came up.
>  
> My position is that Oracle always reads the index and
> the uses the rowid(s) to access the table.  There is no
> issue of concurrent access.  However, she pulled out the
> latest and greatest Oracle 11 book and sure enough the
> author repeated the old myth about concurrent access and the
> need to separate indexes and tables.
> 
>  
> How can you fight this?  With SANs and logical disks
> there's no certainty that separate tablespaces means
> that you're using separate read/write heads.  I'm
> getting as tired of this argument as I am of the RAID5
> argument.  It shouldn't even be a point of
> discussion.
> 
>  
> Doesn't Oracle have a vested interest in seeing
> that books about Oracle have correct information or does
> that just make for more opportunities for Oracle
> Consulting?
> 


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: