Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!news-fra1.dfn.de!news-stu1.dfn.de!news.belwue.de!news.uni-stuttgart.de!carbon.eu.sun.com!btnet-feed5!btnet!news.btopenworld.com!not-for-mail
From: "Jonathan Lewis" <jonathan@jlcomp.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: TEMP tablespace: a big one or 10 small ones?
Date: Wed, 14 Sep 2005 10:06:13 +0000 (UTC)
Organization: BT Openworld
Lines: 53
Message-ID: <dg8sml$hll$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>
References: <1126686836.529573.152920@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: host86-131-2-232.range86-131.btcentralplus.com
X-Trace: nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com 1126692373 18101 86.131.2.232 (14 Sep 2005 10:06:13 GMT)
X-Complaints-To: news-complaints@lists.btinternet.com
NNTP-Posting-Date: Wed, 14 Sep 2005 10:06:13 +0000 (UTC)
X-RFC2646: Format=Flowed; Original
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MSMail-Priority: Normal
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251473


<schonlinner@yahoo.com> wrote in message 
news:1126686836.529573.152920@z14g2000cwz.googlegroups.com...
> Hi,
>
> we have an Oracle 10g database on a HP/UX machine (parallel queries
> enabled). Users access the database and perform selects on the tables,
> sometimes very large selects. Additionally during monthly production
> huge amounts of data need to be put into the database. Currently the
> database is not productive, we are only testing...
>
> I first created a single 30GB temp tablespace for the database and
> measured the performance of queries. After that I created 10
> 3-GB-temp-tablespaces and assigned them to a tablespace group, and
> assigned the tablespace group as a temporary tablespace to the user
> executing the queries. The performance then was slightly better.
>
> Now my question is: If there is a huge query during monthly production
> which - say - would need 20 GB of temp space in order to do some
> sorting and is forced to use only a single processor, can Oracle then
> use several of the small tablespaces to suffice the space need of 20GB
> or does the query break due to non sufficient temp tablespace?
>
> Best regards,
>  Alex
>


Have a look at this item, whilst the bit about music
might be irrelevant, the bit about TEMP could have
been written with you in mind.

        http://www.dizwell.com/2005/09/music-and-temp.html


-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle - Volume 1: Fundamentals
On-shelf date: Nov 2005

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Sept 2005