Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: select statement uses 100% CPU
> select * from dba_extents
Hi,
Oracle used a /*+ ordered */ hint in the view def. This calls CBO.
Try your select with a /*+ rule */ hint.
Oracle supplies a new view dba_extents without the hint as a workaround.
Regards
Stephan
Received on Wed Jun 04 2003 - 01:37:04 CDT
![]() |
![]() |