Re: How to size, calculate the temporary tablespace based on database total size OR database growth?

Wise advice from Stephane.
http://dbasrus.blogspot.com/2008/08/stop-fixing-symptom.html ;)

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au



Shastry(DBA) wrote,on my timestamp of 26/10/2008 2:29 PM:


> Thanks Mark,

> 

> Let me take your advice :) Nice quoting too!!

> 

> 

> Thanks,

> Anantha

> 

> On Sat, Oct 25, 2008 at 10:20 PM, Bobak, Mark <Mark.Bobak_at_proquest.com 

> <mailto:Mark.Bobak_at_proquest.com>> wrote:

> 

>     Stephane has offered some sage advice here.  "Don't fix symptoms,

>     fix root causes."  I like that.  It reminds me of a Tom Kyte quote,

>     "Tune the question, not the query."

> 

>     Seriously though, temp tablespace size isn't necessarily about total

>     database size or growth rates, it's more about the nature of the

>     queries being written.

> 

>     -Mark

> 

>     ________________________________________


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