Re: Star Transformation Issue
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 22 Oct 2015 23:28:05 +0300
Message-ID: <CAOVevU63W8AdXhAq70R6RSYxL1=t_3B54rxahqBUGKZHRjKoFQ_at_mail.gmail.com>
Could you show the value of "QUERY_REWRITE_INTEGRITY" parameter? You have to set it to TRUSTED or STALE_TOLERATED: https://docs.oracle.com/cd/E11882_01/server.112/e25554/qrbasic.htm#DWHSG01821
Date: Thu, 22 Oct 2015 23:28:05 +0300
Message-ID: <CAOVevU63W8AdXhAq70R6RSYxL1=t_3B54rxahqBUGKZHRjKoFQ_at_mail.gmail.com>
Could you show the value of "QUERY_REWRITE_INTEGRITY" parameter? You have to set it to TRUSTED or STALE_TOLERATED: https://docs.oracle.com/cd/E11882_01/server.112/e25554/qrbasic.htm#DWHSG01821
--
Best regards,
Sayan Malakshinov
Oracle ACE Associate
Lead performance tuning engineer
PSBank
http://orasql.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 22 2015 - 22:28:05 CEST