From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.tools
Subject: Re: TKPROF on winNT
Date: Sat, 11 Nov 2000 15:01:54 +0100
Message-ID: <973951573.22512.4.pluto.d4ee154e@news.demon.nl>
References: <8uf74o$j55$1@nnrp1.deja.com>
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: news.demon.nl 973951573 pluto:22512 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Lines: 20


Please check the init<sid>.ora parameter timed_statistics. It must be false.
To change it dynamically issue
alter system set timed_statistics = true
To change permanently edit the init<sid>.ora

Hth,

Sybrand Bakker, Oracle DBA


<zpayne@my-deja.com> wrote in message news:8uf74o$j55$1@nnrp1.deja.com...
> Does anyone know why i wouldn't be able to see the cpu,
> or elapsed time in tkprof (sql trace).  I don't seem to have any
> problem in UNIX or linux.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.