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: Improving performance on global temp tables

Re: Improving performance on global temp tables

From: <bdbafh_at_gmail.com>
Date: 8 Mar 2006 09:05:14 -0800
Message-ID: <1141837514.577021.104970@i40g2000cwc.googlegroups.com> 





Database server software version info would be most relevant here (it
usually is).



Check out the init.ora parameter "dynamic_sampling".
Set it to at least a value of 2 for global temporary tables to be
sampled at runtime.



-bdbafh
Received on Wed Mar 08 2006 - 11:05:14 CST












Original text of this message













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