Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE
From: The Boss <usenet_at_No.Spam.Please.invalid>
Date: Tue, 4 Dec 2007 22:47:45 +0100
Message-ID: <4755cb02$0$226$e4fe514c@news.xs4all.nl>
>> On Dec 4, 2:49 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>>
>>
>>
>>
>>
>>> 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
>>> ).
>>
>> I just spent about 20 minutes trying to sift through the blog, ( it
>> is
>> hell trying to find anything on a blog unless you know the
>> approximate
>> timeline ) and did a google search for cdos ( which just gets me debt
>> consolidation sites ). anyway I could get a link or unabreviated
>> name?- Hide quoted text -
>>
>> - Show quoted text -
Date: Tue, 4 Dec 2007 22:47:45 +0100
Message-ID: <4755cb02$0$226$e4fe514c@news.xs4all.nl>
Ben wrote:
> On Dec 4, 4:00 pm, Ben <benal..._at_yahoo.com> wrote:
>> On Dec 4, 2:49 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>>
>>
>>
>>
>>
>>> 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
>>> ).
>>
>> I just spent about 20 minutes trying to sift through the blog, ( it
>> is
>> hell trying to find anything on a blog unless you know the
>> approximate
>> timeline ) and did a google search for cdos ( which just gets me debt
>> consolidation sites ). anyway I could get a link or unabreviated
>> name?- Hide quoted text -
>>
>> - Show quoted text -
> > Sorry, I meant to *ask* if * I could * get a link. working on 4 hours > sleep and a sinus infection that is making me quite groggy.
Search this groups' archive for a thread called "here's a good one from dizwell on the recent product launch" and have a look at Noons post of July 20th.
-- JeroenReceived on Tue Dec 04 2007 - 15:47:45 CST