storage:file system,raw partitions,automatic storage management
distributing files: separate datafiles and redo log files,stripe table data,reduce disk i/o unrelated to db
i/o statistics: v$filestat v$tempstat v$datafile v$tempfile
file striping:os striping,manual striping
tuning full table scan: para db_file_multiblock_read_count
v$session_longops, v$sysstat
checkpoints types:incremental,full(complete,tablespace) -> alter system checkpoint
checkpoint queue para:fast_start_to_target,fast_start_mttr_target,log_checkpoint_interval,log_checkpoint_timeout
v$instance_recovery
redo groups and members: v$log,v$logfile,v$log_history
archivelog:v$archive_dest v$archived_log v$archive_processes log_archive_dest_n
Oracle database configuration and i/o issues
最新推荐文章于 2021-04-14 23:43:01 发布