Re: How many extents is too many?

From: Mr. Richardjr F. Sullivan <LGHX88A_at_prodigy.com>
Date: 1996/11/19
Message-ID: <56raou$1s30_at_usenetp1.news.prodigy.com>#1/1

I've had hundreds of extents, however they were for the same table in a tablespace of their own, making the extents contiguous anyway. Extents seem to bother performance only when they are scattered about in a tablespace amongst many tables/indexes and either full table scans are performed or there is already contention for that disk. Subsequent reorgs should occur on a regular basis anyway for PM purposes...... Just my $.03 (inflation....!) Received on Tue Nov 19 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Sharath V. Kalvakota: "Help: Oracle error ORA-00600 !!"
Previous message: Dug Birdzell: "Inserts to one table by many users"
Maybe in reply to: Dana Stockler: "How many extents is too many?"
Next in thread: Khairuddin Rezak: "Re: US-CA-Hollywood-Sybase Database Analyst-Oracle skills, UNIX background"
Reply: Randy Dewoolfson: "Re: How many extents is too many?"
Reply: Allen Kirby: "Re: How many extents is too many?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message