Tuning using the Alert log File

The Alert log file contains the following information which can be used in tuning the database:

Checkpoint start and end times.

Incomplete checkpoints

Time to perform archiving

Crash recovery start and complete times.

egg:

conn sys/oracle as sysdba

show parameter log_checkpoint_interal

show parameter log_chenkpoint_timeout

show parameter fast_start_io_terget

show parameter fast_start_mttr_target

alter system checkpoint

show parameter alert

alter system set log_checkpoints_to_alert=true

V$views:listed in v$fixed_table 动态性能视图

select event,total_waits,total_timeouts,time_waited,average_wait from v$system_event;

 

select name,parameter1,parameter2,parameter3 from v$event_name;

select sid,seq#,event ,wait_time,state from v$session_wait