Re: trace on oracle

On Thu, 22 Dec 2005 15:36:20 +0100, gusse wrote:

> i´m very new to oracle...
>
> how do i trace the sql queries ??
>
> using windows oracle version 8

WHat do you mean by 'trace'? Perhaps 'Explain' the way the statement should run?

Please expand on the Oracle Version 8 stuff - get into sqlplus and give us the info from the login banner. There are huge differences in the way some stuff works, depending on the second, third and even 4th decimals.

Hopefully you are using something like 8.1.7.? and not 8.0.3.?

ALso - are you familiar with the documentation at http://docs.oracle.com (or http://tahiti.oracle.com). It's a lot easier to point to specific areas of the docs to help you than to duplicate them.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***