Oracle a modo mio

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='*';

checkpoint con SE

Checkpoint ad ogni switch di log:

 select BYTES/BLOCKSIZE from v$log;

  BYTES/BLOCKSIZE
  ---------------

262144 262144 262144 262144 262144 262144

  Selezionate 6 righe.

 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

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