Reference no: EM13830799

Discussion 1

Respond to the following in 100 words or less.  Work must be cited.

When I was reading on spfile and init.ora, I read that since init.ora is a static, plain text file it is only read at database startup, any changes to it will not be read until the database is restarted.  This was why in Oracle 9i, the spfile was developed, since the spfile can be edited by the DBA instead of using ALTER SYSTEM the parameter changes can be persistent across database restarts.

Respond to the following in 100 words or less.  Work must be cited.

Discussion 2

I do remember reading about Oracle Managed Files in our text. According to Kuhns (2013), "The Oracle Managed File (OMF) feature automates many aspects of tablespace management, such as file placement, naming, and sizing." This makes creating tablespaces much easier as a statement like CREATE TABLESPACE tablename automatically takes care of the physical aspects of creating the tablespace such as the placement of data files, online redo log files, and control files. The location of these files are specified at initializing via the following parameters:

DB_CREATE_FILE_DEST

DB_CREATE_ONLINE_LOG_DEST_N

DB_RECOVERY_FILE_DEST

There are limitations to OMF though. For instance, you are only allowed to specify one directory for the placement of data files. In order to add another directory for data files, you must alter it dynamically with a statement like:

alter system set db_create_file_dest='/u02';

Discussion 3 Respond to the following in 100 words or less.  Work must be cited.

What are the advantages and disadvantages on all the methods available for creating a databaseg a database manually other than it's more complex than using the DBCA tool. Looking through