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: select statement uses 100% CPU

Re: select statement uses 100% CPU

From: Vince Laurent <eAddict_at_yahoo.com>
Date: Wed, 04 Jun 2003 10:37:14 -0500
Message-ID: <mf4sdvo7d9523ujmluao1j6cgv6dkpvuc1@4ax.com>


Solved! SAP Note 138639.
Had to remove the statistics from tables owned by SYS and SYSTEM

Thanks for everyones help!
Vince

On Tue, 03 Jun 2003 21:07:58 -0500, Vince Laurent <eAddict_at_yahoo.com> wrote:

>I am trying to debug a system that is not acting right. I have 2
>systems running Oracle 9.2.0.3 on HP-UX11i. BDE has 4 G of RAM, BQA
>has 2G of RAM. The systems are patched to the same or equivilant OS
>level patches and running the same version of Oracle. Both were
>upgraded from an 8.1.7.3 environment.
>
>On BDE if I run the command
>
>select * from dba_extents
>
>it takes just over 2 hours and the CPU is pegged! If I run it on BQA
>it takes seconds and the CPU doesn't even notice it. Both are also 2
>CPU systems.
>
>I have looked at the initSID.ora files (and even dumped the
>v$parameters) and the only parameters that are noticeably different
>are the ones that involve memory allocation. BDE has more so the
>numbers were larger.
>
>I even did a test and made the BDE paramters the same as BQA, bounced
>oracle, and reran the test. Same results.
>
>Any ideas? Sorry for the cross post too.
>Vince
Received on Wed Jun 04 2003 - 10:37:14 CDT

Original text of this message

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