Character sets can be changed
after installation only if the new character set is a superset of the existing character set.
Decide on the best default database block size. The default block size defined by DB_
BLOCK_SIZE cannot be changed later without reinstalling the database. Although this
decision is not critical to future expansion of the database because Oracle can support
?–
?–
?–
?–
?–
I
Appendix: Installation and Configuration 637
tablespaces with multiple block sizes, having an incorrectly sized default block size can
reduce the performance of operations using the SYSTEM, TEMP, or SYSAUX tablespaces.
Make sure that all non-administrative users are assigned a non-SYSTEM tablespace as
their default tablespace. No user objects should ever be stored in the SYSTEM tablespace.
This recommendation is easy to implement using Oracle??™s default permanent tablespace
and default temporary tablespace settings.
Automatic Undo Management is a must to ease the administration of transaction undo
information. The extra space needed in the undo tablespace is well worth the investment
in productivity for both the DBA and users.
Plan a backup and recovery strategy. Decide how often the database needs to be backed
up; use more than one method to back up the database. One of the key questions to ask
when selecting a backup strategy is, How long can we afford to have our database down?
If the database only processes batch jobs at night, then a full backup every week and
daily incremental backups are probably fine.
Pages:
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940