Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE

On Dec 4, 2:29 pm, Ben <benal..._at_yahoo.com> wrote:
> >if you don't have multiple schemas then it's fine.
> >If you do, then watch out for tables with the
> >same name in different schemas and auto sga:
> >deadly combination!
>
> Ok, you got my attention! Please give me a link to more information on
> this. Of course I'm using auto sga and we have about 6 schemas in our
> database that have tables named the same. I haven't seen any *gulp,
> knock on wood* updating of tables in wrong schemas. Is it only related
> to certain types of tables?

Nuno has talked a lot about this both on cdos and in his blog ... not hard to find those is it?

As I remember it the problems start popping up under load and when the "owner.table_name" or "owner.view_name" isn't completely specified ( ie the "owner." part ommitted ).

Maybe I don't have a good understanding of it though so check out what Nuno has written ( isn't it dbas-r-us for his blog or similar ). Received on Tue Dec 04 2007 - 13:49:57 CST