RE: Trace file size...
Title: RE: Trace file size... Hi Jeremiah, When ever I run a certain Automation script file, I get an error pointing it to a trace file S000.trc or S001.trc, when I check these files they both point out that they are full, *** TRACE FILE FULL *** What should I do to get rid of this error, why does the error keep coming in this file when it is full? The error in alert is ORA-0600 [17182](pointing to S000.trc and S001.trc files) which is a memory area, I found from a few notes on Metalink that if I set the CURSOR_SHARED=EXACT instead of FORCE, I should be able to get rid of this problem as it is a bug in 8.1.7. I did just that and the problem subsided but today it appeared again, but surprisingly in only some of the scripts, and some scripts run just fine (initially none were functioning but some do now and some don't). I had changed this parameter for the session level, but didn't bounce the instance, should I bounce the instance? -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 4:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Trace file size... On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out? > What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. > wether it is truncated? or it will start writing into another file? It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size. > Is there a way to recognize, which trace file belongs to which session? Unless you are running MTS/Shared Server, the trace output begins with something like: *** SESSION ID:(134.58553) 2003-01-13 09:11:02.501 That's SID.SERIAL# inside the parentheses. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
RE: Trace file size...
my main question is about the file size... Thank you very much... -Original Message- Sent: Monday, January 13, 2003 4:49 PM To: Multiple recipients of list ORACLE-L On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out? > What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. > wether it is truncated? or it will start writing into another file? It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size. > Is there a way to recognize, which trace file belongs to which session? Unless you are running MTS/Shared Server, the trace output begins with something like: *** SESSION ID:(134.58553) 2003-01-13 09:11:02.501 That's SID.SERIAL# inside the parentheses. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa 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).
Re: Trace file size...
On Mon, 13 Jan 2003, BanarasiBabu Tippa wrote: > My SQL_TRACE is on for instance. For the whole instance? Usually, we only run SQL tracing for one or a few sessions at a time. Turning it on for the whole instance makes for a whole lot of tracing and greatly decreased performance. What are you trying to find out? > What will happen to trace file if it reaches MAX_DUMP_FILE_SIZE. > wether it is truncated? or it will start writing into another file? It will end the tracing to the file, and no new file will be started. There will be a message at the end of the file indicating it has reached the max file size. > Is there a way to recognize, which trace file belongs to which session? Unless you are running MTS/Shared Server, the trace output begins with something like: *** SESSION ID:(134.58553) 2003-01-13 09:11:02.501 That's SID.SERIAL# inside the parentheses. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton 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).
