Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trace on oracle

Re: trace on oracle

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 22 Dec 2005 09:20:18 -0800
Message-ID: <1135272001.781862@jetspin.drizzle.com>


gusse wrote:
> im very new to oracle...
>
> how do i trace the sql queries ??
>
> using windows oracle version 8

Trace what with which, specific, Oracle version?

8.0.3, 8.04, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7? All currently unsupported or in the process of desupport.

But I'd suggest you look up the following: Explain Plan
Autotrace
TKPROF
DBMS_SUPPORT
DBMS_TRACE

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Dec 22 2005 - 11:20:18 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US