Oracle a modo mio: differenze tra le versioni
Jump to navigation
Jump to search
| Riga 25: | Riga 25: | ||
Checkpoint ad ogni switch di log: |
Checkpoint ad ogni switch di log: |
||
< |
<code> |
||
select BYTES/BLOCKSIZE from v$log; |
select max(BYTES/BLOCKSIZE) from v$log; |
||
BYTES/BLOCKSIZE |
MAX(BYTES/BLOCKSIZE) |
||
--------------- |
-------------------- |
||
262144 |
262144 |
||
262144 |
|||
262144 |
|||
262144 |
|||
262144 |
|||
262144 |
|||
Selezionate 6 righe. |
|||
alter system set log_checkpoint_interval=262144 scope=both; |
alter system set log_checkpoint_interval=262144 scope=both; |
||
</ |
</code> |
||
Checkpoint almeno ogni 5 minuti |
Checkpoint almeno ogni 5 minuti |
||
Versione delle 11:22, 15 nov 2016
audit asm su syslog
alter system set AUDIT_SYS_OPERATIONS=TRUE scope=spfile sid='*';
alter system set AUDIT_SYS_OPERATIONS=FALSE scope=spfile sid='*';
alter system set AUDIT_SYSLOG_LEVEL='local0.info' scope=spfile sid='*';
audit database su syslog
alter system set AUDIT_SYS_OPERATIONS=FALSE scope=spfile sid='*'; alter system set AUDIT_SYSLOG_LEVEL='local6.info' scope=spfile sid='*'; alter system set AUDIT_TRAIL='OS' scope=spfile sid='*';
profilo scadenza password
recyclebin cancellazione a tempo
pulizia alert e diag con adrci
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;
Su Linux
attivare hugepages
disattivare transparent hugepages
disable transparent hugepages https://docs.oracle.com/database/121/CWLIN/memry.htm
[ -f /sys/kernel/mm/redhat_transparent_hugepage/enabled ] && echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled