Oracle DBCA templates for database creation Oracle Database Tips by Donald Burleson

The database creation assistant (DBCA) is an assistant that is designed for beginners who do not understand the details for instance optimization.  The DBCA templates are only starting points and you will adjust your instance based on your specific processing needs.

For details on optimizing your initialization parameters for specific "types" of Oracle instances, see my masterwork book "Oracle Tuning: The Definitive Reference".  You can save 30% by getting it directly from the publisher and you also get instance access to the code depot of diagnostic scripts.

There are three templates, general purpose, OLTP and data warehouse, and the parameter setting are the most important differences in these DBCA templates.  Let's compare the settings, and see how these parameter values are only starting points, and sub-optimal because they have not been adjusted for your specific workload:

As we see, the DBCA only provides general starting point parameter settings, and these parameter values are guaranteed to be sub-optimal.  To be through, as soon as you are ready to go into production, you need to conduct a full Oracle health check and re-set the parameters to suit your specific processing needs.