Oracle a modo mio: differenze tra le versioni

Da Emigar.
Jump to navigation Jump to search
Riga 1: Riga 1:


==audit asm su syslog==
==audit asm su syslog==

alter system set AUDIT_SYS_OPERATIONS=TRUE scope=spfile sid='*';
alter system set AUDIT_SYSLOG_LEVEL='local0.info' scope=spfile sid='*';


==audit database su syslog==
==audit database su syslog==

Versione delle 17:53, 29 ago 2016

audit asm su syslog

    alter system set AUDIT_SYS_OPERATIONS=TRUE scope=spfile sid='*';
    alter system set AUDIT_SYSLOG_LEVEL='local0.info' scope=spfile sid='*';

audit database su syslog

profilo scadenza password

recyclebin cancellazione a tempo

pulizia alert e diag con adrci

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

usare kernel uek