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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE.EXE takes 100% of CPU

Re: ORACLE.EXE takes 100% of CPU

From: Ivek <ivek_at_kliet.com>
Date: Mon, 22 Jul 2002 20:18:27 +0200
Message-ID: <ahhht4$tcecp$1@ID-87429.news.dfncis.de> 





"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:



> 1 sql statements resulting in a merge join cartesian

> 2 excessive parsing

> 3 excessive sorting





1 not possible (no cartesian joins here; also, all our clients are the same
as before, and they worked OK for months)



2 ? hmm how can I found this out? (we didn't have those parsing problems
before, and SGA is of the same size)



3 ? how can I found this out?
Received on Mon Jul 22 2002 - 13:18:27 CDT












Original text of this message













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