Re: Problems with Views?

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: Tue, 20 Aug 2002 07:19:34 GMT
Message-ID: <ajsqkp$qme$1@news1.xs4all.nl>

Vince wrote:

>Could you further explain what you meant by:
>Before 9.2, one can see this (cumbersome!) with event 10060 set.
>

Event 10060 shows you the predicate dump. You could try this with:

create table kkoipt_table
( c1 integer
, c2 varchar2(80)
)
/

alter session set optimizer_goal = all_rows /* only work with CBO */ /

select *
from all_objects /* UNIQUE001, 10060 only works with a hard parse */ where object_id = 8621
/

set linesize 100

select *
from kkoipt_table
/

Kind Regards,

Herman de Boer
sr consultant
IT Consultancy Group bv Received on Tue Aug 20 2002 - 02:19:34 CDT