What are the minimum parameters should exist in the
parameter file (init.ora) ?
Answer / guest
DB 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
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.
|Is This Answer Correct ?||3 Yes||0 No|
What is snapshots ?
what is meant by physical order and logical order in clustered index and non clustered index.
What are the minimum parameters should exist in the parameter file (init.ora) ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the benefits of distributed options in databases ?
What are the system resources that can be controlled through Profile ?
What is Tablespace Quota ?
What is the use of ANALYZE command ?
What are the various type of snapshots ?
What are Roles ?
When will the data in the snapshot log be used ?
What dynamic data replication ?