Oracle 10g R2安装时内核参数的设置
字段名称 |
推荐配置 |
文件 |
察看参数设置情况 |
semmsl |
250 |
/proc/sys/kernel/sem |
# /sbin/sysctl -a | grep sem |
semmns |
32000 |
||
semopm |
100 |
||
semmni |
128 |
||
shmall |
2097152 |
/proc/sys/kernel/shmall |
# /sbin/sysctl -a | grep shm |
shmmax |
Half the size of physical memory (in bytes) |
/proc/sys/kernel/shmmax |
|
shmmni |
4096 |
/proc/sys/kernel/shmmni |
|
file-max |
65536 |
/proc/sys/fs/file-max |
# /sbin/sysctl -a | grep file-max |
ip_local_port_range |
Minimum: 1024 |
/proc/sys/net/ipv4/ip_local_port_range |
# /sbin/sysctl -a | grep ip_local_port_range |
rmem_default |
262144 |
/proc/sys/net/core/rmem_default |
# /sbin/sysctl -a | grep rmem_default |
rmem_max |
262144 |
/proc/sys/net/core/rmem_max |
# /sbin/sysctl -a | grep rmem_max |
wmem_default |
262144 |
/proc/sys/net/core/wmem_default |
# /sbin/sysctl -a | grep wmem_default |
wmem_max |
262144 |
/proc/sys/net/core/wmem_max |
# /sbin/sysctl -a | grep wmem_max |
备注:
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
# /sbin/chkconfig boot.sysctl on
Shell Limit |
Item in limits.conf |
Hard Limit |
Maximum number of open file descriptors |
nofile |
65536 |
Maximum number of processes available to a single user |
nproc |
16384 |
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
session required /lib/security/pam_limits.so
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
if ( $USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
endif
1.查看所有用户:
select * from dba_users;
select * from all_users;
select * from user_users;
2.查看用户系统权限:
select * from dba_sys_privs;
select * from all_sys_privs;
select * from user_sys_privs;
3.查看用户对象权限:
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
4.查看所有角色:
select * from dba_roles;
5.查看用户所拥有的角色:
select * from dba_role_privs;
select * from user_role_privs;
6.查看当前用户的缺省表空间
select username,default_tablespace from user_users;
7.查看某个角色的具体权限,如grant connect,resource,create session,create view to TEST;查看RESOURCE具有那些权限,用
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE='RESOURCE';
SELECT file_name FROM dba_data_files
union
select file_name from dba_temp_files
union
select member from v$logfile
union
select name from v$controlfile
服务热线:051265581585 15851499111 QQ:71947910 40435865