Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP tablespace: a big one or 10 small ones?

Re: TEMP tablespace: a big one or 10 small ones?

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 14 Sep 2005 16:28:31 +0200
Message-ID: <dg9c2g$mcv$1@news.BelWue.DE>


sybrandb_at_yahoo.com wrote:
> The temporary tablespace to be used is recorded against the user. This
> means every session will only use one temp tablespace ever: the one
> recorded in dba_users.
>

This question is about 10g.

Perhaps you read at least this before answering such questions:

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10739/tspaces.htm#sthref1141

Regards,
Holger Received on Wed Sep 14 2005 - 09:28:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US