Re: Effect of number of extents on Oracle I/O performance
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: joel.wittenmyer@xxxxxxxxxxxxxxxxx
- Date: Fri, 13 Mar 2009 23:06:22 +0000
I haven't seen what you describe since about 7.3.4, perhaps you could
demonstrate what you mean so that we can try it out ourselves (I have a
likely 11g candidate in mind).
On Fri, Mar 13, 2009 at 10:50 PM, Joel Wittenmyer <
joel.wittenmyer@xxxxxxxxxxxxxxxxx> wrote:
>
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
