Home » RDBMS Server » Performance Tuning » Temporary Tablespace
Temporary Tablespace [message #128669] Wed, 20 July 2005 01:44 Go to next message
gaurav_hdr2002
Messages: 1
Registered: July 2005
Location: Noida
Junior Member
Hi All ,

I am using Oracle 8i database and getting 100% full temporary tablespace (temp) which is of 900mb. My database contain table with atmost 283 columns max in one table with 600000 records, when i create a temp table and use in our appllication. i takes a lot of time to complete the procedure. What should i do. my Sga size is 550 mb. can increase the size of temp tablespace help?

thanks and regards
Gaurav

Report message to a moderator

Re: Temporary Tablespace [message #128676 is a reply to message #128669] Wed, 20 July 2005 01:57 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

Showing temp space 100% full is not problem, so long its not giving any error message to you or you are facing serious performance issues. In those cases, you may consider increasing it.

Regds
Girish

[Updated on: Wed, 20 July 2005 02:04]

Report message to a moderator

Re: Temporary Tablespace [message #128755 is a reply to message #128669] Wed, 20 July 2005 08:05 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
When you create a temporary table it will be stored in the temporary tablespace. Is the large table you are talking about a temporary table?

Report message to a moderator

Previous Topic: tuning insert
Next Topic: About the sql_text in V$sqlarea
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 27 11:00:55 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.