Yes, I did infact use the same dbms_utility to analyze schema.
execute dbms_utility.analyze_schema('OWNER', 'COMPUTE');
But my problem is even after I ran that
select * from v$parameter where name = 'optimizer_mode'
still shows choose !
How do I know now that it is using cost based optimizer ?
thanks




Reply With Quote