Re: CBC latch contention on index root block
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Sun, 20 Jan 2013 11:26:56 +0400
Message-ID: <CAOVevU7ieuRcaH2cBkO3PCmJVrbePG23CvfnH7Vg61Wb=Gd-Eg_at_mail.gmail.com>
> if i use NOT EXISTS then it's not returning any rows for the 2nd part.
>
> AND NOT exists(SELECT ABS_PGM_ID FROM F0324DB.TAMRABS_PGM where
> cust_num=112805 and ABS_TYP_ID='COFM')
> 4 rows selected.
>
Date: Sun, 20 Jan 2013 11:26:56 +0400
Message-ID: <CAOVevU7ieuRcaH2cBkO3PCmJVrbePG23CvfnH7Vg61Wb=Gd-Eg_at_mail.gmail.com>
> if i use NOT EXISTS then it's not returning any rows for the 2nd part.
>
> AND NOT exists(SELECT ABS_PGM_ID FROM F0324DB.TAMRABS_PGM where
> cust_num=112805 and ABS_TYP_ID='COFM')
> 4 rows selected.
>
You miss one predicate, it must be:
AND NOT exists(SELECT null FROM F0324DB.TAMRABS_PGM P2 where
cust_num=112805 and ABS_TYP_ID='COFM'
and TAMRABS_PGM.ABS_PGM_ID = P2.ABS_PGM_ID)
-- Best regards, Sayan Malakshinov Senior performance tuning engineer -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 20 2013 - 08:26:56 CET