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 -> key init parameters for oracle 9i

key init parameters for oracle 9i

From: DM <dil_maj_at_yahoo.com>
Date: 2 May 2003 19:51:39 -0700
Message-ID: <a4042ab1.0305021851.53479a4c@posting.google.com> 





I need help in getting the list of init parameters I should be most
concerned, and suggested value if possible - for our new database in
oracle 9i r2 using cost based optimizer. It's a 200 tables db with
expected 20 small transaction/per min. oltp system
I read db_block_size for such system be 4k.
what other paramters should be set?



please guide.


Thanks 


Dilip
Received on Fri May 02 2003 - 21:51:39 CDT












Original text of this message













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