Re: Permanent TS for sorting

  • From: <rjsearle@xxxxxxxxx>
  • To: Ron.Reidy@xxxxxxxxxxxxxxxxxx
  • Date: Tue, 27 Sep 2005 09:07:43 +1000

Someone finally got the joke. :-O mind you it's a long way to say RTFM!

On 9/27/05, Reidy, Ron <Ron.Reidy@xxxxxxxxxxxxxxxxxx> wrote:
>
> Well,
>  I, for one, thought Mladen's and Carel's posts were damned funny (
> http://www.webster.com/cgi-bin/dictionary?book=Dictionary&va=sarcasm&x=0&y=0)
> :D
>  --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>   -----Original Message-----
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Carel-Jan Engel
> *Sent:* Monday, September 26, 2005 10:46 AM
> *To:* Hollis, Les
> *Cc:* jim_kennedy@xxxxxxxxxx; oracle.tutorials@xxxxxxxxx;
> oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: Permanent TS for sorting
>
> Before I get flamed by anyone on this list:
>
> Please read Mladens first answer to he OP.
> I was just adding some topping to the cake.
> SYSTEM seems to be the right tablespace for that purpose.
> ;-)
>
>   Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> === On Mon, 2005-09-26 at 10:59 -0500, Hollis, Les wrote:
>
> Quote From Carel-Jan Engel "You only need to issue 'ALTER USER deepak
> TEMPORARY TABLESPACE system';"
>
>
>
>
>
>
>
>
>
>
>
> And one thing you DO NOT want to do is to put everyone in SYSTEM
> tablespace for a temporary tablespace.
>
>
>
> One of the main reasons Oracle provided a "default temporary tablespace "
> capability with 9i was to avoid users using SYSTEM and badly defragmenting
> it
>
>
>
> If you don't already have one, create a tablepspace "TEMP" (or whatever
> you want to call it) as type temporary and allocate tempfile space for it.
>
>
>
> Then alter the database default temporary tablespace to that tablespace
> you just created
>
>
>
>
>
> Then switch all users to that tablespace using the sc ript provided by
> Carel-Jan Engel
>
>
>
>  ------------------------------
>
> *From:*oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> *On Behalf Of *Kennedy, Jim
> *Sent:* Monday, September 26, 2005 9:24 AM
> *To:* Carel-Jan Engel; oracle.tutorials@xxxxxxxxx
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: Permanent TS for sorting
>
>
>
>
>
>
> -----Original Message-----
> From: Carel-Jan Engel 
> [mailto:cjpengel.dbalert@xxxxxxxxx<cjpengel.dbalert@xxxxxxxxx>
> ]
> Sent: Sun 9/25/2005 11:14 PM
> To: oracle.tutorials@xxxxxxxxx
> Cc: Kennedy, Jim; oracle-l@xxxxxxxxxxxxx
> Subject: Re: Permanent TS for sorting
>
> No,
>
> You only need to issue 'ALTER USER deepak TEMPORARY TABLESPACE system';
> In that way the default temporary tablespace is overruled for the user
> specified.
>
> If you want to do this for all users you can execute somethng like this
> from SQL*Plus.
>
> set hea off
> set pagesize 0
>
> SELECT 'ALTER USER '||USERNAME||' TEMPORARY TABLESPACE system;'
> FROM DBA_USERS
>
> SPOOL deepak.sql
> /
> @deepak.sql
>
> That helps you to change all users in an efficient way.
>
>
> Best regards,
>
> Carel-Jan Engel
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
>
> On Mon, 2005-09-26 at 11:02 +0530, DBA Deepak wrote:
>
> > Will it not use the default temp TS of the Database?
> >
> >
>
>
>
> Carel-Jan is correct. But why do you want to do this? It is less effecient
> than using the temporary tablespace. You can create a 2nd temp tablespace
> (as temporary) and have it use that if you are tring to use a different one.
> With the perm tablespace you are going to generate a lot more redo and
> extent allocation/deallocation.
> Jim
>
>
>
>  ------------------------------
> This electronic message transmission is a PRIVATE communication which
> contains information
> which may be confidential or privileged. The information is intended to be
> for the use of the individual
> or entity named above. If you are not the intended recipient, please be
> aware that any disclosure,
> copying, distribution or use of the contents of this information is
> prohibited. Please notify the sender
> of the delivery error by replying to this message, or notify us by
> telephone (877-633-2436, ext. 0),
> and then delete it from your system.
>
>

Other related posts: