-
Estaimate Size of Temp-Tablespace
Oracle EE 8.1.7.3.50
Hi,
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
Orca
-
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'
-
Thanks Joseph;
Our Environment is OLTP, but due to long-running batch-jobs it's like DSS too. Thank you for the hint and be blessed;
Orca
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|