Title: RE: limiting temp space per user
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-
From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]]
Sent: Monday
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:
SQL alter user scott quota 10M on temp;
User altered.
HTH, Krishna
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
Title: RE: limiting temp space per user
create a smaller temp table and assign the users account to it.
-Original Message-
From: Babu Nagarajan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 9:24 AM
To: Multiple recipients of list ORACLE-L
Subject: limiting temp space
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 [EMAIL
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 [EMAIL PROTECTED]
Sent: Monday, December
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 [EMAIL PROTECTED]
Sent: Monday, December 09, 2002 12:48 PM
The way we do it is that create two temporary
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
1) Turn the pager off ;)
2) Increase temp space
3) 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