RE: Sizing Temporary Tablespace 11gr2 on Linux

An observation: If things that are important to you can terminate abnormally due to a lack of temp space, and if it won't break the bank to have a lot of space for temp, then initially oversize it beyond what you think is remotely possible.  

This can essentially be free if your storage farm has some disks that are in reserve for other uses or are "to be allocated" to some disk group at some future point in time.  

Then monitor as David suggests so you learn your real requirements with 20-20 hindsight. Measure both things, in case you can counter schedule big temp users you cannot change to use less - both in size and bandwidth demand.  

You can ALSO monitor bandwidth sucked on the underlying media from the storage or OS level to see whether that is ever your pacing resource.  

And of course you stuff the answers in your handy-dandy DBA datawarehouseT (pending in my imagination).  

Good luck,  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Fitzjarrell (Redacted sender "oratune_at_yahoo.com" for DMARC)
Sent: Wednesday, September 24, 2014 2:12 PM To: oratips_at_gmail.com; oracle-l
Subject: Re: Sizing Temporary Tablespace 11gr2 on Linux  

No.  

The best way is to monitor TEMP usage over time. Also monitor what queries are using large amounts of TEMP space. There is no magic bullet to managing TEMP tablespace sizing.  

David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"  

On Wednesday, September 24, 2014 10:00 AM, Bala <oratips_at_gmail.com> wrote:  

Gurus,

Is there a quick way to size temporary tablespace size in Oracle 11gr2 for OLTP applications ?

Thank you for any pointers and help

-- 
Bala Rao 

 



--
http://www.freelists.org/webpage/oracle-l