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
Dominican Republic
809-565-3121