Execute: SELECT to_char(sysdate,’YYYY-MON-DD HH24:MI:SS’) FROM dual; Result: 2019-SEP-26 15:24:40 To extract the hour:: SELECT TO_CHAR(SYSDATE,’HH24′) AS CURRENT_HOUR FROM DUAL;
Oracle Linunx Kernel limits
Oracle recommendatios for operating limits /etc/sysctl.conf kernel.sem = 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 4194304 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 fs.file-max = 6815744 Then execute: /sbin/sysctl -p /etc/security/limits.conf Leer más