Database Name Info
warning
alert
Level Parameter Value
O7_DICTIONARY_ACCESSIBILITY TRUE
always_anti_join NESTED_LOOPS
always_semi_join standard
aq_tm_processes 0
audit_file_dest /home/oracle/admin/BAMBARA/adump
audit_trail NONE
background_core_dump partial
background_dump_dest /home/oracle/admin/BAMBARA/bdump
backup_tape_io_slaves FALSE
bitmap_merge_area_size 1048576
blank_trimming FALSE
buffer_pool_keep
buffer_pool_recycle
commit_point_strength 1
compatible 8.0.0
control_file_record_keep_time 7
control_files /home/oracle/admin/BAMBARA/cntl/control01.ctl, /home/oracle/admin/BAMBARA/cntl/control02.ctl
core_dump_dest /home/oracle/admin/BAMBARA/cdump
cpu_count 1
create_bitmap_area_size 8388608
cursor_space_for_time FALSE
db_block_buffers 200
db_block_checking FALSE
db_block_checksum FALSE
db_block_lru_latches 1
db_block_max_dirty_target 200
db_block_size 2048
db_domain
db_file_direct_io_count 64
db_file_multiblock_read_count 8
db_file_name_convert
db_files 80
db_name BAMBARA
db_writer_processes 1
dblink_encrypt_login FALSE
dbwr_io_slaves 0
disk_asynch_io TRUE
distributed_transactions 4
dml_locks 200
enqueue_resources 345
ent_domain_name
event
fast_start_io_target 200
fast_start_parallel_rollback LOW
fixed_date
gc_defer_time 10
gc_files_to_locks
gc_releasable_locks 0
gc_rollback_locks
global_names TRUE
hash_area_size 131072
hash_join_enabled TRUE
hash_multiblock_io_count 0
hi_shared_memory_address 0
hs_autoregister TRUE
ifile /home/oracle/admin/BAMBARA/pfile/configBAMBARA.ora
instance_groups
instance_name
instance_number 0
java_max_sessionspace_size 0
java_pool_size 20000K
java_soft_sessionspace_limit 0
job_queue_interval 60
job_queue_processes 1
large_pool_size 0
license_max_sessions 0
license_max_users 0
license_sessions_warning 0
lm_locks 12000
lm_procs 127
lm_ress 6000
local_listener
lock_name_space
lock_sga FALSE
log_archive_dest
log_archive_dest_1
log_archive_dest_2
log_archive_dest_3
log_archive_dest_4
log_archive_dest_5
log_archive_dest_state_1 enable
log_archive_dest_state_2 enable
log_archive_dest_state_3 enable
log_archive_dest_state_4 enable
log_archive_dest_state_5 enable
log_archive_duplex_dest
log_archive_format %t_%s.dbf
log_archive_max_processes 1
log_archive_min_succeed_dest 1
log_archive_start FALSE
log_buffer 8192
log_checkpoint_interval 10000
log_checkpoint_timeout 1800
log_checkpoints_to_alert FALSE
log_file_name_convert
max_commit_propagation_delay 700
max_dump_file_size 10240
max_enabled_roles 20
max_rollback_segments 30
mts_dispatchers
mts_listener_address
mts_max_dispatchers 5
mts_max_servers 20
mts_multiple_listeners FALSE
mts_servers 0
mts_service BAMBARA
nls_calendar
nls_comp
nls_currency
nls_date_format MM/DD/RR
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_numeric_characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_time_tz_format
nls_timestamp_format
nls_timestamp_tz_format
object_cache_max_size_percent 10
object_cache_optimal_size 102400
open_cursors 500
open_links 4
open_links_per_instance 4
optimizer_features_enable 8.1.5
optimizer_index_caching 0
optimizer_index_cost_adj 100
optimizer_max_permutations 80000
optimizer_mode CHOOSE
optimizer_percent_parallel 0
optimizer_search_limit 5
oracle_trace_collection_name
oracle_trace_collection_path ?/otrace/admin/cdf
oracle_trace_collection_size 5242880
oracle_trace_enable FALSE
oracle_trace_facility_name oracled
oracle_trace_facility_path ?/otrace/admin/fdf
os_authent_prefix ops$
os_roles FALSE
parallel_adaptive_multi_user FALSE
parallel_automatic_tuning FALSE
parallel_broadcast_enabled FALSE
parallel_execution_message_size 2148
parallel_instance_group
parallel_max_servers 5
parallel_min_percent 0
parallel_min_servers 0
parallel_server FALSE
parallel_server_instances 1
parallel_threads_per_cpu 2
partition_view_enabled FALSE
plsql_load_without_compile FALSE
plsql_v2_compatibility FALSE
pre_page_sga FALSE
processes 100
query_rewrite_enabled FALSE
query_rewrite_integrity enforced
rdbms_server_dn
read_only_open_delayed FALSE
recovery_parallelism 0
remote_dependencies_mode TIMESTAMP
remote_login_passwordfile NONE
remote_os_authent FALSE
remote_os_roles FALSE
replication_dependency_tracking TRUE
resource_limit FALSE
resource_manager_plan
rollback_segments r01, r02, r03, r04, r05
row_locking always
serial_reuse DISABLE
serializable FALSE
service_names BAMBARA
session_cached_cursors 0
session_max_open_files 10
sessions 115
shadow_core_dump partial
shared_memory_address 0
shared_pool_reserved_size 200000
shared_pool_size 4000000
sort_area_retained_size 0
sort_area_size 65536
sort_multiblock_read_count 2
sql92_security FALSE
sql_trace FALSE
standby_archive_dest ?/dbs/arch
star_transformation_enabled FALSE
tape_asynch_io TRUE
text_enable FALSE
thread 0
timed_os_statistics 0
timed_statistics TRUE
transaction_auditing TRUE
transactions 126
transactions_per_rollback_segment 5
use_indirect_data_buffers FALSE
user_dump_dest /home/oracle/admin/BAMBARA/udump
utl_file_dir
Info for BAMBARA Database last updated 07/07/2000 03:24