Re: Question about temporary tablespace

W. Scott Moore <sirws_at_hotmail.com> schreef in berichtnieuws eE%M4.404$r21.21298_at_news.uswest.net...
> Thanks for the tips... (see below)
>
> > > CREATE TABLESPACE TEMPORARY DATAFILE 'E:\Oracle\GPRO\Tmp1GPRO.ora'
 SIZE
 200M
> > > DEFAULT STORAGE ( INITIAL 2m NEXT 2m MINEXTENTS 1 MAXEXTENTS 100
 PCTINCREASE
> > > 0) TEMPORARY;
> > > ALTER DATABASE DATAFILE 'E:\Oracle\GPRO\Tmp1GPRO.ora' AUTOEXTEND ON;
> > >
> > > has grown from 200M to 1.3 GB (datafile size). I am not sure what
 would
> > > cause this. Maybe a large query or something?
> >
> > Multiple sorts occurring? Anyway the default storage clause applies to
> > individual segments only, and you directed the tablespace to extend!
>
> Shouldn't the tablespace have reached max extents at 200 MB (100 extents)?
> Or does the AUTOEXTEND override that?
>
> Thanks,
> Scott
>
>

Doesn't override, but the default storage clause applies to every individual temporary segment. As soon as you create a second secondary segment, the tablespace will ultimately extend. It is a default storage clause, you don't and can't tell it _this way_ (you can with the autoextend clause) the tablespace should stop at 200M.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Apr 24 2000 - 00:00:00 CDT