| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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:
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: jwilton_at_speakeasy.net 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.net -- Author: BanarasiBabu Tippa INET: btippa_at_ORsoftware-india.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 Mon Jan 13 2003 - 06:33:53 CST
 |
 |