List Info

Thread: OPTIMIZER_SECURE_VIEW_MERGING




OPTIMIZER_SECURE_VIEW_MERGING
user name
2007-08-30 02:31:17
HI DBA'S,

DOES SOMEBODY KNOW WHAT 10GR2 INIT PARAMETER
"OPTIMIZER_SECURE_VIEW_MERGING" 
DOES IN DETAIL? ORACLE DOCUMENTATION SAYS "ALLOWS YOU
TO ENABLE OR DISABLE 
VIEW MERGING GLOBALLY FOR THE DATABASE" WHAT I DO NOT
CONSIDER AS VERY 
INFORMATIVE. 

I AM CONCERNED ABOUT THIS SENTENCE: "TO TAKE ADVANTAGE
OF QUERY REWRITE FOR A 
PARTICULAR QUERY, YOU MUST DISABLE THE
OPTIMIZER_SECURE_VIEW_MERGING 
PARAMETER."
DOES THAT MEAN I HAVE TO SET
OPTIMIZER_SECURE_VIEW_MERGING=FALSE TO USE QUERY 
REWRITING AT ALL?

THANKS IN ADVANCE AND BEST REGARDS
-- 
FREUNDLICHE GRüßE

I.A.
MARTIN KLIER
SYSTEMADMINISTRATION/DATENBANKEN
------------------------------------------------------------
------
A.T.U AUTO-TEILE-UNGER
HANDELS GMBH & CO. KG
DR.-KILIAN-STR. 4 
92637 WEIDEN I.D. OPF.

TEL.: +49 961 306-5663
FAX : +49 961 306-5982

MARTIN.KLIERATU.DE
WWW.ATU.EU

SITZ: WEIDEN I. D. OPF., AMTSGERICHT WEIDEN I. D. OPF., HRA
2012
UST-ID NR. DE814195392, WEEE-NR. DE53789710
PERSöNLICH HAFTENDE GESELLSCHAFTERIN:
AFM AUTOFAHRERFACHMARKT GESCHäFTSFüHRUNGS GMBH
SITZ: WEIDEN I. D. OPF., AMTSGERICHT WEIDEN I. D. OPF., HRB
2842
GESCHäFTSFüHRER: KARSTEN ENGEL, DIRK MüLLER, MANFRED RIES
------------------------------------------------------------
------
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )