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

  • From: Nuno Souto <dbvision@xxxxxxxxxxxx>
  • Date: Sun, 26 Oct 2008 16:43:25 +1100

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

--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxx



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@xxxxxxxxxxxx <mailto:Mark.Bobak@xxxxxxxxxxxx>> 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

    ________________________________________


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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2008