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 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;

incrementare SDU e BUF_SIZE

per incrementare SDU bisogna agire sul listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (SDU = 32768)
      (SEND_BUF_SIZE=32768)
      (RECV_BUF_SIZE=32768)
      (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 2483))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC2483))
    )
  )

expdp consistente

    flashback_time='"to_timestamp_tz(systimestamp)"'

Su Linux

attivare hugepages

in /etc/sysctl.conf o /etc/sysctl.d/99-oracle.conf

    ### Hugepages
    vm.hugetlb_shm_group=54322
    vm.nr_hugepages=1024

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