Re: sun sparc oracle solaris--- && troubles

That is too much hassle to do. The best way is use high speed hardware to fix this problem. We have similiar performance problem. ON SUn 1000E a sql statement run 10 minutes , same sql statement on dell 2450 ( 1Ghz) only take 30 seconds. SUN computer CPU speed can not compare with PC now. In theory, explain will help you the debug sql performance. The problem is programmer or verdor don't want spent time on it.

In article <3A4CEB9B.CB8FBC39_at_usgs.gov>,   Troy Meyerink <meyerink_at_usgs.gov> wrote:
> If you want to see how Oracle is running the SQL, use the explain plan
> tool.
> Unless you write a lot of SQL, I wouldn't assume anything with the
 Oracle
> SQL parser. Also if you want help on tuning a system, you might want
 to
> provide more information about the system.
>
> Troy Meyerink
> Oracle DBA
> Raytheon
> USGS \ EROS Data Center
>
> siad_at_my-deja.com wrote:
>
> > hi all...
> > we have a sun station with solaris and oracle on it.......and its
> > incredible slow!!!
> > some statements take about 1 min (on my notebook few
> > secs)....especially a OR-clause in a statement with a 4table join
 gets
> > incredible slow....but if i devide the statement into 2
> > statements....the 2 are very fast....shouldnt oracle do the same
> > (devide the join and then bring it together)?????
> >
> > thx in advance....siad
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Sat Dec 30 2000 - 14:28:24 CST