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

If you're comparing MHz to MHz ... sure enough the PCs will win ... *BUT* them little SPARC processors are RISC chips ... and wait til you get a chance to try out a SPARC 3!
jc

In article <92lgh3$qdr$1_at_nnrp1.deja.com>,   mend_at_my-deja.com wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Sun Jan 07 2001 - 06:08:14 CST