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_ collection_ path %ORACLE_HOME% \OTRACE\ADMIN\ CDF\
oracle_trace_ collection_ size 5242880
oracle_trace_ enable FALSE
oracle_trace_ facility_ name oracled
oracle_trace_ facility_ path %ORACLE_HOME% \OTRACE\ADMIN\ FDF\
os_authent_prefix OPS$
os_roles FALSE
O7_DICTIONARY_ ACCESSIBILITY FALSE
parallel_adaptive_ multi_user FALSE
parallel_automatic_ tuning 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
pga_aggregate_ target 0
plsql_compiler_ flags INTERPRETED
plsql_native_ c_compiler
plsql_native_ library_dir
plsql_native_ library_subdir_ count 0
plsql_native_ linker
plsql_native_ make_file_ name
plsql_native_ make_utility
plsql_v2_compatibil ity FALSE
pre_page_sga FALSE
processes 300
query_rewrite_ enabled FALSE
query_rewrite_ integrity enforced
rdbms_server_ dn
read_only_open_ delayed FALSE
recovery_parallelis m 0
remote_archive_ enable true
remote_dependencies _mode TIMESTAMP
remote_listener
remote_login_ passwordfile EXCLUSIVE
remote_os_authent FALSE
remote_os_roles FALSE
replication_ dependency_ tracking TRUE
resource_limit FALSE
resource_manager_ plan
rollback_segments
row_locking always
serializable FALSE
serial_reuse DISABLE
service_names cssj
session_cached_ cursors 0
session_max_ open_files 10
sessions 335
sga_max_size 932259220
shadow_core_ dump partial
shared_memory_ address 0
shared_pool_ reserved_ size 10905190
shared_pool_ size 419430400
shared_servers 1
shared_server_ sessions 330
sort_area_retained_ size 0
sort_area_size 1048576
spfile %ORACLE_HOME% \DATABASE\ SPFILE%ORACLE_ SID%.ORA
sql_trace FALSE
sql_version NATIVE
sql92_security FALSE
standby_archive_ dest %ORACLE_HOME% \RDBMS
standby_file_ management MANUAL
star_transformation _enabled FALSE
statistics_level TYPICAL
tape_asynch_ io TRUE
thread 0
timed_os_statistics 0
timed_statistics TRUE
trace_enabled TRUE
tracefile_identifie r
transaction_ auditing TRUE
transactions 368
transactions_ per_rollback_ segment 5
undo_management AUTO
undo_retention 10800
undo_suppress_ errors FALSE
undo_tablespace UNDOTBS1
use_indirect_ data_buffers FALSE
user_dump_dest D:\oracle\admin\ cssj\udump
utl_file_dir
workarea_size_ policy MANUAL
Abs.
Eduardo
Alertas do Yahoo! Mail em seu celular. Saiba mais em
http://br.mobile.yahoo.com/mailalertas/
[As partes desta mensagem que não continham texto foram removidas]
