Oracle Database Administration for Microsoft SQL Server DBAs part 11 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 82 Oracle Database Administration for Microsoft SQL Server DBAs The flash recovery area is a valuable location for being able to flashback the database. The sizing of this area may need to change based on the size of the transactions and database but it is a dynamic change that can be made as needed. The key to sizing this area is to have the disk space available. This will be the area where the backup files can be stored and based on retention should be estimated appropriately. You can also remove databases with the DBCA. The Delete a Database option see Figure 4-2 takes care of removing the services and datafiles. CAUTION Even though the DBCA will ask Are you sure when you choose to delete a database without a backup of the database the only parts that can be re-created are the structures. So what is created with the database The redo logs and log groups SYSTEM tablespace SYSAUX tablespace temporary tablespace undo tablespace and control files will be created. The and construct the data dictionary with the views tables and stored procedures. SYS SYSTEM and a couple more users are added as well. The job scheduler is set up with background processes because it is the default setting for parameters to have job slave processes. The parameter JOB_QUEUE_PROCESSES in Oracle Database 11 g has a default of 1000 and the job coordinator starts only as many processes as requested. Database Templates model Database Are the Oracle templates really like SQL Server s model database The templates are the basic building blocks for the database creation. They have defaults for the files parameters and some basic configuration. In that respect they have the same kind of information that is stored in the model database. However only one database is created for an Oracle server there is no need for templates to be used over and over again to create the databases as the model database is used in SQL Server. Chapter 4 Database Definitions and Setup 83 Duplicating
