RE: Star Transformation Issue
Date: Thu, 22 Oct 2015 20:29:36 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF1B60F40A_at_NC2PWEX501.us.ad.lfg.com>
Sayan,
Thanks for the quick response, it is set to TRUSTED:
SQL> show parameter QUERY_REWRITE_INTEGRITY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
query_rewrite_integrity string TRUSTED
Thanks,
Scott
From: Sayan Malakshinov [mailto:xt.and.r_at_gmail.com]
Sent: Thursday, October 22, 2015 4:28 PM
To: Deas, Scott
Cc: oracle-l_at_freelists.org
Subject: Re: Star Transformation Issue
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
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 22 2015 - 22:29:36 CEST