Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Calling in the Cavalry - Hanging 8i database
There are 3 control files all in diff locations
There are 5 logfile groups each with one logfile of 25MB
The server is a e450 Sun Sparc, with quad processors and 2GB RAM
I've never attempted to kill a session as user internal.
Oracle is patched up to 8174. The policy with the Solaris box is not to patch unless absolutely necessary. Essentially, we still have the same setup as before the hanging started and our USA box (non-hanging) is identical and has no problems (however, it does not host as many applications as the hanging box - mainly javva).
As I'm new to the role I can't really comment on the changes to the init.ora file. However, I have appended all the values below (sorry for the clutter).
regards
John
PARAMETERS
NAME TYPE VALUE processes 3 250 sessions 3 280 timed_statistics 1 FALSE timed_os_statistics 3 0 resource_limit 1 FALSE license_max_sessions 3 0 license_sessions_warning 3 0 cpu_count 3 4 instance_groups 2 event 2 shared_pool_size 2 209715200 shared_pool_reserved_size 2 10485760 large_pool_size 2 2097512 java_pool_size 2 15728640 java_soft_sessionspace_limit 3 0 java_max_sessionspace_size 3 0 pre_page_sga 1 FALSE shared_memory_address 3 0 hi_shared_memory_address 3 0 use_indirect_data_buffers 1 FALSE lock_sga 1 FALSE lock_name_space 2 enqueue_resources 3 4220 nls_language 2 AMERICAN nls_territory 2 AMERICA nls_sort 2 binary nls_date_language 2 nls_date_format 2 nls_currency 2 nls_numeric_characters 2 nls_iso_currency 2 nls_calendar 2 nls_time_format 2 nls_timestamp_format 2 nls_time_tz_format 2 nls_timestamp_tz_format 2 nls_dual_currency 2 nls_comp 2 disk_asynch_io 1 TRUE tape_asynch_io 1 TRUE dbwr_io_slaves 3 0 backup_tape_io_slaves 1 FALSE ops_interconnects 2 db_file_direct_io_count 3 64 resource_manager_plan 2 hpux_sched_noage 3 lm_ress 3 6000 lm_locks 3 12000 active_instance_count 3 control_files 2 /data01/oradata/oranc1/control01.ctl,
db_file_name_convert 2 log_file_name_convert 2 db_block_buffers 3 76800 db_block_checksum 1 FALSE db_block_size 3 8192 db_block_lru_latches 3 2 db_writer_processes 3 1 db_block_max_dirty_target 3 76800 buffer_pool_keep 2 buffer_pool_recycle 2 max_commit_propagation_delay 3 700 compatible 2 8.1.7 log_archive_start 1 TRUE log_archive_dest 2 log_archive_duplex_dest 2 log_archive_dest_1 2 location=/data02/oradata/oranc1/arch log_archive_dest_2 2 log_archive_dest_3 2 log_archive_dest_4 2 log_archive_dest_5 2 log_archive_dest_state_1 2 enable log_archive_dest_state_2 2 enable log_archive_dest_state_3 2 enable log_archive_dest_state_4 2 enable log_archive_dest_state_5 2 enable log_archive_max_processes 3 1 log_archive_min_succeed_dest 3 1 standby_archive_dest 2 ?/dbs/arch log_archive_trace 3 0 log_archive_format 2 arch_%t_%s.arc log_buffer 3 1048576 log_checkpoint_interval 3 100000 log_checkpoint_timeout 3 1800 db_files 3 200 db_file_multiblock_read_count 3 8 read_only_open_delayed 1 FALSE parallel_server 1 FALSE parallel_server_instances 3 1 gc_releasable_locks 3 0 gc_rollback_locks 2 0-1024=32!8REACH gc_files_to_locks 2 gc_defer_time 3 10 thread 3 0 fast_start_io_target 3 76800 log_checkpoints_to_alert 1 FALSE recovery_parallelism 3 0 control_file_record_keep_time 3 7 dml_locks 3 4000 row_locking 2 always serializable 1 FALSE replication_dependency_tracking 1 TRUE instance_number 3 0 transactions 3 1000 transactions_per_rollback_segment 3 5 max_rollback_segments 3 200 rollback_segments 2 transaction_auditing 1 TRUE fast_start_parallel_rollback 2 LOW db_block_checking 1 FALSE os_roles 1 FALSE rdbms_server_dn 2 max_enabled_roles 3 30 remote_os_authent 1 FALSE remote_os_roles 1 FALSE O7_DICTIONARY_ACCESSIBILITY 1 TRUE remote_login_passwordfile 2 NONE dblink_encrypt_login 1 FALSE license_max_users 3 0 db_domain 2 osg.com global_names 1 TRUE _distributed_lock_timeout 3 180 distributed_transactions 3 10 commit_point_strength 3 1 instance_name 2 oranc1 service_names 2 oranc1.osg.com mts_dispatchers 2 (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) mts_servers 3 1 mts_max_servers 3 20 mts_max_dispatchers 3 5 mts_sessions 3 275 mts_circuits 3 280 local_listener 2 mts_service 2 oranc1 mts_listener_address 2 mts_multiple_listeners 1 FALSE open_links 3 6 open_links_per_instance 3 4 optimizer_features_enable 2 8.1.7 fixed_date 2 audit_trail 2 NONE sort_area_size 3 4194304 sort_area_retained_size 3 4194304 sort_multiblock_read_count 3 2 db_name 2 oranc1 open_cursors 3 1000 ifile 4 sql_trace 1 FALSE os_authent_prefix 2 OSG_ optimizer_mode 2 CHOOSE sql92_security 1 FALSE blank_trimming 1 FALSE always_anti_join 2 NESTED_LOOPS partition_view_enabled 1 FALSE star_transformation_enabled 2 FALSE parallel_broadcast_enabled 1 FALSE parallel_adaptive_multi_user 1 FALSE parallel_threads_per_cpu 3 2 parallel_automatic_tuning 1 FALSE always_semi_join 2 STANDARD optimizer_max_permutations 3 80000 optimizer_index_cost_adj 3 100 optimizer_index_caching 3 0 query_rewrite_enabled 1 FALSE query_rewrite_integrity 2 enforced sql_version 2 NATIVE serial_reuse 2 DISABLE cursor_space_for_time 1 FALSE session_cached_cursors 3 0 text_enable 1 FALSE remote_dependencies_mode 2 TIMESTAMP utl_file_dir 2 * plsql_v2_compatibility 1 FALSE job_queue_processes 3 10 job_queue_interval 3 10 optimizer_percent_parallel 3 0 parallel_min_percent 3 0 create_bitmap_area_size 3 8388608 bitmap_merge_area_size 3 1048576 cursor_sharing 2 EXACT parallel_min_servers 3 2 parallel_max_servers 3 10 parallel_instance_group 2 parallel_execution_message_size 3 2148 hash_join_enabled 1 TRUE hash_area_size 3 8388608 hash_multiblock_io_count 3 0 shadow_core_dump 2 partial background_core_dump 2 partial background_dump_dest 2 /oracle/admin/dump user_dump_dest 2 /oracle/admin/dump max_dump_file_size 2 UNLIMITED core_dump_dest 2 /oracle/admin/dump tracefile_identifier 2 audit_file_dest 2 ?/rdbms/audit oracle_trace_enable 1 FALSE oracle_trace_facility_path 2 ?/otrace/admin/fdf oracle_trace_collection_path 2 ?/otrace/admin/cdf oracle_trace_facility_name 2 oracled oracle_trace_collection_name 2 oracle_trace_collection_size 3 5242880 object_cache_optimal_size 3 102400 object_cache_max_size_percent 3 10 session_max_open_files 3 10 aq_tm_processes 3 0 hs_autoregister 1 TRUEReceived on Sun May 15 2005 - 08:21:48 CDT