Dynamic

Table 2-2: Dynamic configuration parameters

Configuration parameter

Configuration parameter

addition network memory

number of pre-allocated extents

audit queue size

number of user connections

cpu grace time

number of worker processes

deadlock pipe max messages

open index hash spinlock ratio

default database size

open index spinlock ratio

default fill factor percent

open object spinlock ratio

disk i/o structures

partition groups

errorlog pipe max messages

partition spinlock ratio

max cis remore connections

permission cache entries

memory per worker process

plan text pipe max messages

number of alarms

print recovery information

number of aux scan descriptors

process wait events

number of devices

size of global fixed heap

number of dtx participants

size of process object heap

number of java sockets

size of shared class heap

number of large i/o buffers

size of unilib cache

number of locks

sql text pipe max messages

number of mailboxes

statement pipe max messages

number of messages

tape retention in days

number of open databases

time slice

number of open indexes

user log cache spinlock ratio

number of open objects