From com.banilejas@codetel.net.do Fri, 21 Sep 2001 07:39:48 -0700 From: "Ramon Estevez" Date: Fri, 21 Sep 2001 07:39:48 -0700 Subject: Installing 8.1.7 Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi folks,   Actually I have 8.0.5 and  will install 8.1.7 in the weekend, and would like to have somethings clear.   Actually I have just 2 tablespaces, but planning to make one for each application system, will be like 7.   Of course will make all kind of backups, cold, hot including redo logs, password files, parameter files and archives.   What I am planning to do is make an export of the user owner of the all objects and make and import in the new DB.     1) How to find the ideal size of the extent for a locally managed      tablespace uniform size ?    2) As far as I know, not much, the import will create the same tablespaces where the      objects exists in the old DB in the new DB.  Now, if I use an alter table move        tablespace to move the tables to the new LMT tablespace, will it use the extent      size of the new TBS or will remain with the old one ?    3) I'm considering to recreate all the indexes.    4) Is it a good idea to have an TBS for each APP system ?    5) What are the consequences of having all of them with different extent size ?    6) If by any chance some of them are going to have the same extent size     wouldn't be better to put them in one TBS ?       6) Any tips for sizing of the SGA, shared pool, log_buffers, sort_area_size ?    7) Planning make db_block_size 8k    8) My second step will be implement Forms Server, anything to include in the      installation of have in mind from now ?   My DB is transactional, not that heavily, like 40 users, but like 12 of them are remote.   Hardware Compaq 2 Pentium III processor 800 mhz 6 Hard Drive 9.1 GB - raid 5 1 GB Memory Win 2000 server     Thanks in advance and sure that your help will be very, very useful.       Ramon E. Estevez com.banilejas@codetel.net.do Dominican Republic 809-565-3121