Estaimate Size of Temp-Tablespace
Oracle EE 126.96.36.199.50
How could i estimate the max Size of the temp-Tablspace?
- Size like the largest Index-Segment?
- Size like the largest Table ?
Thanks for help
Back in the dark ages of V6 I developped a rule of thumb that the TEMP tablespace should be at least twice the size of the largest object in the database (table or index.) Depending on usage, it might have to be larger (and might be smaller), but that was the starting point. It was based on users doing full table sorts, etc., in a multiple user environment.
I still use it as a starting point, but it is less vital these days with sort areas, undo tablespace etc. and OLTP rather than DSS. Less vital, but causes less problems.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
Our Environment is OLTP, but due to long-running batch-jobs it's like DSS too. Thank you for the hint and be blessed;
Click Here to Expand Forum to Full Width