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.KLIER ATU.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
------------------------------------------------------------
------
|