Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Performance doubt on my explicit cursor with subquery

Re: Performance doubt on my explicit cursor with subquery

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 13 Feb 2003 20:22:23 -0800
Message-ID: <3E4C6EFF.361FC72E@exesolutions.com> 





C Chang wrote:



> For got to mention that My system is a 8.1.6 on a single CPU (650Mhz),

> 1G ram of NT 4 with 5 HD.

>

> C Chang




And I forgot to mention that 8.1.6 is about the worst place you could be
doing any SQL. Upgrade to 8.1.7, set your tablespaces up as locally
managed, make sure you use DBMS_STATS to collect regular statistics, and
stop working in obsolete unsupported software with optimizer bugs.



Daniel Morgan
Received on Thu Feb 13 2003 - 22:22:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US