Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: trace on oracle
just want to see all the sql, It is a developerserver so I do not worry
about the amount of "trace" data...
if did try the tkprof but it only generated a information file, nothing about the actual sql queries like
select * from country .. bla bla bla
looking for at tool just like profiler in mssql.
"HansF" <News.Hans_at_telus.net> wrote in message
news:pan.2005.12.22.15.10.22.601615_at_telus.net...
> 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. ***
>
Received on Thu Dec 22 2005 - 12:30:33 CST