Question: I understand that Oracle is
governed by parameters, but I need to know the location of
the Oracle parameters and the details on the parameters that
determine the configuration of Oracle.
Answer: There are
hundreds of Oracle parameters that govern the Oracle
instance, and data dictionary, Oracle objects (table and
index parameters) storage parameters and parameter for the
listener the SQL*Net files.
Oracle*Net connections
between servers can be tuned using several parameters. Keep
in mind, though, that network tuning is outside the scope of
Oracle, and a qualified network administrator should be
consulted for tuning the network. The frequency and size of
packet shipping across the network can be affected by using
settings contained in the following parameter files:
- protocol.ora
file—tcp.nodelay
- sqlnet.ora
server file—automatic_ipc
- sqlnet.ora
client file—break_poll_skip
- tnsnames.ora
file—SDU, TDU
- listener.ora
file—SDU, TDU, and
queuesize
Oracle initialization parameter file
When the Oracle database is started,
one of the first things it needs to do is read the database
initialization parameter file. The parameter file (init.ora
or spfile) is created by the DBA and defines the overall
instance configuration, such as how much memory should be
allocated to the instance, the file locations, and internal
optimization parameters.
OS parameters for Oracle
There are many OS kernel parameter
that are set for
the OS environment for Oracle.
Oracle network parameters
There are
dozens of
SQL*Net parameters that manage the communications
between Oracle and the external environment (disks, network,
TCP/IP, &c). Also see the
listener.ora parameters for managing connections to
Oracle.
Also see:
