Home » RDBMS Server » Server Administration » Temp Tablespace Sizing estimation (SUN Solaris)
Temp Tablespace Sizing estimation [message #429328] Tue, 03 November 2009 04:11 Go to next message
kmkumar24
Messages: 69
Registered: January 2007
Location: Singapore
Member
Dear,

I am new to oracle, and I was going through most of the websites, where I cannot get the detailed answer to my question. I want to size the Temporary tablespace for my development database. Each time for different querries, the temp tablespace was not enough, and we are increasing time to time.

Can any one help, how to estimate the size for the temp tablespace for the business neeeds. The application uses the sorting more often for 90% of the reports.

Now the total size for the temporary tablespace is 23gb.

You reference to the correct link will be apprecitable.

Thanks
Re: Temp Tablespace Sizing estimation [message #429340 is a reply to message #429328] Tue, 03 November 2009 04:47 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hope this will help you.
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:374218170986



Sriram
Re: Temp Tablespace Sizing estimation [message #429385 is a reply to message #429328] Tue, 03 November 2009 08:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No Oracle version was provided. Commenting on this topic would be pure guesswork.
Depending Oracle version, there are certain options you can look into.
It also depends on you created the tablespaces.
Search this forum. This topic is discussed many times.

[Updated on: Tue, 03 November 2009 08:09]

Report message to a moderator

Re: Temp Tablespace Sizing estimation [message #429403 is a reply to message #429328] Tue, 03 November 2009 09:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You are asking, "How big is big enough?".

We don't have your tables.
We don't have your data.
We don't have your application.

TEMP needs to be big enough so it can handle what you need done.
Increase its size until it stops asking for more.
Previous Topic: Oracle server time problem
Next Topic: rows in dba_registry
Goto Forum:
  


Current Time: Thu Dec 12 23:24:13 CST 2024