RE: select on SYS CPU 100%

Thanks, Gopal

        
      I added /*+ Rule */ hint, after that its working perfectly.

Kind Regards

Arvind Kumar

-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal_at_gmail.com] Sent: Thursday, February 08, 2007 11:52 AM To: Kumar, Arvind IN GGN SISL
Cc: Oracle-l
Subject: Re: select on SYS CPU 100%

Arvind,

IIRC this is a known bug. Just go back to 9i view definition or change the all_objects view definition with /*+RULE */ hint.

-Gopal

On 2/5/07, Kumar, Arvind IN GGN SISL <arvind.kumar2_at_siemens.com> wrote:
>
>
>
> Hi all,
>
>
>
>
>
> ## Test Env.
>
> ## MS Windows
>
> ## Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
Prod
>
> PL/SQL Release 10.2.0.1.0 - Production
>
> CORE 10.2.0.1.0 Production
>
> TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
>
> NLSRTL Version 10.2.0.1.0 - Production
>
>
>
>
>
> select distinct owner from sys.all_objects; consume 100%
CPU,hanging.
>
>
>
> If I run with Rule ,it returns the rows.
>
>
>
> Statistics is there on SYS tables.
>
>
>
> Explain plan show HASH JOIN between sys.user$ and sys.obj$ if it
runs
> without Rule hint.
>
>
>
>
>
>
>
>
>
>
> Kind Regards
>
> Arvind Kumar

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l