Oracle Standard Edition: differenze tra le versioni
Jump to navigation
Jump to search
(Creata pagina con " Categoria:Oracle Categoria:Database") |
|||
(6 versioni intermedie di uno stesso utente non sono mostrate) | |||
Riga 1: | Riga 1: | ||
=Limiti della SE= |
|||
=Statspack= |
|||
==Job schedulazione statspack== |
|||
ALTER SESSION SET time_zone = 'EUROPE/ROME'; |
|||
select * from dba_scheduler_jobs where job_name='STATSPACK_SNAP_AND_PURGE'; |
|||
BEGIN |
|||
DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE'); |
|||
END; |
|||
/ |
|||
BEGIN |
|||
DBMS_SCHEDULER.CREATE_JOB ( |
|||
job_name => 'PERFSTAT.STATSPACK_SNAP_AND_PURGE', |
|||
job_type => 'PLSQL_BLOCK', |
|||
job_action => 'BEGIN |
|||
statspack.snap(); |
|||
if extract(hour from systimestamp) = 1 and extract(minute from systimestamp) < 30 |
|||
then |
|||
statspack.purge(i_num_days=>180,i_extended_purge=>TRUE); |
|||
end if; |
|||
END;', |
|||
repeat_interval => 'FREQ=MINUTELY; INTERVAL=30;', |
|||
auto_drop => FALSE, |
|||
enabled => TRUE, |
|||
comments => 'Statspack automated snap and purge'); |
|||
END; |
|||
/ |
|||
=Baseline= |
|||
=Tuning Checkpoint= |
|||
==checkpoint con SE== |
|||
Checkpoint ad ogni switch di log: |
|||
<pre> |
|||
select max(BYTES/BLOCKSIZE) from v$log; |
|||
MAX(BYTES/BLOCKSIZE) |
|||
-------------------- |
|||
262144 |
|||
alter system set log_checkpoint_interval=262144 scope=both; |
|||
</pre> |
|||
Checkpoint almeno ogni 5 minuti |
|||
alter system set log_checkpoint_timeout=600 scope=both; |
|||
Versione attuale delle 12:56, 25 gen 2021
Limiti della SE
Statspack
Job schedulazione statspack
ALTER SESSION SET time_zone = 'EUROPE/ROME';
select * from dba_scheduler_jobs where job_name='STATSPACK_SNAP_AND_PURGE';
BEGIN DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE'); END; /
BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'PERFSTAT.STATSPACK_SNAP_AND_PURGE', job_type => 'PLSQL_BLOCK', job_action => 'BEGIN statspack.snap(); if extract(hour from systimestamp) = 1 and extract(minute from systimestamp) < 30 then statspack.purge(i_num_days=>180,i_extended_purge=>TRUE); end if; END;', repeat_interval => 'FREQ=MINUTELY; INTERVAL=30;', auto_drop => FALSE, enabled => TRUE, comments => 'Statspack automated snap and purge'); END; /
Baseline
Tuning Checkpoint
checkpoint con SE
Checkpoint ad ogni switch di log:
select max(BYTES/BLOCKSIZE) from v$log; MAX(BYTES/BLOCKSIZE) -------------------- 262144 alter system set log_checkpoint_interval=262144 scope=both;
Checkpoint almeno ogni 5 minuti
alter system set log_checkpoint_timeout=600 scope=both;