What are the minimum parameters should exist in the parameter file (init.ora)?
Submitted by: AdministratorDB NAME - Must set to a text string of no more than 8
characters and it will be stored inside the datafiles,
redo log files and control files and control file while
database creation.
DB_DOMAIN - It is string that specifies the network
domain where the database is created. The global
database name is identified by setting these parameters
(DB_NAME & DB_DOMAIN)
CONTORL FILES - List of control filenames of the database.
If name is not mentioned then default name will be used.
DB_BLOCK_BUFFERS - To determine the no of buffers in the
buffer cache in SGA.
PROCESSES - To determine number of operating system
processes that can be connected to ORACLE concurrently.
The value should be 5 (background process) and
additional 1 for each user.
ROLLBACK_SEGMENTS - List of rollback segments an ORACLE
instance acquires at database startup.
Also optionally
LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and
LICENSE_MAX_USERS.
Submitted by: Administrator
characters and it will be stored inside the datafiles,
redo log files and control files and control file while
database creation.
DB_DOMAIN - It is string that specifies the network
domain where the database is created. The global
database name is identified by setting these parameters
(DB_NAME & DB_DOMAIN)
CONTORL FILES - List of control filenames of the database.
If name is not mentioned then default name will be used.
DB_BLOCK_BUFFERS - To determine the no of buffers in the
buffer cache in SGA.
PROCESSES - To determine number of operating system
processes that can be connected to ORACLE concurrently.
The value should be 5 (background process) and
additional 1 for each user.
ROLLBACK_SEGMENTS - List of rollback segments an ORACLE
instance acquires at database startup.
Also optionally
LICENSE_MAX_SESSIONS,LICENSE_SESSION_WARNING and
LICENSE_MAX_USERS.
Submitted by: Administrator
Read Online Oracle Security Job Interview Questions And Answers
Top Oracle Security Questions
☺ | What is snapshots? |
☺ | How to specify the Archived log file name format and destination? |
☺ | Explain What are the dictionary tables used to monitor a database spaces? |
☺ | How to prevent unauthorized use of privileges granted to a Role? |
☺ | Explain snapshot log? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |