RE: select on SYS CPU 100%
- From: "Kumar, Arvind IN GGN SISL" <arvind.kumar2@xxxxxxxxxxx>
- To: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- Date: Thu, 8 Feb 2007 12:18:39 +0530
Thanks, Gopal
I added /*+ Rule */ hint, after that its working perfectly.
Kind Regards
Arvind Kumar
-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]
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@xxxxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
