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

From: Amar Kumar Padhi <amar.padhi_at_gmail.com>
Date: Sat, 14 Mar 2009 10:59:22 +0400 (GST)
Message-ID: <26434010.16951237013778193.JavaMail.seven_at_aomfe3p1>

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-
 Effect of number of extents on Oracle I/O performance From: "Joel Wittenmyer" <joel.wittenmyer_at_templarstable.com> 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 Received on Sat Mar 14 2009 - 01:59:22 CDT