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]
