RE: Effect of number of extents on Oracle I/O performance

Hi Joel,
I currently have a 9i DB in production having objects with extents in multiples 
of 1000s, haven't dealt with any performance issue with this. I use LMT. 
Perhaps you could elaborate with an example. 

-original message-
Subject: Effect of number of extents on Oracle I/O performance
From: "Joel Wittenmyer" <joel.wittenmyer@xxxxxxxxxxxxxxxxx>
Date: 14-03-2009 02:53


In Oracle 8 and 9 we saw that at 1000 extents performance began to drop
off.  At 2K extents it leapt, laughing maniacally off a cliff.  I know
that 10g is supposed to handle much more than that without a problem. 
Tens or hundreds of thousands perhaps?  Does anyone have experience with
just what the new threshold might be?  Or is the architecture such now
that it is no longer a consideration?

Thanks in Advance.

Joel Wittenmyer
Sr. Database Architect
Sr. Data Architect
HealthTrans

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



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

Other related posts: