Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sun sparc oracle solaris--- && troubles
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/
Received on Fri Dec 29 2000 - 13:52:22 CST