Oracle-L: Re: temp space

From: <Rajesh.Rao_at_jpmchase.com>
Date: Fri, 17 Jan 2003 10:22:23 -0800
Message-ID: <F001.0053341C.20030117102223@fatcity.com>

Chris,

Add the following in your init.ora. event = "1652 trace name errorstack level 3". And check the user dump destination after u encounter the error.

In case, downtime is not an option, or you cannot set it at the individual session levels , another way of doing it is by coding for a servererror on database trigger, and then maybe, use dbms_system.ksdwrt to write the error details in the alert log. I leave it to you to figure out the rest.

Hope this helps.

Raj

                                                                                                                       
                    Chris Stephens                                                                                     
                    <ChrisStephens_at_a        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    ffina.com>              cc:                                                                        
                    Sent by:                Subject:     temp space                                                    
                    root_at_fatcity.com                                                                                   
                                                                                                                       
                                                                                                                       
                    January 17, 2003                                                                                   
                    09:54 AM                                                                                           
                    Please respond                                                                                     
                    to ORACLE-L

anyone know how to identify the session that caused a ORA-1652?

-thank you

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Rajesh.Rao_at_jpmchase.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). Received on Fri Jan 17 2003 - 12:22:23 CST