OPTIMIZER_SECURE_VIEW_MERGING
Martin Klier <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Organization | A.T.U Auto-Teile-Unger Serveradministration |
| Message-ID | <[email protected]> |
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 [email protected] 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 ------------------------------------------------------------------
signature.asc
(application/pgp-signature, 189 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQBG1nJJVKZfihvnEcQRAosXAKC4s8HYUGudDbD4mDGRRQPfwJvy/gCePulZ TrhZrY1YyQ6aCevT6kgODXE= =2S// -----END PGP SIGNATURE-----