Re: How to improve performance using Oracle Spatial
Date: Sun, 4 Jan 2009 14:57:32 -0200
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
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 ?
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.
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?
> --- 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