Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newscore.univie.ac.at!skynet.be!newspost001!tjb!not-for-mail Reply-To: "Matthias Hoys" From: "Matthias Hoys" Newsgroups: comp.databases.oracle.server References: <1126686836.529573.152920@z14g2000cwz.googlegroups.com> Subject: Re: TEMP tablespace: a big one or 10 small ones? Date: Wed, 14 Sep 2005 21:45:20 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original Lines: 25 Message-ID: <43287dd0$0$29280$ba620e4c@news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: d760b6ac.news.skynet.be X-Trace: 1126727120 news.skynet.be 29280 81.244.13.166:1074 X-Complaints-To: usenet-abuse@skynet.be Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251521 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. > Mmm ... I don't quite understand why the performance of the small tablespaces was better than using 1 big tablespace - were all tablespaces created on the same disks ? I guess you could see performance improvements if you have different temp tablespaces on different disks ?