Oracle 估算闪回区大小
一个朋友问如何设置Oracle闪回区大小，有什么依据没有。 查证官方文档，有这样的描述For example, if you intend to setDB_FLASHBACK_RETENTION_TARGET to 24 hours,and if the database generates 20 GB of redo in a day, then a rule of thumb is to a
Read more日期：2016年12月30日
Greenplum安装(1) – 系统安装部署
一、安装操作系统 SWAP大小不小于内存容量 1、关闭NetworkManager、iptables、selinux 2、配置/etc/sysctl.conf
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
kernel.shmmax = 500000000 kernel.shmmni = 4096 kernel.shmall = 4000000000 kernel.sem = 250 512000 100 2048 #SEMMSL SEMMNS SEMOPM SEMMNI kernel.sysrq = 1 kernel.core_uses_pid = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.msgmni = 2048 net.ipv4.tcp_syncookies = 1 net.ipv4.ip_forward = 0 net.ipv4.conf.default.accept_source_route = 0 net.ipv4.tcp_tw_recycle = 1 net.ipv4.tcp_max_syn_backlog = 4096 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.arp_filter = 1 net.ipv4.conf.all.arp_filter = 1 net.ipv4.ip_local_port_range = 1025 65535 net.core.netdev_max_backlog = 10000 vm.overcommit_memory = 2 |
3、配置/etc/security/limits.conf
|
1 2 3 4 5 6 7 |
echo ' * soft nofile 65536 * hard nofile 65536 * soft nproc 131072 * hard nproc 131072 * soft core unlimited ' >>/etc/security/limits.conf |
4、对于redhat 6.x系统，还需要将/et
Read more