Re: How to improve performance using Oracle Spatial

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sun, 4 Jan 2009 14:57:32 -0200
Message-ID: <90b7e6bd0901040857l7dc28df8rff1e3a8ed89abcbc_at_mail.gmail.com>

Hi friends,

a.) I am using: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod, running on Windows Vista (for study), in the company it runs on Unix.

b.) Yes, there are spatial indexes.

      My goal is look at the trace result in order to know if the index is selective

c.) There are lot of procedures running. There are lot of queries running inside of each process, using spatial and not spatial data.

     It takes around 3 hours to finish (in my computer at home).

d.) I generated the trace for the hole process and got a big trc file, it is with 4.439.703kb.

     I used:
            to start: exec dbms_system.set_ev (131,801,10046,12, '');
            to stop: exec dbms_system.set_ev (131,801,10046,0, '');

     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.

Question 1 : How can I extract information from the trc file ? Is there another way ?

Question 2 : Can I select the information for extract ?

My concerns:

     If I cannot extract .txt from trc I will run the process step by step and getting not big trc files to be possible evaluate its.

thanks
Eriovaldo

On Sat, Jan 3, 2009 at 6:20 PM, Job Miller <jobmiller_at_yahoo.com> wrote:

> how about version, query, and plan?
>
> spatial operators follow the same rules as everything else does.
>
> R-Tree works like a B-Tree essentially, so is the spatial index being used?
> Are there other predicates? is the spatial index selective?
>
> are you querying for points on a map using a box the size of north america?
>
> Job
>
>
> --- On Wed, 12/31/08, Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:
>
> > From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> > Subject: How to improve performance using Oracle Spatial
> > To: mccdba1_at_yahoo.com
> > Cc: oracle-l_at_freelists.org
> > Date: Wednesday, December 31, 2008, 11:45 AM
> > I need increase performance in my aplication.
> > It is using Oracle Spatial.
> > Could someone help me ?
> > All basic resources were applied.
> >
> > I am talking about a big database with 100.000 lines with
> > geometry datatype.
> > Using sdo_relate, sdo_join and others.
> > I think that database parameters must be reviews, Which
> > ones ? PGA, SGA
> > Is there any in special ?
> >
> >
> > Thank you.
> > Eriovaldo
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jan 04 2009 - 10:57:32 CST