| Temp Tablespace Sizing estimation [message #429328] |
Tue, 03 November 2009 04:11  |
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 #429385 is a reply to message #429328] |
Tue, 03 November 2009 08:06  |
 |
Mahesh Rajendran
Messages: 9793
Registered: March 2002
Location: oracleDocoVille |
Senior Member |
|
|
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]
|
|
|
| Re: Temp Tablespace Sizing estimation [message #429403 is a reply to message #429328] |
Tue, 03 November 2009 09:34 |
 |
BlackSwan
Messages: 3357
Registered: January 2009 |
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.
|
|
|
] 
Members
Search
Help
Register
Login
Home
