In many cases, the predefined templates that Oracle
provides are not quite perfect for your environment, and it is a timesaver to be able to
save your database options for selection as a template in a future DBCA session.
Configure Automatic Storage Management? You can use this option to create, modify,
or delete disk groups in an ASM instance for an existing or soon to be installed database.
Selecting a Database Template
In Figure A-1, you are presented with the list of templates available. If you have created your own
templates in previous DBCA sessions, they will appear on this window also.
?–
?–
?–
?–
FIGURE A-1 Database template selection
640 Oracle Database 11g DBA Handbook
The template choices are as follows:
Custom Database Use this option if you have performed many installations and know
ahead of time the values for all the options you need in the database. This option is good
if you are creating a new template from scratch or have very specific requirements for the
configuration of your database.
Data Warehouse This template is for database environments where users are
performing numerous, complex queries that join many large tables for reporting,
forecasting, and analytics.
General Purpose or Transaction Processing In 24/7 environments where the number of
users is high, the transactions are heavy, but short, and the bulk of the activity is creating
and updating, use this template. This template is also appropriate for a general-purpose
database, such as for development or testing.
Pages:
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945