Oracle Automatic Workload Repository (AWR) nasıl kurulur.
Bu makale, Oracle Automatic Workload Repository kurulum adımlarını açıklamaktadır.
SnapShot listesi
|
1 2 3 4 5 6 7 |
set lines 100 pages 999 select snap_id , snap_level , to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin from dba_hist_snapshot order by 1 / |
Rapor oluşturma
|
1 |
@$ORACLE_HOME/rdbms/admin/awrrpt.sql |
Retention ve interval zamanları
|
1 2 3 4 5 |
col snap_interval format a30 col retention format a30 select snap_interval , retention from dba_hist_wr_control |
Interval ayarları
|
1 |
exec dbms_workload_repository.modify_snapshot_settings (interval => 30) -- Gets a snapshot every 30 mins |
Periodların değiştirilmesi
|
1 |
exec dbms_workload_repository.modify_snapshot_settings (retention => 10*24*60) -- Set to 10 days |
Manuel snapshot alma
|
1 |
exec dbms_workload_repository.create_snapshot |
Baseline ların listelenmesi
|
1 2 3 4 5 6 7 8 9 |
set lines 100 col baseline_name format a40 select baseline_id aseline_name , start_snap_id , end_snap_id from dba_hist_baseline order by 1 / |
Baseline oluşturma
|
1 |
exec dbms_workload_repository.create_baseline (<start snap>, <endsnap>,'<name>') |
Baseline silme
|
1 |
exec dbms_workload_repository.drop_baseline('<baseline name>') |
Default snapshot aktif edilmesi (active by default)
|
1 |
exec dbms_scheduler.enable('GATHER_STATS_JOB') |
Default snapshot pasif edilmesi (active by default)
|
1 |
exec dbms_scheduler.disable('GATHER_STATS_JOB') |
Sistem zaman modeli
|
1 2 3 4 5 6 |
set lines 100 pages 999 select stat_name , value from v$sys_time_model order by value desc / |
Session zaman modeli
|
1 2 3 4 5 6 7 |
set set lines 100 pages 999 select stat_name , value from v$sess_time_model where sid = '&sid' order by value desc / |
Aktif session bilgileri
|
1 |
@$ORACLE_HOME/rdbms/admin/ashrpt.sql |
Kategori seçin...