| Sizing/Estimating the Temporary Tablespace. [message #59928] |
Sun, 04 January 2004 12:05  |
Patrick Tahiri
Messages: 119
Registered: January 2004
|
Senior Member |
|
|
Hei,
Could you please tell me how to evaluate, estimate the size needed for a Temporary Tablespace (For heavy statistics queries/calculs - DSS environment)? Any tips and techniques?
Thank you very much in advance!
Best regards,
Patrick Tahiri.
|
|
|
|
| Re: Sizing/Estimating the Temporary Tablespace. [message #59936 is a reply to message #59928] |
Sun, 04 January 2004 22:38  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
If u have already running environment and u want to configure ur temp tablespace then u can check V$SORT_SEGMENT/V$SORT_USAGE views in very peek times of ur environment.
V$SORT_SEGMENT will show u the size of total temp segment allocated in ur temp TS. And V$SORT_USAGE will show u total amount of temp space used by each active transaction.
Through this valuable information u can decide how much temp space get used in very peek hours in ur env. and according to that statistics u can set ur temp TSs accordingly.
Moreover by the use of V$SORT_USAGE view u can even know which transaction is using much temp space and u can take appropriate steps against it.
I hope it will help u.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
