REPOST: Re: Switching trace files

From: Stephen Ashmore <sashmore_at_neonramp.com>
Date: Sat, 26 Jan 2002 05:43:01 -0600
Message-ID: <6$--$%%%_$_-%$$$%$@news.noc.cabal.int>

The trace file is creating using the SPID of the session you are tracing. You need to logoff and backon to get a new SPID thus you will get a new trace file.
On really busy systems these files can be reused (rare). If you delete a file while the session is still connected (ON UNIX) it wil continue to use the resources it obtained and even continue to use more but you will not be able to see it.

Hope this Helps.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in message news:3c51b6e2.1513268329_at_news.alt.net...
> Is there a way to force a switch in the trace files.
>
> Case in point.
>
> ALTER SESSION SET SQL_TRACE=TRUE;
>
> SELECT Moo FROM Cow;
>
> ALTER SESSION SET SQL_TRACE=FALSE;
>
> I check udump, and I have a nice trace file. I then delete the
> tracefile because I no longer want it.
>
> I then do another trace, and nothing appears in udump. If I bounce the
> (test) server all is back to normal.
>
> max_dump_file_size is set to UNLIMITED,
>
> Do I need to switch the files?
>
> Brian

WAS CANCELLED BY =======: From: "Stephen Ashmore" <sashmore_at_neonramp.com> Control: cancel <u555i76dk8hu94_at_corp.supernews.com> Subject: cmsg cancel <u555i76dk8hu94_at_corp.supernews.com> Date: Mon, 28 Jan 2002 01:25:38 GMT X-Trace: 304323588 6YJQUJJ9VQFI9YWMD6 usenet14.supernews.com X-Complaints-To: newsabuse_at_supernews.com Organization: The World's Usenet -- http://www.Supernews.com Message-ID: <cancel.u555i76dk8hu94_at_corp.supernews.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!news.fh-hannover.de!news-han1.dfn.de!news-nue1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!lon1-news.nildram.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40716273

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sat Jan 26 2002 - 05:43:01 CST