Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE

Re: Deadly OPTIMIZER_SECURE_VIEW_MERGING=TRUE

From: csn <csn233_at_gmail.com>
Date: Sun, 2 Dec 2007 04:40:20 -0800 (PST)
Message-ID: <f9e0a679-02e0-40e0-94b7-d13fe6bff14e@s12g2000prg.googlegroups.com> 






> After some investigation I found that just setting the following

> parameter resulted in a huge (about 100-fold) performance increase:

> OPTIMIZER_SECURE_VIEW_MERGING=FALSE



If I can improve performance 100-fold, I wouldn't worry about other
things too much but go to the manager and ask for a pay raise instead.
Received on Sun Dec 02 2007 - 06:40:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US