Oracle a modo mio: differenze tra le versioni
Jump to navigation
Jump to search
| Riga 9: | Riga 9: | ||
==audit database su syslog== |
==audit database su syslog== |
||
audit_syslog_level LOCAL6.INFO |
|||
alter system set AUDIT_SYS_OPERATIONS=FALSE scope=spfile sid='*'; |
|||
audit_sys_operations TRUE |
|||
alter system set AUDIT_SYSLOG_LEVEL='local6.info' scope=spfile sid='*'; |
|||
audit_trail OS |
|||
alter system set AUDIT_TRAIL='OS' scope=spfile sid='*'; |
|||
==profilo scadenza password== |
==profilo scadenza password== |
||
Versione delle 13:17, 16 set 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
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