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

==profilo scadenza password==

==recyclebin cancellazione a tempo==

==pulizia alert e diag con adrci==

==checkpoint con SE==


Checkpoint ad ogni switch di log:

<pre>
  select max(BYTES/BLOCKSIZE) from v$log;

   MAX(BYTES/BLOCKSIZE)
   --------------------
	         262144


  alter system set log_checkpoint_interval=262144 scope=both;
</pre>

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

<code>
[ -f /sys/kernel/mm/redhat_transparent_hugepage/enabled ] && echo never > /sys/kernel/mm/redhat_transparent_hugepage/enabled
</code>

==usare kernel uek==





[[Categoria:Database]]