Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating the default temporary tablespace to locally managed

RE: migrating the default temporary tablespace to locally managed

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 20 Aug 2004 11:19:51 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE725@EXCHMN3>


Roger

   Sorry, things are in a panic here, not much time to research. I think somewhere I saw a formula suggesting your temp tablespace next extent be a multiple of SORT_AREA_SIZE. I haven't conducted any tests, but maybe somebody on this list has.

   As far as splitting the tempfiles, if you have additional storage devices to spread them over, that would be great. Otherwise I doubt if there is much benefit.

   The best idea is to look at your application and see the pattern of sorts. See if you can do more sorts in memory and less on disk. And try to put your temp space on its own storage device, especially if your application does a lot of disk sorts.

Dennis Williams
DBA
Lifetouch, Inc.

"We all want progress, but if you're on the wrong road, progress means doing an about-turn and walking back to the right road; in that case, the man who turns back soonest is the most progressive." -- C.S. Lewis

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Thursday, August 19, 2004 5:29 PM
To: oracle-l_at_freelists.org
Subject: RE: migrating the default temporary tablespace to locally managed

Thanks,_Dennis.
Now_the_default_temp_tbsp_got_convert_to_LMT. I_find_out_it_was_created_1M_uniform_by_default. Do_you_think_it_is_ok_to_keep_the_default?

Also_which_way_is_better?
Four_10GB_tempfiles_or_one_40GB_tempfile?

TIA. Roger

-----Original=20Message-----
From:=20DENNIS=20WILLIAMS=20[mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent:=20Wednesday,=20August=2018,=202004=209:46=20PM To:=20'oracle-l_at_freelists.org'
Subject:=20RE:=20migrating=20the=20default=20temporary=20tablespace=20to=20= locally
managed

Roger=20-=20Create=20the=20new=20temp=20space,=20change=20all=20users=20to=
=20that=20temp=20space,=20then

drop=20the=20old=20one.=20It=20is=20difficult,=20I=20realize,=20but=20you=20
=

just=20can't=20allow
yourself=20to=20become=20so=20emotionally=20attached,=20after=20all=20the=20
=

relationship=20is
temporary.

Dennis=20Williams
DBA
Lifetouch,=20Inc.

"We=20all=20want=20progress,=20but=20if=20you're=20on=20the=20wrong=20road= ,=20progress=20means
doing=20an=20about-turn=20and=20walking=20back=20to=20the=20right=20road;=20
=

in=20that=20case,
the=20man=20who=20turns=20back=20soonest=20is=20the=20most=20progressive."=
=20

--=20C.S.=20Lewis

-----Original=20Message-----
From:=20oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On=20Behalf=20Of=20Roger=20Xu Sent:=20Wednesday,=20August=2018,=202004=205:25=20PM To:=20oracle-l_at_freelists.org
Subject:=20RE:=20migrating=20the=20default=20temporary=20tablespace=20to=20= locally
managed

I_do_not_think_I_can_drop_it_until_a_new_one_is_made_available? So_what_is_the_exact_procedure_to_convert_temp_tbsp_to_LMT?=3D20Thanks.

-----Original=3D20Message-----
From:=3D20Roger=3D20Xu=3D20
Sent:=3D20Wednesday,=3D20August=3D2018,=3D202004=3D205:18=3D20PM To:=3D20Oracle-L_at_Freelists.=3D20Org=3D20(E-mail) Subject:=3D20migrating=3D20the=3D20default=3D20temporary=3D20tablespace=3D= 20to=3D20local=3D
ly=3D20managed

Hi,

In_order_to_do_that,_can_I_drop_and_recreate_the_temp_tbs? Any_better_way_to_accomplish_that?

Thanks,

Roger_Xu

This=3D20e-mail=3D20is=3D20intended=3D20solely=3D20for=3D20the=3D20person=3D
=

20or=3D20entity=3D20
=3D

to=3D20which=3D20it=3D20is=3D20addressed=3D20and=3D20may=3D20contain=3D20c= onfidential=3D20an=3D
d/or=3D20privileged=3D20information.=3D20Any=3D20review,=3D20dissemination= ,=3D20copyin=3D
g,=3D20printing=3D20or=3D20other=3D20use=3D20of=3D20this=3D20e-mail=3D20by=
=3D20persons=3D20or=3D20
=3D

entities=3D20other=3D20than=3D20the=3D20addressee=3D20is=3D20prohibited.=3D=

20If=3D20you=3D20=3D
have=3D20received=3D20this=3D20e-mail=3D20in=3D20error,=3D20please=3D20con=
tact=3D20the=3D20s=3D

ender=3D20immediately=3D20and=3D20delete=3D20the=3D20material.=3D20

This=3D20email=3D20has=3D20been=3D20scanned=3D20for=3D20all=3D20viruses=3D= 20by=3D20the=3D20Mes=3D
sageLabs=3D20Email=3D20Security=3D20System.=3D20Any=3D20questions=3D20plea= se=3D20call=3D20=3D
972-721-8257=3D20or=3D20email=3D20your=3D20request=3D20to=3D20tech_support= @dp7uptx.com=3D
.

Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com

To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org put=20'unsubscribe'=20in=20the=20subject=20line.
--
Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please=20see=20the=20official=20ORACLE-L=20FAQ:=20http://www.orafaq.com
----------------------------------------------------------------
To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org
put=20'unsubscribe'=20in=20the=20subject=20line.
--
Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=

=20you=20can
call=20(972)721-8257.=20 This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes= sageLabs=20Email=20Security=20System. This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20
=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an= d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin= g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20
=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20= have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s= ender=20immediately=20and=20delete=20the=20material.=20 ____________________________________________________________________ This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes= sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20= 972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com= . ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
Received on Fri Aug 20 2004 - 11:20:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US