It is recommended that you leave archiving off until the database is
installed, because this will increase the database creation time. The parameters for ARCHIVELOG
mode can easily be changed after the database is up and running; see Chapter 11 for details on
configuring the archive log destination and enabling ARCHIVELOG mode.
Database Components
In step 10 of the DBCA session, you are asked about installing sample schemas. It is highly
recommended that you install the sample schemas for testing purposes; many tutorials and study
guides (as well as this book!) rely on the sample schemas being in a test database. They are also
useful in that the samples demonstrate nearly all datatypes and constructs available in the
database, ranging from bitmapped indexes to clustered tables and object types. The window
shown in Figure A-8 allows you to specify the installation of the sample schemas. The second
tab on this window gives you the option to specify other scripts that you need to run against this
database once it is created, such as scripts to create tablespaces for existing applications, special
user accounts, and so forth.
NOTE
Sample schemas should not be installed in a production database for
security and performance reasons.
If you choose to not install the sample schemas at this time, they can be created using the
scripts in the directory $ORACLE_HOME/demo/schema after the database has been created.
FIGURE A-8 Selecting a sample schema installation
646 Oracle Database 11g DBA Handbook
Initialization Parameters
The tabs in Figure A-9 allow you to adjust the key initialization parameters for the database.
Pages:
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950