Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CPU being hit hard by a query
Harry_Boswell_at_deq.state.ms.us wrote in
news:ihaci0pkeuhsumhgdv3qo7uibim8krmpbo_at_4ax.com:
> The instances are configured pretty much the same.
What version of Solaris?
Which version of Oracle DB?
CBO or RBO?
I bet if you make EXACTLY the same you would see no performance difference.
What about the data in these 3 DBs?
Same amount?
All data recently ANALYZEd?
What does the EXPLAIN PLAN show for each DB? Received on Fri Aug 20 2004 - 17:46:59 CDT