Re: Should my extents be bigger?

Jacques Raymond Kilchoer <jrkilch_at_costcare.com> wrote:

>Oracle7 Server Release 7.1.3.2.0 - Production Release
>VAX OpenVMS V6.1-1H2
 

>I have a tablespace called TEMP with an initial_extent = 256,000
> a next_extent = 1,048,576
> a min_extents = 2
> a max_extents = 121
>(see below)

These storage parameters are the default storage prarameters for the objects that are going to be created in this tablespace. A tablespace is a logical partition that is used to hold logically releated objects together. You just cannot store data into a tablespace without createing any kind of segments like tables, indexes etc. The actual data goes into those objects that you create. Objects grow dynamically when insert more data into them.

>The data file for the TEMP table has 524,288,000 bytes
>(see below)
 

>It seems to me that since tablespace TEMP has a max_extents of 121, it
>can use up
>at most 1 * 256,000 (initial_extent) + 120 * 1,048,576 (next_extent)
> = 256,000 + 125,829,120 = 126,085,120

Try to look into Oracle Administrator's guide for some info on these parameters. Allocation to the next extents depends on the PCTINCREASE parameter that you specify for the object.

>Since 126,085,120 is less than 524,288,000 I would think that the
>datafile for the
>tablespace never gets used to its full capacity.
 

>Is my understanding correct?
>If so, what should I do? Increate the next_extent size or the
>max_extents?

Venkateswara Rao. Received on Fri Sep 20 1996 - 00:00:00 CEST