| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating the default temporary tablespace to locally managed
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
-- 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=Received on Fri Aug 20 2004 - 11:20:21 CDT
=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 -----------------------------------------------------------------
 |
 |