Re: select statement uses 100% CPU

1. I was told to by SAP in order to test something for SAP support
2. 24719
3. Dictionary managed.

These are the same on both systems.

On Wed, 04 Jun 2003 02:28:21 GMT, "Oradba Linux" <oradba_linux_at_attbi.com> wrote:

>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 - 22:07:39 CDT