Re: Digging in to trace files

On Thu, 04 Aug 2005 11:32:12 -0700, EdStevens wrote:

> The file referenced in the above messages is the file in which the
> messages are found. What is this telling me? Is this documented some
> place that I've missed? Certainly an advanced search of MetaLink and
> this ng's archives turned up nothing useful.

You haven't searched enough. You are using MTS and your traces belong to the server processes. You cannot do that before 10G (see "trcsess"). To trace session in a meaningful way it has to be connected through a dedicated server. If not, you will get a piece of trace in each background process which executed your SQL. I don't know which of Tom Kyte's books are you reading but I am sure that he advises people not to use MTS without a real need in all of them. You should take a look at the "Efficient Oracle by Design". You have a lot to learn, young padawan.

-- 
http://www.mgogala.com