| Previous | Table of Contents | Next |
The init.ora file and the config.ora file not only determine the overall size of the SGA, but also determine which Oracle constructs get a specified amount of memory. init.ora parameters rank in the dozens. To see all of the init.ora parameters, enter SQL*DBA and issue this command:
SQLDBA> show parameters
The results are shown in Listing 3.1.
Listing 3.1 The results of the show parameters command.
NAME TYPE VALUE
------------------------- ------ ------
async_read boolean TRUE
async_write boolean TRUE
audit_file_dest string /opt/oracle/admin/my_sid/
audit
audit_trail string TRUE
background_core_dump string full
background_dump_dest string /opt/oracle/admin/my_sid/
bdump
blank_trimming boolean FALSE
cache_size_threshold integer 40
ccf_io_size integer 134217728
checkpoint_process boolean FALSE
cleanup_rollback_entries integer 20
close_cached_open_cursors boolean FALSE
commit_point_strength integer 1
compatibl string
compatible_no_recovery string
control_files string /Datadisks/d09/ORACLE/mysid/
control1.dbf,
/Datadisks/d10/ORACLE/my_sid/
control2.dbf,
/Datadisks/d01/ORACLE/mysid/
control3.dbf
core_dump_dest string /opt/oracle/admin/mysid/cdump
cursor_space_for_time boolean FALSE
db_block_buffers integer 400
db_block_checkpoint_batch integer 8
db_block_lru_extended_ integer 0
statistics
db_block_lru_statistics boolean FALSE
db_block_size integer 4096
db_domain string WORLD
db_file_multiblock_read_ integer 16
count
db_file_simultaneous_writes integer 4
db_files integer 30
db_name string my_sid
db_writers integer 1
dblink_encrypt_login boolean FALSE
discrete_transactions_ boolean FALSE
enabled
distributed_lock_timeout integer 60
distributed_recovery_ integer 200
connection_hol
distributed_transactions integer 19
dml_locks integer 100
enqueue_resources integer 177
event string
fixed_date string
gc_db_locks integer 400
gc_files_to_locks string
gc_lck_procs integer 1
gc_rollback_locks integer 20
gc_rollback_segments integer 20
gc_save_rollback_locks integer 20
gc_segments integer 10
gc_tablespaces integer 5
global_names boolean FALSE
ifile file /opt/oracle/admin/my_sid/
pfile/configmptp.ora
instance_number integer 0
job_queue_interval integer 60
job_queue_keep_connections boolean FALSE
job_queue_processes integer 0
license_max_sessions integer 0
license_max_users integer 0
license_sessions_warning integer 0
log_archive_buffer_size integer 64
log_archive_buffers integer 4
log_archive_dest string /opt/oracle/admin/my_sid/arch/
my_sid
log_archive_format string %t_%s.dbf
log_archive_start boolean TRUE
log_buffer integer 32768
log_checkpoint_interval integer 10000
log_checkpoint_timeout integer 0
log_checkpoints_to_alert boolean FALSE
log_files integer 255
log_simultaneous_copies integer 2
log_small_entry_max_size integer 800
max_commit_propagation_delay integer 90000
max_dump_file_size integer 500
max_enabled_roles integer 20
max_rollback_segments integer 30
max_transaction_branches integer 8
mts_dispatchers string
mts_listener_address string (address=(protocol=ipc)
(key=%s))
mts_max_dispatchers integer 0
mts_max_servers integer 0
mts_servers integer 0
mts_service string my_sid
nls_currency string
nls_date_format string
nls_date_language string
nls_iso_currency string
nls_language string AMERICAN
nls_numeric_characters string
nls_sort string
nls_territory string AMERICA
open_cursors integer 100
open_links integer 4
optimizer_comp_weight integer 0
optimizer_mode string CHOOSE
os_authent_prefix string
os_roles boolean FALSE
parallel_default_max_ integer 0
instances
parallel_default_max_scans integer 0
parallel_default_scansize integer 100
parallel_max_servers integer 5
parallel_min_servers integer 0
parallel_server_idle_time integer 5
post_wait_device string /devices/pseudo/pw@0:pw
pre_page_sga boolean FALSE
processes integer 60
recovery_parallelism integer 0
reduce_alarm boolean FALSE
remote_login_passwordfile string NONE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
resource_limit boolean FALSE
rollback_segments string rolb1, rolb2, rolb3, rolb4
row_cache_cursors integer 10
row_locking string default
sequence_cache_entries integer 10
sequence_cache_hash_buckets integer 7
serializable boolean FALSE
session_cached_cursors integer 0
sessions integer 71
shadow_core_dump string full
shared_pool_reserved_min_ integer 5000
alloc
shared_pool_reserved_size integer 0
shared_pool_size integer 6000000
single_process boolean FALSE
snapshot_refresh_interval integer 60
snapshot_refresh_keep_ boolean FALSE
connections
snapshot_refresh_processes integer 0
sort_area_retained_size integer 65536
sort_area_size integer 65536
sort_mts_buffer_for_fetch_ integer 0
size
sort_read_fac integer 5
sort_spacemap_size integer 512
spin_count integer 2000
sql92_security boolean FALSE
sql_trace boolean FALSE
temporary_table_locks integer 71
thread integer 0
timed_statistics boolean FALSE
transactions integer 78
transactions_per_rollback_ integer 34
segment
use_ism boolean TRUE
use_post_wait_driver boolean FALSE
use_readv boolean FALSE
user_dump_dest string /opt/oracle/admin/mysid/udump
NOTE: The SQL*DBA show parameters command does not display some of the specialized Oracle parameters that begin with an underscore such as _offline_rollback_segments and _db_block_write_batch.
| Previous | Table of Contents | Next |