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 -> Full Import Strategy and SGA sizing

Full Import Strategy and SGA sizing

From: John Vernes <vernes.j_at_consunet.nl>
Date: Mon, 15 Mar 1999 22:35:42 +0100
Message-ID: <7cjudt$5us$1@news.worldonline.nl> 





Hello,



I will be doing a full import of a database soon and have a question
regarding the sizing of the SGA (db_block_buffers and shared_pool).
Will a Full Import be faster if the SGA is very small and the other
memory is free to the system itself?


The buffers and shared pool are not necesarry until the Full Import is
done!! Right??


I hope there is someone out there who tested this allready or can clearify
it in some way.



Thanks in advance



-John



Received on Mon Mar 15 1999 - 15:35:42 CST












Original text of this message













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