Date: 11/23/01 Page: 1
Time: 05:33 PM Show Session Information SYS
oracle8i databa
NAME VALUE DESCRIPTION
------------------------- -------------------- -------------------------
O7_DICTIONARY_ACCESSIBILI TRUE Version 7 Dictionary Acce
TY ssibility Support
active_instance_count number of active instance
s in the parallel server
always_anti_join NESTED_LOOPS always use this method fo
r anti-join when possible
always_semi_join standard always use this method fo
r semi-join when possible
aq_tm_processes 0 number of AQ Time Manager
s to start
audit_file_dest ?/rdbms/audit Directory in which auditi
ng files are to reside
audit_trail NONE enable system auditing
background_core_dump partial Core Size for Background
Processes
background_dump_dest /export/share/oracle Detached process dump dir
/admin/oracle8i/bdum ectory
p
backup_tape_io_slaves FALSE BACKUP Tape I/O slaves
bitmap_merge_area_size 1048576 maximum memory allow for
BITMAP MERGE
blank_trimming FALSE blank trimming semantics
parameter
buffer_pool_keep Number of database blocks
/latches in keep buffer p
ool
buffer_pool_recycle Number of database blocks
/latches in recycle buffe
r pool
commit_point_strength 1 Bias this node has toward
not preparing in a two-p
hase commit
compatible 8.1.0 Database will be complete
ly compatible with this s
oftware versio
control_file_record_keep_ 7 control file record keep
time time in days
control_files /export/share/oracle control file names list
/oradata/oracle8i/co
ntrol01.ctl, /export
/share/oracle/oradat
a/oracle8i/control02
.ctl, /export/share/
oracle/oradata/oracl
e8i/control03.ctl
core_dump_dest /export/share/oracle Core dump directory
/admin/oracle8i/cdum
p
cpu_count 4 number of cpu's for this
instance
create_bitmap_area_size 8388608 size of create bitmap buf
fer for bitmap index
cursor_sharing EXACT cursor sharing mode
cursor_space_for_time FALSE use more memory in order
to get faster execution
db_block_buffers 2000 Number of database blocks
cached in memory
db_block_checking FALSE data and index block chec
king
db_block_checksum FALSE store checksum in db bloc
ks and check during reads
db_block_lru_latches 2 number of lru latches
db_block_max_dirty_target 2000 Upper bound on modified b
uffers/recovery reads
db_block_size 8192 Size of database block in
bytes
db_domain se.cuhk.edu.hk directory part of global
database name stored with
CREATE DATABA
db_file_direct_io_count 64 Sequential I/O block coun
t
db_file_multiblock_read_c 8 db block to be read each
ount IO
db_file_name_convert datafile name convert pat
tern and string for stand
by/clone datab
db_files 200 max allowable # db files
db_name oracle8i database name specified i
n CREATE DATABASE
db_writer_processes 1 number of background data
base writer processes to
start
dblink_encrypt_login FALSE enforce password for dist
ributed login always be e
ncrypted
dbwr_io_slaves 0 DBWR I/O slaves
disk_asynch_io TRUE Use asynch I/O for random
access devices
distributed_transactions 22 max. number of concurrent
distributed transactions
dml_locks 360 dml locks - one for each
table modified in a trans
action
enqueue_resources 580 resources for enqueues
event debug event control - def
ault null string
fast_start_io_target 2000 Upper bound on recovery r
eads
fast_start_parallel_rollb LOW max number of parallel re
ack covery slaves that may be
used
fixed_date fixed SYSDATE value
gc_defer_time 10 how long to defer down co
nverts for hot buffers (D
FS)
gc_files_to_locks mapping between file numb
ers and lock buckets (DFS
)
gc_releasable_locks 0 number of releasable lock
s (DFS)
gc_rollback_locks 0-128=32!8REACH locks for the rollback se
gments (DFS)
global_names FALSE enforce that database lin
ks have same name as remo
te database
hash_area_size 131072 size of in-memory hash wo
rk area
hash_join_enabled TRUE enable/disable hash join
hash_multiblock_io_count 0 number of blocks hash joi
n will read/write at once
hi_shared_memory_address 0 SGA starting address (hig
h order 32-bits on 64-bit
platforms)
hs_autoregister TRUE enable automatic server D
D updates in HS agent sel
f-registration
ifile include file in init.ora
instance_groups list of instance group na
mes
instance_name oracle8i instance name supported b
y the instance
instance_number 0 instance number
java_max_sessionspace_siz 0 max allowed size in bytes
e of a Java sessionspace
java_pool_size 20000000 size in bytes of the Java
pool
java_soft_sessionspace_li 0 warning limit on size in
mit bytes of a Java sessionsp
ace
job_queue_interval 60 Wakeup interval in second
s for job queue processes
job_queue_processes 0 number of job queue proce
sses to start
large_pool_size 6291450 size in bytes of the larg
e allocation pool
license_max_sessions 0 maximum number of non-sys
tem user sessions allowed
license_max_users 0 maximum number of named u
sers that can be created
in the databas
license_sessions_warning 0 warning level for number
of non-system user sessio
ns
lm_locks 12000 number of locks configure
d for the lock manager
lm_ress 6000 number of resources confi
gured for the lock manage
r
local_listener local listener
lock_name_space lock name space used for
generating lock names for
standby/clone
lock_sga FALSE Lock entire SGA in physic
al memory
log_archive_dest archival destination text
string
log_archive_dest_1 location=/export/sha archival destination #1 t
re/oracle/admin/orac ext string
le8i/arch
log_archive_dest_2 archival destination #2 t
ext string
log_archive_dest_3 archival destination #3 t
ext string
log_archive_dest_4 archival destination #4 t
ext string
log_archive_dest_5 archival destination #5 t
ext string
log_archive_dest_state_1 enable archival destination #1 s
tate text string
log_archive_dest_state_2 enable archival destination #2 s
tate text string
log_archive_dest_state_3 enable archival destination #3 s
tate text string
log_archive_dest_state_4 enable archival destination #4 s
tate text string
log_archive_dest_state_5 enable archival destination #5 s
tate text string
log_archive_duplex_dest duplex archival destinati
on text string
log_archive_format arch_%t_%s.arc archival destination form
at
log_archive_max_processes 1 maximum number of active
ARCH processes
log_archive_min_succeed_d 1 minimum number of archive
est destinations that must s
ucceed
log_archive_start TRUE start archival process on
SGA initialization
log_archive_trace 0 Establish archivelog oper
ation tracing level
log_buffer 163840 redo circular buffer size
log_checkpoint_interval 10000 # redo blocks checkpoint
threshold
log_checkpoint_timeout 1800 Maximum time interval bet
ween checkpoints in secon
ds
log_checkpoints_to_alert FALSE log checkpoint begin/end
to alert file
log_file_name_convert logfile name convert patt
ern and string for standb
y/clone databa
max_commit_propagation_de 700 Max age of new snapshot i
lay n .01 seconds
max_dump_file_size UNLIMITED Maximum size (blocks) of
dump file
max_enabled_roles 30 max number of roles a use
r can have enabled
max_rollback_segments 30 max. number of rollback s
egments in SGA cache
mts_circuits 82 max number of mts circuit
s
mts_dispatchers (protocol=TCP) specifications of dispatc
hers
mts_listener_address address(es) of network li
stener
mts_max_dispatchers 5 max number of dispatchers
mts_max_servers 20 max number of servers
mts_multiple_listeners FALSE Are multiple listeners en
abled?
mts_servers 1 number of servers to star
t up
mts_service oracle8i service supported by disp
atchers
mts_sessions 77 max number of mts session
s
nls_calendar NLS calendar system name
nls_comp NLS comparison
nls_currency NLS local currency symbol
nls_date_format NLS Oracle date format
nls_date_language NLS date language name
nls_dual_currency Dual currency symbol
nls_iso_currency NLS ISO currency territor
y name
nls_language AMERICAN NLS language name
nls_numeric_characters NLS numeric characters
nls_sort NLS linguistic definition
name
nls_territory AMERICA NLS territory name
nls_time_format time format
nls_time_tz_format time with timezone format
nls_timestamp_format time stamp format
nls_timestamp_tz_format timestampe with timezone
format
object_cache_max_size_per 10 percentage of maximum siz
cent e over optimal of the use
r session's ob
object_cache_optimal_size 102400 optimal size of the user
session's object cache in
bytes
open_cursors 300 max # cursors per process
open_links 4 max # open links per sess
ion
open_links_per_instance 4 max # open links per inst
ance
ops_interconnects interconnects for ops use
optimizer_features_enable 8.1.7 optimizer plan compatibil
ity parameter
optimizer_index_caching 0 optimizer percent index c
aching
optimizer_index_cost_adj 100 optimizer index cost adju
stment
optimizer_max_permutation 80000 optimizer maximum join pe
s rmutations per query bloc
k
optimizer_mode CHOOSE optimizer mode
optimizer_percent_paralle 0 optimizer percent paralle
l l
oracle_trace_collection_n Oracle TRACE default coll
ame ection name
oracle_trace_collection_p ?/otrace/admin/cdf Oracle TRACE collection p
ath ath
oracle_trace_collection_s 5242880 Oracle TRACE collection f
ize ile max. size
oracle_trace_enable FALSE Oracle Trace enabled/disa
bled
oracle_trace_facility_nam oracled Oracle TRACE default faci
e lity name
oracle_trace_facility_pat ?/otrace/admin/fdf Oracle TRACE facility pat
h h
os_authent_prefix prefix for auto-logon acc
ounts
os_roles FALSE retrieve roles from the o
perating system
parallel_adaptive_multi_u FALSE enable adaptive setting o
ser f degree for multiple use
r streams
parallel_automatic_tuning FALSE enable intelligent defaul
ts for parallel execution
parameters
parallel_broadcast_enable FALSE enable broadcasting of sm
d all inputs to hash and so
rt merge joins
parallel_execution_messag 2148 message buffer size for p
e_size arallel execution
parallel_instance_group instance group to use for
all parallel operations
parallel_max_servers 5 maximum parallel query se
rvers per instance
parallel_min_percent 0 minimum percent of thread
s required for parallel q
uery
parallel_min_servers 0 minimum parallel query se
rvers per instance
parallel_server FALSE if TRUE startup in parall
el server mode
parallel_server_instances 1 number of instances to us
e for sizing OPS SGA stru
ctures
parallel_threads_per_cpu 2 number of parallel execut
ion threads per CPU
partition_view_enabled FALSE enable/disable partitione
d views
plsql_v2_compatibility FALSE PL/SQL version 2.x compat
ibility flag
pre_page_sga FALSE pre-page sga for process
processes 70 user processes
query_rewrite_enabled FALSE allow rewrite of queries
using materialized views
if enabled
query_rewrite_integrity enforced perform rewrite using mat
erialized views with desi
red integrity
rdbms_server_dn RDBMS's Distinguished Nam
e
read_only_open_delayed FALSE if TRUE delay opening of
read only files until fir
st access
recovery_parallelism 0 number of server processe
s to use for parallel rec
overy
remote_dependencies_mode TIMESTAMP remote-procedure-call dep
endencies mode parameter
remote_login_passwordfile EXCLUSIVE password file usage param
eter
remote_os_authent FALSE allow non-secure remote c
lients to use auto-logon
accounts
remote_os_roles FALSE allow non-secure remote c
lients to use os roles
replication_dependency_tr TRUE tracking dependency for R
acking eplication parallel propa
gation
resource_limit TRUE master switch for resourc
e limit
resource_manager_plan resource mgr top plan
rollback_segments undo segment list
row_locking always row-locking
serial_reuse DISABLE reuse the frame segments
serializable FALSE serializable
service_names oracle8i.se.cuhk.edu service names supported b
.hk y the instance
session_cached_cursors 0 number of cursors to save
in the session cursor ca
che
session_max_open_files 10 maximum number of open fi
les allowed per session
sessions 82 user and system sessions
shadow_core_dump partial Core Size for Shadow Proc
esses
shared_memory_address 0 SGA starting address (low
order 32-bits on 64-bit
platforms)
shared_pool_reserved_size 686601 size in bytes of reserved
area of shared pool
shared_pool_size 13732024 size in bytes of shared p
ool
sort_area_retained_size 65536 size of in-memory sort wo
rk area retained between
fetch calls
sort_area_size 65536 size of in-memory sort wo
rk area
sort_multiblock_read_coun 2 multi-block read count fo
t r sort
sql92_security FALSE require select privilege
for searched update/delet
e
sql_trace FALSE enable SQL trace
sql_version NATIVE sql language version para
meter for compatibility i
ssues
standby_archive_dest ?/dbs/arch standby database archivel
og destination text strin
g
star_transformation_enabl FALSE enable the use of star tr
ed ansformation
tape_asynch_io TRUE Use asynch I/O requests f
or tape devices
text_enable FALSE enable text searching
thread 0 Redo thread to mount
timed_os_statistics 0 internal os statistic gat
hering interval in second
s
timed_statistics FALSE maintain internal timing
statistics
tracefile_identifier trace file custom identif
ier
transaction_auditing TRUE transaction auditing reco
rds generated in the redo
log
transactions 90 max. number of concurrent
active transactions
transactions_per_rollback 5 number of active transact
_segment ions per rollback segment
use_indirect_data_buffers FALSE Enable indirect data buff
ers (very large SGA on 32
-bit platforms
user_dump_dest /export/share/oracle User process dump directo
/admin/oracle8i/udum ry
p
utl_file_dir utl_file accessible direc
tories list
203 rows selected.
SQL> [BACK]