FAQ
All

Is it possible to limit the temp space used per user - either by using
profiles or some other method? I tried using profiles but it would not allow
me to set a limit on space usage.

TIA

Babu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Babu Nagarajan
INET: orclbabu_at_hotmail.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Godlewski, Melissa at Dec 9, 2002 at 3:53 pm
    create a smaller temp table and assign the users account to it.

    -----Original Message-----
    Sent: Monday, December 09, 2002 9:24 AM
    To: Multiple recipients of list ORACLE-L

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA

    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Godlewski, Melissa
    INET: Melissa.Godlewski_at_hq.doe.gov

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Krishna Rao Kakatur at Dec 9, 2002 at 4:04 pm
    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM
    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Krishna Rao Kakatur
    INET: master_dba_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Khedr, Waleed at Dec 9, 2002 at 4:59 pm
    Temp segments are owned by SYS

    Waleed

    -----Original Message-----
    Sent: Monday, December 09, 2002 11:04 AM
    To: Multiple recipients of list ORACLE-L

    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM
    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Krishna Rao Kakatur
    INET: master_dba_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Khedr, Waleed
    INET: Waleed.Khedr_at_FMR.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Orafaq at Dec 9, 2002 at 5:48 pm
    The way we do it is that create two temporary tablespaces. Use one for the
    production applicationa and other for adhoc users so that adhoc users do not
    mess up the production.

    -Shaleen
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 8:04 AM
    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Krishna Rao Kakatur
    INET: master_dba_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: orafaq
    INET: shgarg_orafaq_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Babu Nagarajan at Dec 9, 2002 at 8:49 pm
    Thats what I have now. But these adhoc reports keep running out of temp
    space and and ends up paging me :-)

    Babu
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 12:48 PM
    The way we do it is that create two temporary tablespaces. Use one for the
    production applicationa and other for adhoc users so that adhoc users do not
    mess up the production.

    -Shaleen
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 8:04 AM

    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Krishna Rao Kakatur
    INET: master_dba_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: orafaq
    INET: shgarg_orafaq_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • DENNIS WILLIAMS at Dec 9, 2002 at 9:09 pm
    Babu - Sounds like this may be more of a user management problem. Also, the
    automatic paging is based on events you selected, isn't it? In Oracle9i, the
    Resource Manager is supposed to run something like EXPLAIN PLAN and if the
    resources exceed preset limits in terms of estimated CPU time or temp space,
    then the query won't even be launched.

    Dennis Williams
    DBA, 40%OCP

    Lifetouch, Inc.
    dwilliams_at_lifetouch.com

    -----Original Message-----
    Sent: Monday, December 09, 2002 2:49 PM
    To: Multiple recipients of list ORACLE-L

    Thats what I have now. But these adhoc reports keep running out of temp
    space and and ends up paging me :-)

    Babu
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 12:48 PM
    The way we do it is that create two temporary tablespaces. Use one for the
    production applicationa and other for adhoc users so that adhoc users do not
    mess up the production.

    -Shaleen
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 8:04 AM

    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Krishna Rao Kakatur
    INET: master_dba_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: orafaq
    INET: shgarg_orafaq_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Babu Nagarajan
    INET: orclbabu_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: DENNIS WILLIAMS
    INET: DWILLIAMS_at_LIFETOUCH.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Deshpande, Kirti at Dec 10, 2002 at 1:38 am
    Turn the pager off;)
    Increase temp space
    Review sorting requirements of this adhoc stuff. Adjust sort_area_size, sort_area_retained_size if possible at the session level to reduce disk sorts.

    Kirti

    -----Original Message-----
    Sent: Monday, December 09, 2002 2:49 PM
    To: Multiple recipients of list ORACLE-L

    Thats what I have now. But these adhoc reports keep running out of temp
    space and and ends up paging me :-)

    Babu
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 12:48 PM
    The way we do it is that create two temporary tablespaces. Use one for the
    production applicationa and other for adhoc users so that adhoc users do not
    mess up the production.

    -Shaleen
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 8:04 AM

    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Deshpande, Kirti
    INET: kirti.deshpande_at_verizon.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Godlewski, Melissa at Dec 10, 2002 at 2:14 pm
    Also you could add a profile to apply a limit to the adhoc queries and any
    that surpass the limit should be tuned by a dba or a power user of the tool.

    MCG

    -----Original Message-----
    Sent: Monday, December 09, 2002 8:39 PM
    To: Multiple recipients of list ORACLE-L

    Turn the pager off;)
    Increase temp space
    Review sorting requirements of this adhoc stuff. Adjust sort_area_size,
    sort_area_retained_size if possible at the session level to reduce disk
    sorts.

    Kirti

    -----Original Message-----
    Sent: Monday, December 09, 2002 2:49 PM
    To: Multiple recipients of list ORACLE-L

    Thats what I have now. But these adhoc reports keep running out of temp
    space and and ends up paging me :-)

    Babu
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 12:48 PM
    The way we do it is that create two temporary tablespaces. Use one for the
    production applicationa and other for adhoc users so that adhoc users do not
    mess up the production.

    -Shaleen
    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 8:04 AM

    SQL> alter user scott quota 10M on temp;
    User altered.

    HTH, Krishna

    ----- Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Monday, December 09, 2002 06:24 AM

    All

    Is it possible to limit the temp space used per user - either by using
    profiles or some other method? I tried using profiles but it would not allow
    me to set a limit on space usage.

    TIA
    Babu
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Deshpande, Kirti
    INET: kirti.deshpande_at_verizon.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Godlewski, Melissa
    INET: Melissa.Godlewski_at_hq.doe.gov

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedDec 9, '02 at 2:24p
activeDec 10, '02 at 2:14p
posts9
users7
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase