Re: How to improve performance using Oracle Spatial

From: Jared Still <>
Date: Tue, 6 Jan 2009 14:35:25 -0800
Message-ID: <>

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Sun, Jan 4, 2009 at 8:57 AM, Eriovaldo Andrietta <>wrote:

> Hi friends,
> I am trying generate the .txt file using the following command:
> tkprof
> C:\Oracle\product\10.2.0\db_1\admin\oracle10\udump\oracle10_ora_4036.trc
> c:\a_eri\trace4036.txt
> but the program is stopping while running and does not generate the
> .txt file :(
> I cannot see the trace result.

Tkprof will not provide you all of then information in the trace file.

Should you make a habit of using 10046 trace files, you may want to consider a profiler.

Method R has an excellent profiler for Oracle trace files


Received on Tue Jan 06 2009 - 16:35:25 CST

Original text of this message