Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TEMP tablespace: a big one or 10 small ones?
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