Lentidão ao conectar – REDOLOGS – GPO (Grupo de Profissionais Oracle)

11 de setembro de 2012 às 6:18 pm #104404

Hitotuzi

Participante

Bom dia,

    O tempo de alternância de log é em média 13 minutos, são 3 arquivos de REDOLOG de 100MB cada, o parâmetro log_buffer está setado para 4 MB Obedecendo a regra (512kb * cpu_count).

select * from v$database;

dbid: 43087394
name: sisgprd
created: 11/11/2011 10:40:34
resetlogs_change#: 190578
resetlogs_time: 11/11/2011 10:40:34
prior_resetlogs_change#: 1
prior_resetlogs_time: 12/5/2002 16:16:56
log_mode: noarchivelog
checkpoint_change#: 3107165926
archive_change#: 3107004571
controlfile_type: current
controlfile_created: 11/11/2011 10:40:34
controlfile_sequence#: 144540
controlfile_change#: 3107165926
controlfile_time: 11/9/2012 08:09:31
open_resetlogs: not allowed
version_time: 11/11/2011 10:40:34
open_mode: read write
protection_mode: maximum performance
protection_level: unprotected
remote_archive: enabled
activation#: 43091746
database_role: primary
archivelog_change#: 0
switchover_status: sessions active
dataguard_broker: disabled
guard_status: none
supplemental_log_data_min: no
supplemental_log_data_pk: no
supplemental_log_data_ui: no
force_logging: no

select * from v$instance;

instance_number: 1
instance_name: sisgprd
host_name: server03
version: 9.2.0.1.0
startup_time: 11/9/2012 08:09:23
status: open
parallel: no
thread#: 1
archiver: stopped
log_switch_wait:
logins allowed:
shutdown_pending: no
database_status: active
instance_role: primary_instance
active_state: normal

show parameter log_archive

log_archive_dest string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_duplex_dest string
log_archive_format string ARC%S.%T
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0

show parameter dest_1

db_create_online_log_dest_1 string
log_archive_dest_1 string
log_archive_dest_10 string

show parameter dest_2

db_create_online_log_dest_2 string
log_archive_dest_2 string