Re: select statement uses 100% CPU

From: Oradba Linux <oradba_linux_at_attbi.com>
Date: Wed, 04 Jun 2003 02:28:21 GMT
Message-ID: <pan.2003.06.04.02.29.50.707700@attbi.com>

On Tue, 03 Jun 2003 21:07:58 +0000, Vince Laurent 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

Why are you running that query ?
What about the number of objects in the database ? Are you using locally managed or dictionary managed tablespaces ? Received on Tue Jun 03 2003 - 21:28:21 CDT