RE: optimizer_secure_view_merging

Todd

> We are using materialized views with refreash on
> commit (don't ask...) on 10.2.0.2.

There is no problem at all about that if correctly set up.

> We have some performance problems and I have been
> researching optimizer_secure_view_merging, to
> reduce the CPU load of parsing and executing
> statements against the views based on the materialized
> views.

Some questions...

Which kind of performance problems?
Do you really have very high parse time? Do you use query rewrite?

In any case optimizer_secure_view_merging should have an impact only during parse.

> Has anyone set this parameter to false in a production
> system? If so, what were the results?

I had to disable it only due to a bug (I don't remember which one, see Metalink for more information...). It was not due to performance.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l