Glauber, Analisando superficialmente, o parametro "_allow_resetlogs_corruption" esta habilitado.. Dê uma procurada no metalink sobre esse parametro...
Abs --- Em oracle_br@yahoogrupos.com.br, Glauber Moisés Garcia <[EMAIL PROTECTED]> escreveu > > Pessoal, > > sou novo aqui no grupo e já vou encher o saco da turma !!! > > Sei pra que realizar tunning de um banco não existe receita... > Algum tempo atrás eu tinha conseguido uns script´s e com eles umas > explicações de como analisar os indicadores gerados pelos scripts. > Com eles fiz alterações nos parametros de SGA e melhoraram muito !. > Só q perdi esses selects. E agora não consigo encontrar.(Não com as dicas de análise) > Se alguém tiver algum material (em portugues) ou possa me auxiliar. > > Tenho um oracle 9i rodando em um HP-ux com 1Gb de memória. > O servidor não é dedicado. O sistema utilizado não realiza inserção maciça > de dados. Porém, faz muita consulta ao banco. > Coloquei os parametros do banco. Se tiver alguém q possa me ajudar ! > > tracefile_identifier > > processes 200 > sessions 550 > timed_statistics TRUE > timed_os_statistics 0 > resource_limit FALSE > license_max_sessions 0 > license_sessions_warning 0 > cpu_count 1 > instance_groups > > event > > shared_pool_size 637534208 > sga_max_size 848260384 > shared_pool_reserved_size 5242880 > large_pool_size 67108864 > java_pool_size 16777216 > java_soft_sessionspace_limit 0 > java_max_sessionspace_size 0 > pre_page_sga FALSE > shared_memory_address 0 > hi_shared_memory_address 0 > use_indirect_data_buffers FALSE > lock_sga FALSE > spfile > > lock_name_space > > enqueue_resources 1200 > trace_enabled TRUE > nls_language AMERICAN > nls_territory AMERICA > nls_sort > > nls_date_language > > nls_date_format > > nls_currency > > nls_numeric_characters > > nls_iso_currency > > nls_calendar > > nls_time_format > > nls_timestamp_format > > nls_time_tz_format > > nls_timestamp_tz_format > > nls_dual_currency > > nls_comp > > nls_length_semantics BYTE > nls_nchar_conv_excp FALSE > filesystemio_options asynch > disk_asynch_io FALSE > tape_asynch_io FALSE > dbwr_io_slaves 0 > backup_tape_io_slaves FALSE > resource_manager_plan > > cluster_interconnects > > file_mapping FALSE > active_instance_count > > control_files /bdoracle/TASY/ct3/control04.ctl > db_file_name_convert > > log_file_name_convert > > db_block_buffers 0 > db_block_checksum TRUE > db_block_size 8192 > db_writer_processes 1 > db_keep_cache_size 0 > db_recycle_cache_size 0 > db_2k_cache_size 0 > db_4k_cache_size 0 > db_8k_cache_size 0 > db_16k_cache_size 0 > db_32k_cache_size 0 > db_cache_size 16777216 > buffer_pool_keep > > buffer_pool_recycle > > db_cache_advice ON > max_commit_propagation_delay 700 > compatible 9.2.0.0.0 > remote_archive_enable true > log_archive_start TRUE > log_archive_dest /bdoracle/TASY/arc > log_archive_duplex_dest > > log_archive_dest_1 > > log_archive_dest_2 > > log_archive_dest_3 > > log_archive_dest_4 > > log_archive_dest_5 > > log_archive_dest_6 > > log_archive_dest_7 > > log_archive_dest_8 > > log_archive_dest_9 > > log_archive_dest_10 > > 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_dest_state_6 enable > log_archive_dest_state_7 enable > log_archive_dest_state_8 enable > log_archive_dest_state_9 enable > log_archive_dest_state_10 enable > log_archive_max_processes 2 > log_archive_min_succeed_dest 1 > standby_archive_dest ?/dbs/arch > log_archive_trace 0 > fal_server > > fal_client > > log_archive_format arch_%S.log > log_buffer 75497472 > log_checkpoint_interval 6144 > log_checkpoint_timeout 1800 > archive_lag_target 0 > log_parallelism 1 > db_files 500 > db_file_multiblock_read_count 32 > read_only_open_delayed FALSE > cluster_database FALSE > parallel_server FALSE > parallel_server_instances 1 > cluster_database_instances 1 > db_create_file_dest > > db_create_online_log_dest_1 > > db_create_online_log_dest_2 > > db_create_online_log_dest_3 > > db_create_online_log_dest_4 > > db_create_online_log_dest_5 > > standby_file_management MANUAL > gc_files_to_locks > > thread 0 > fast_start_io_target 0 > fast_start_mttr_target 0 > _allow_resetlogs_corruption TRUE > log_checkpoints_to_alert TRUE > recovery_parallelism 0 > control_file_record_keep_time 7 > logmnr_max_persistent_sessions 1 > dml_locks 500 > row_locking always > serializable FALSE > replication_dependency_tracking TRUE > instance_number 0 > transactions 550 > transactions_per_rollback_segment 5 > max_rollback_segments 110 > rollback_segments > > transaction_auditing TRUE > undo_management AUTO > undo_tablespace UNDOTBS > undo_suppress_errors FALSE > undo_retention 900 > fast_start_parallel_rollback LOW > db_block_checking FALSE > os_roles FALSE > rdbms_server_dn > > max_enabled_roles 100 > remote_os_authent TRUE > remote_os_roles FALSE > O7_DICTIONARY_ACCESSIBILITY FALSE > remote_login_passwordfile NONE > dblink_encrypt_login FALSE > license_max_users 0 > global_context_pool_size > > audit_sys_operations FALSE > db_domain world > global_names TRUE > distributed_lock_timeout 60 > commit_point_strength 1 > instance_name TASY > service_names TASY.world > dispatchers > > mts_dispatchers > > shared_servers 0 > mts_servers 0 > max_shared_servers 20 > mts_max_servers 20 > max_dispatchers 5 > mts_max_dispatchers 5 > circuits 0 > mts_circuits 0 > shared_server_sessions 0 > mts_sessions 0 > local_listener > > remote_listener > > mts_service TASY > mts_listener_address > > mts_multiple_listeners FALSE > serial_reuse DISABLE > cursor_space_for_time FALSE > session_cached_cursors 0 > remote_dependencies_mode TIMESTAMP > utl_file_dir /bdoracle/TASY/txts > plsql_v2_compatibility FALSE > plsql_compiler_flags INTERPRETED > plsql_native_c_compiler > > plsql_native_linker > > plsql_native_library_dir > > plsql_native_make_utility > > plsql_native_make_file_name > > plsql_native_library_subdir_count 0 > job_queue_processes 2 > parallel_min_percent 0 > create_bitmap_area_size 8388608 > bitmap_merge_area_size 1048576 > cursor_sharing EXACT > parallel_min_servers 0 > parallel_max_servers 0 > parallel_instance_group > > parallel_execution_message_size 2152 > hash_join_enabled TRUE > hash_area_size 524288 > shadow_core_dump partial > background_core_dump partial > background_dump_dest /bdoracle/TASY/bdump > user_dump_dest /bdoracle/TASY/udump > max_dump_file_size 8000 > core_dump_dest /bdoracle/TASY/cdump > audit_file_dest /bdoracle/TASY/adump > hpux_sched_noage 0 > oracle_trace_enable FALSE > oracle_trace_facility_path ?/otrace/admin/fdf > oracle_trace_collection_path ?/otrace/admin/cdf > oracle_trace_facility_name oracled > oracle_trace_collection_name > > oracle_trace_collection_size 5242880 > object_cache_optimal_size 102400 > object_cache_max_size_percent 10 > session_max_open_files 10 > open_links 4 > open_links_per_instance 4 > optimizer_features_enable 36565 > fixed_date > > audit_trail NONE > sort_area_size 1048576 > sort_area_retained_size 524288 > db_name TASY > open_cursors 1000 > ifile > > sql_trace FALSE > os_authent_prefix > > optimizer_mode RULE > sql92_security FALSE > blank_trimming FALSE > partition_view_enabled FALSE > star_transformation_enabled FALSE > parallel_adaptive_multi_user FALSE > parallel_threads_per_cpu 2 > parallel_automatic_tuning FALSE > optimizer_max_permutations 2000 > optimizer_index_cost_adj 100 > optimizer_index_caching 0 > query_rewrite_enabled false > query_rewrite_integrity enforced > sql_version NATIVE > pga_aggregate_target 0 > workarea_size_policy MANUAL > optimizer_dynamic_sampling 1 > statistics_level TYPICAL > aq_tm_processes 0 > hs_autoregister TRUE > dg_broker_start FALSE > drs_start FALSE > dg_broker_config_file1 ?/dbs/[EMAIL PROTECTED] > dg_broker_config_file2 ?/dbs/[EMAIL PROTECTED] > olap_page_pool_size 33554432 > > > > Atenciosamente, > > > > Glauber Moisés Garcia - TI > Analista de Sistemas > > > [As partes desta mensagem que não continham texto foram removidas] >