Re: select statement uses 100% CPU

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Wed, 04 Jun 2003 08:41:36 -0500
Message-ID: <cmtrdvcgh0ua5bv4cu7vus6l0rap01dj6b@4ax.com>

I can but it won't solve the problem. What we are trying to figure out is why it takes 2 hours on one system and mere seconds on another when the systems are close to identical.

I even tried relinking the Oracle libraries and executables. No luck. Thanks though..
Vince

On Wed, 4 Jun 2003 08:37:04 +0200, "Stephan Bressler" <stephan.bressler_at_siemens.com> wrote:

>> select * from dba_extents
>Hi,
>Oracle used a /*+ ordered */ hint in the view def. This calls CBO.
>Try your select with a /*+ rule */ hint.
>
>Oracle supplies a new view dba_extents without the hint as a workaround.
>
>Regards
>Stephan
>
Received on Wed Jun 04 2003 - 08:41:36 CDT