--Course ID: CS540 (B) --Student ID: 16020 --Student Name: Jaydutt Pathak --Homework#: 03
ANSWER 1: We can define the Oracle initialization parameter files in two ways as Explicit and implicit. •Explicit : Having an entry in the file •Implicit : No entry within the file, but assuming the Oracle default values Multiple files can be used for a single database to optimize performance in different situations. Changes to entries in the file take effect based on the type of initialization parameter file used; •Static parameter file, PFILE •Persistent parameter file, SPFILE ANSWER 2: The PFILE is a text file that can be modified with an operating system editor and modification to the file are made manually that changes to the file and take effect on the next startup. The default location for the PFILE is $ORACLLE_HOME/dbs. ANSWER 3: spfileSID.ora is a binary file with the ability to make changes persistent across shutdown and startup and maintained by the Oracle server. However records parameter value changes made with the ALTER SYSTEM command that can be specify whether the change being made is temporary or persistent. Values can be deleted or reset to allow an instance to revert to the default value. To reset the instance : ALTER SYSTEM SET undo_tablespace = ‘UNDO2’;ANSWER 4: The SPFILE can be created from an initSID.ora file using the CREATE SPFILE command, which can be executed before after instance startup: CREATE SPFILE FROM PFILE;
ANSWER 5: OMF are created and deleted by the Oracle server as directed by SQL commands.Using Oracle Managed Files simplifies the administration of an Oracle Database. Oracle Managed files eliminate the need for you, The DBA, to directly manage the Operating system files that comprise an Oracle Database. With Oracle Managed Files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's data file
You've reached the end of your free preview.
Want to read all 7 pages?
- Spring '18
- Oracle Database, shutdown command, database shutdown proceeds