Re: Question about temporary tablespace

From: W. Scott Moore <sirws_at_hotmail.com>
Date: 2000/04/24
Message-ID: <eE%M4.404$r21.21298@news.uswest.net>#1/1

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 Received on Mon Apr 24 2000 - 00:00:00 CDT