Re: TEMP tablespace restricted to schemas

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 8 May 2013 08:35:43 -0500
Message-ID: <CAJvnOJYradS49E3kPcRdJZ-aYBdeOLx0Dp2PTrT+rZ0PUSvXAA_at_mail.gmail.com>

You did run the 'alter user temp_4 temporary tablespace temp_4;' command, correct?

On Wed, May 8, 2013 at 8:28 AM, Apps DBA <dbaorapps_at_gmail.com> wrote:

> Hi Gurus,
> I have a problem in 11.2.0.3 version database where I allocated 4 different
> temp tablespaces to 4 different schemas other than default tablespace to
> ensure schemas must use their sort space and error if it reaches out. But I
> see nothing happening in that where several other schema's sorting is
> taking place in all tablespaces. I had an advice from Sriram (freelists
> group) in referring the below blog, but will it solve my purpose in having
> temporary tablespace groups for schema based sortarea restrictions.
>
> I have created TEMP_1, TEMP_2, TEMP_3, TEMP_4 for dedicated schema
> owners. TEMP_1
> is used by multiple users.
>
> TABLESPACE_NAME
> ----------------------------
> TEMP
> TEMP_3
> TEMP_2
> TEMP_1
> TEMP_4
>
> Basically, I have big trasacations failing due to global default temp
> space, adding to the same TEMP is not helping since application teams are
> looking for some short term fix until they tune thier queries. Please
> advice if any.
>
> Thanks,
> Shankar
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


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

Received on Wed May 08 2013 - 15:35:43 CEST