Database Reference
In-Depth Information
filename, Oracle creates a file with a default operating system
dependent name e.g.,
CONTROL_FILES = (d:\oracle\databases\ora10\control01.ora,
d:\oracle\databases\ora10\control02.ora,
d:\oracle\databases\ora10\control03.ora)
UNDO_MANGEMENT
You can control undo management to be manual (MANUAL) or
automatic (AUTO). Its recommended to set this parameter to
AUTO in Oracle9i and Oracle 10g e.g.,
UNDO_MANAGEMENT=auto
UNDO_TABLESPACE
A default tablespace with the name SYS_UNDOTBS will get
created automatically when you execute the CREATE
DATABASE statement if you have set
UNDO_MANGEMENT=auto and no undo tablespace in the
CREATE DATABASE statement. Oracle used this tablespace to
store its undo information.
DB_BLOCK_SIZE
DB Block is the smallest building block of a database. This
should be set to even multiple of OS block size to get high
performance. Take care when determining its value as you
cannot change it after the creation of database e.g.,
DB_BLOCK_SIZE=8192
Where 8192 represents bytes. The size of Database buffer cache
is determined if we multiply DB_BLOCK_BUFFERS with
DB_BLOCK_SIZE. Where DB_BLOCK_BUFFERS are the
number of buffers in the database buffer cache of SGA (System
Global Area).
Search WWH ::
Custom Search