Re: How to improve performance using Oracle Spatial

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 6 Jan 2009 14:35:25 -0800
Message-ID: <bf46380901061435m57e54d4bne7abb0ee809612f4_at_mail.gmail.com>



Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Sun, Jan 4, 2009 at 8:57 AM, Eriovaldo Andrietta <ecandrietta_at_gmail.com>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 http://method-r.com/software/profiler-info

Jared

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 06 2009 - 16:35:25 CST

Original text of this message