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 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" <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > 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" <[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 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
