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 -> ... value-recommendations for a very large SGA and else?

... value-recommendations for a very large SGA and else?

From: Ralf Schneider <soraya_at_berlin.snafu.de>
Date: Sun, 16 Aug 1998 20:22:14 +0200
Message-ID: <6r78j1$skr$1@unlisys.unlisys.net> 





Ja aber Hallo!



How have I to use the init<sid>.ora parameter "db_block_size"; permanent or
only at the "create db" time?


Further, could somebody recommend values for a very large SGA? (around about
150MB)


sort_area_size = ?


sort_area_retained_size = ?


db_block_buffers = ?


shared_pool_size = ?


log_buffer = ?


... and maybe for dependent parameters too!



Many Thanks


Ralle


Received on Sun Aug 16 1998 - 13:22:14 CDT












Original text of this message













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