temp tablespace blow up 2007-08-14 - By Lyall Barbour
Back
Hi all, So, i blew up _the_ temp tablespace the other day with an update
query *pats himself on the back*. I found some down time and dropped it,
looking up on the web how to recreate it, i found CREATE TEMPORARY
TABLESPACE and created it as "temporary" not realizing what i was doing
(just hadn't done it in awhile). Now, night reports and such take 4 hrs
instead of 4 mins to run. Now that i've found the basic syntax to create
a tablespace again, my only real question is if someone can explain about
TEMPORARY tablespaces and what good they'd be for? Are they good for the
"temp" tablespace for queries cause there's only two reasons i found for
the huge amount of time difference for the night process 1) tablespace
used to be regular 4 gig tablespace, now it's "TEMPORARY" 2) i created
the extents wrong and instead of being 767 extents it was 37000. What is
a TEMPORARY TABLESPACE? Lyall
--
We've Got Your Name at http://www.mail.com !
Get a FREE E-mail Account Today - Choose From 100+ Domains
<DIV>Hi all,</DIV>
<DIV> So, i blew up _the_ temp tablespace the other day with an update
query *pats himself on the back*. I found some down time and dropped it,
looking up on the web how to recreate it, i found CREATE TEMPORARY TABLESPACE
and created it as "temporary" not realizing what i was doing (just hadn't done
it in awhile).</DIV>
<DIV> Now, night reports and such take 4 hrs instead of 4 mins to run.<
/DIV>
<DIV> Now that i've found the basic syntax to create a tablespace again,
my only real question is if someone can explain about TEMPORARY tablespaces and
what good they'd be for? Are they good for the "temp" tablespace for
queries cause there's only two reasons i found for the huge amount of time
difference for the night process 1) tablespace used to be regular 4 gig
tablespace, now it's "TEMPORARY" 2) i created the extents wrong and instead of
being 767 extents it was 37000.</DIV>
<DIV> </DIV>
<DIV>What is a TEMPORARY TABLESPACE?</DIV>
<DIV> </DIV>
<DIV>Lyall</DIV><BR>
--
<div>We've Got Your Name at <a href="http://www.mail.com/?utm_source=mail_sent
_footer&utm_medium=email&utm_term=070621&utm_content=textlink&utm_campaign=we
_got_your_name"target="_blank">Mail.com</a><br>
Get a <b>FREE</b> E-mail Account Today - Choose From 100+ Domains</div>
|
|
