Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail From: "sybrandb@yahoo.com" Newsgroups: comp.databases.oracle.server Subject: Re: TEMP tablespace: a big one or 10 small ones? Date: 14 Sep 2005 01:42:33 -0700 Organization: http://groups.google.com Lines: 8 Message-ID: <1126687353.062965.132610@g43g2000cwa.googlegroups.com> References: <1126686836.529573.152920@z14g2000cwz.googlegroups.com> NNTP-Posting-Host: 144.44.150.152 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1126687358 24563 127.0.0.1 (14 Sep 2005 08:42:38 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 14 Sep 2005 08:42:38 +0000 (UTC) In-Reply-To: <1126686836.529573.152920@z14g2000cwz.googlegroups.com> User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 PXYNLAD004, 1.0 PXYNLAD002 Complaints-To: groups-abuse@google.com Injection-Info: g43g2000cwa.googlegroups.com; posting-host=144.44.150.152; posting-account=3-ZCkwwAAAAif1uTJMVWCyzt_MY2v5ol Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251469 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. -- Sybrand Bakker Senior Oracle DBA