select on SYS CPU 100%

From: "Kumar, Arvind IN GGN SISL" <arvind.kumar2@xxxxxxxxxxx>
To: "Oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 6 Feb 2007 10:15:56 +0530

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

Follow-Ups:
- Re: select on SYS CPU 100%
  - From: K Gopalakrishnan

References:
- 10053 Trace and OBJ$ (DBA_SEGMENTS)
  - From: Anand Rao
- Re: 10053 Trace and OBJ$ (DBA_SEGMENTS)
  - From: Anand Rao
- Re: 10053 Trace and OBJ$ (DBA_SEGMENTS)
  - From: Ghassan Salem
- Re: 10053 Trace and OBJ$ (DBA_SEGMENTS)
  - From: Anand Rao

select on SYS CPU 100%

Other related posts: