Alguem por gentileza tem algum script para configurar as variaveis do RMAN
versao 8i?
tenho uns 400 bancos aqui...todos 9 e 10...caiu um 8i de paraquedas aqui e o
SHOW ALL nao existe no 8i...
Atenciosamente,
Marcelo J. Monte Alto
- Mensagem original
De: cegoncalvesvr [EMAIL PROTECTED]
Para: oracle_br@yahoogrupos.com.br
Enviadas: Segunda-feira, 6 de Agosto de 2007 9:00:35
Assunto: [oracle_br] Parameter do Oracle - Oracle
Amigos,
O meu banco esta com 2,5 de RAM e ele esta lento em algumas
consulyas e na geração de relatorios.
Abaixo esta o conteudo do parameter dso meu banco.
Gostaria da ajuda de voces, por favor.
active_instance_ count
aq_tm_processes 1
archive_lag_ target 0
audit_sys_operation s FALSE
audit_trail NONE
background_core_ dump partial
background_dump_ dest D:\oracle\admin\ cssj\bdump
backup_tape_ io_slaves FALSE
bitmap_merge_ area_size 1048576
blank_trimming FALSE
buffer_pool_ keep
buffer_pool_ recycle
circuits 335
cluster_database FALSE
cluster_database_ instances 1
cluster_interconnec ts
commit_point_ strength 1
compatible 9.2.0.0.0
control_file_ record_keep_ time 7
control_files D:\oracle\oradata\ cssj\CONTROL01. CTL,
D:\oracle\oradata\ cssj\CONTROL02. CTL,
D:\oracle\oradata\ cssj\CONTROL03. CTL
core_dump_dest D:\oracle\admin\ cssj\cdump
cpu_count 1
create_bitmap_ area_size 8388608
cursor_sharing EXACT
cursor_space_ for_time FALSE
db_block_buffers 0
db_block_checking FALSE
db_block_checksum TRUE
db_block_size 8192
db_cache_advice ON
db_cache_size 419430400
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
db_domain
db_file_multiblock_ read_count 16
db_file_name_ convert
db_files 400
db_keep_cache_ size 0
dblink_encrypt_ login FALSE
db_name cssj
db_recycle_cache_ size 0
dbwr_io_slaves 0
db_writer_processes 1
db_16k_cache_ size 0
db_2k_cache_ size 0
db_32k_cache_ size 0
db_4k_cache_ size 0
db_8k_cache_ size 0
dg_broker_config_ file1 %ORACLE_HOME% \DATABASE\ DR1%ORACLE_ SID%.DAT
dg_broker_config_ file2 %ORACLE_HOME% \DATABASE\ DR2%ORACLE_ SID%.DAT
dg_broker_start FALSE
disk_asynch_ io TRUE
dispatchers (PROTOCOL=TCP) (SERVICE=cssjXDB)
distributed_ lock_timeout 60
dml_locks 4020
drs_start FALSE
enqueue_resources 4240
event
fal_client
fal_server
fast_start_io_ target 0
fast_start_mttr_ target 300
fast_start_parallel _rollback LOW
file_mapping FALSE
filesystemio_ options
fixed_date
gc_files_to_ locks
global_context_ pool_size
global_names FALSE
hash_area_size 2097152
hash_join_enabled TRUE
hi_shared_memory_ address 0
hs_autoregister TRUE
ifile
instance_groups
instance_name cssj
instance_number 0
java_max_sessionspa ce_size 0
java_pool_size 16777216
java_soft_sessionsp ace_limit 0
job_queue_processes 10
large_pool_size 50331648
license_max_ sessions 0
license_max_ users 0
license_sessions_ warning 0
local_listener
lock_name_space
lock_sga FALSE
log_archive_ dest
log_archive_ dest_state_ 1 enable
log_archive_ dest_state_ 10 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_1 LOCATION=E:\ ARCHIVE MANDATORY REOPEN
log_archive_ dest_10
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_ duplex_dest
log_archive_ format ARC%S.ARC
log_archive_ max_processes 2
log_archive_ min_succeed_ dest 1
log_archive_ start FALSE
log_archive_ trace 0
log_buffer 524288
log_checkpoint_ interval 0
log_checkpoints_ to_alert FALSE
log_checkpoint_ timeout 1800
log_file_name_ convert
logmnr_max_persiste nt_sessions 1
log_parallelism 1
max_commit_propagat ion_delay 700
max_dispatchers 5
max_dump_file_ size UNLIMITED
max_enabled_ roles 30
max_rollback_ segments 73
max_shared_servers 20
mts_circuits 335
mts_dispatchers (PROTOCOL=TCP) (SERVICE=cssjXDB)
mts_listener_ address
mts_max_dispatchers 5
mts_max_servers 20
mts_multiple_ listeners FALSE
mts_servers 1
mts_service cssj
mts_sessions 330
nls_calendar
nls_comp
nls_currency
nls_date_format
nls_date_language
nls_dual_currency
nls_iso_currency
nls_language AMERICAN
nls_length_semantic s BYTE
nls_nchar_conv_ excp FALSE
nls_numeric_ characters
nls_sort
nls_territory AMERICA
nls_time_format
nls_timestamp_ format
nls_timestamp_ tz_format
nls_time_tz_ format
object_cache_ max_size_ percent 10
object_cache_ optimal_size 102400
olap_page_pool_ size 33554432
open_cursors 450
open_links 4
open_links_per_ instance 4
optimizer_dynamic_ sampling 1
optimizer_features_ enable 9.2.0
optimizer_index_ caching 0
optimizer_index_ cost_adj 100
optimizer_max_ permutations 2000
optimizer_mode CHOOSE
oracle_trace_ collection_ name
oracle_trace_
