Effect of number of extents on Oracle I/O performance

From: Joel Wittenmyer <joel.wittenmyer_at_templarstable.com>
Date: Fri, 13 Mar 2009 17:50:54 -0500
Message-Id: <E1LiGDO-0001GY-A4_at_host.ckr-hosting.com>

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

Received on Fri Mar 13 2009 - 17:50:54 CDT

Original text of this message