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: Correlation? init.ora: db_files and controlfile: maxdatafiles

Re: Correlation? init.ora: db_files and controlfile: maxdatafiles

From: K Gopalakrishnan <oradebug_at_vsnl.com>
Date: Fri, 19 Oct 2001 04:07:55 -0700
Message-ID: <9qnlm5$al6@hu5.hofstra.edu> 





That parameter was a tuning parameter in earlier  versions oracle.



THe DBWR internal write batch size was a function



 of db files and increasing that will artificially inflate the



 write batch size and it will impact the peformance negatively.



 Starting from Oracle 8 this is nomore a tuning paramter. You



 can safely set to higher values than require
Received on Fri Oct 19 2001 - 06:07:55 CDT












Original text of this message













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