Installing 8.1.7

Hi
folks,
<SPAN

class=892350015-21092001> 

Actually I have 8.0.5 and  will
install 8.1.7 in the weekend, and would like to have something<SPAN class=892350015-21092001>s clear.
<SPAN

class=892350015-21092001> 
Actually I have just 2
tablespaces, but planning to make one for each application system,
will be like
7.
<SPAN

class=892350015-21092001> 
Of course will make <SPAN
class=892350015-21092001>all kind of backups, cold, hot including redo logs, password files, parameter files and archives.
<SPAN

class=892350015-21092001> 
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.  <SPAN
class=892350015-21092001>
 

 1) How to find the
ideal size of the extent for a locally managed     
tablespace uniform size ?
<SPAN

class=892350015-21092001> 
 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 <FONT face=Verdana>tablespace, will it use the extent

    
size of the new TBS or will remain with the old one ?
<SPAN

class=892350015-21092001> 
 3) I'm considering
to recreate all the indexes.
<SPAN

class=892350015-21092001> 
 4) Is it a good
idea to have an TBS for each APP system ?
<SPAN

class=892350015-21092001> 
 5) What are the
consequences of having all of them with different extent size ?
<SPAN

class=892350015-21092001> 
 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 ?
<SPAN

class=892350015-21092001> 
 7) Planning make
db_block_size 8k
<SPAN

class=892350015-21092001> 

 8) My second step
will be implement Forms Server, anything to include in the     
installation of have in mind from now ?
<SPAN

class=892350015-21092001> 
My DB is transactional,
not that heavily, like 40 users, but like 12 of them are remote.
<SPAN

class=892350015-21092001> 
<SPAN

class=892350015-21092001>Hardware
Compaq

2 Pentium III processor
800 mhz
6 Hard Drive 9.1 GB -
raid 5
1 GB
Memory
Win 2000
server
<SPAN

class=892350015-21092001> 
<SPAN

class=892350015-21092001> 
Thanks in advance and
sure that your help will be very, very useful.
<SPAN

class=892350015-21092001> 
<SPAN

class=892350015-21092001> 
 
Ramon E.
Estevez
<A

href="mailto:com.banilejas_at_codetel.net.do">com.banilejas_at_codetel.net.do Dominican Republic
809-565-3121
  Received on Fri Sep 21 2001 - 09:39:48 CDT