Re: Oracle Table extents

If you have multiple processors, you could use Parallel Query option. E.G. Let say the extents come up to 150 MG(1 Million Rows) and there are 4 processors on box.

Break datafile into 3X51MG files, re-create table into 3 separate extents of 50MG with a min extents equal to 3(in version 8, use partitions). Also put the degree of parallelism on table to 3.

If need table operational 24 hrs a day, truncating is obviously not an option. Received on Sun Mar 07 1999 - 09:52:12 CST