易截截图软件、单文件、免安装、纯绿色、仅160KB

Oracle and IBM AIX 5.2 swapping and memory issues

Lately,
Jordan bank upgraded their ICBS banking software to Oracle 9i and
IDS9i. The Bank also moved from a decentralized to a centralized
system.
We were contracted to monitor and diagnose performance issues during the launching phase of the new system.
The IBM server was equipped with 32 GB of RAM, The Oracle SGA was
around 8GB of RAM. Around 2000 sessions were running on the system.
every now and then, high swapping activity was noticed, and the performance tended to degrade the longer the system is running.
The cause of this phenomenon is attributed to the AIX Virtual
Memory Manager. AIX keeps steeling memory pages to enhance the buffer
of File I/O. Since Oracle SGA is buffer file I/O already, such
Operating System feature is not suitable for Relational Database
Management Systems. Not only that, but SGA blocks end up being paged
from physical memory into paging, causing undesirable performance
impact.
The solution for this memory management problem configure memory
management in way that would decrease AIX physical memory acquisition
for buffering file IO.
The parameters that affect the described behaviour are shown in
bold below. Note that the shown values are the default values and are
not appropriate for RDBMS
memory_frames = 1572864
pinnable_frames = 1431781
maxfree = 1088
minfree = 960
minperm% = 20
minperm = 294356
maxperm% = 80
maxperm = 1177427
strict_maxperm = 0
maxpin% = 80
maxpin = 1258292
maxclient% = 80
lrubucket = 131072

It is recommended to modify the minperm% to 10-15%, maxperm% to 30% and maxclient% to value equal to maxpers% (30% in this case)
The following will enable you to find out how much memory is used by the AIX buffer system
# svmon -G
size inuse free pin virtual
memory 131072 128122 1800 10200 48990
pg space 262144 98220
work pers clnt lpage
pin 10203 0 0 0
in use 44030 84326 6


相关文档:

Oracle与AIX的角色

1.2.1  Oracle与AIX的角色
Oracle运行在AIX上,提供着数据的存储和管理服务。数据即信息,Oracle数据库就是应用系统中存储数据信息的一个集中存储位置、一种存取方法的商品化实现。AIX是承载Oracle运行的底层平台,进行着CPU调度、内存调度、存储管理、文件管理、网络驱动等系统运行和维护工作。
作为对应用系统的支 ......

ora_01034:oracle not available报错 解决方法

因为强制关机,开机的时候进入数据库报错:
ora_01034:oracle not available
ora_27101:shared memory realm does not exit
解决方法:
1.打开CMD
2.输入 sqlplus "/as sysdba"
3.回车
4.输入 startup
5.结束 ......

Oracle 如何定义自动增量autocreament的主键ID?

MySQL的ID非常方便定义,只要指定其字段的自动增量属性即可。
但是Oracle不行,需要定义sequence和triggedr,当然trigger可以不定义,但是不方便。
表定义如下:
CREATE TABLE GAME
(
  ID           
INTEGER      ......

Oracle RAC 常用维护工具和命令


Oracle 的管理可以通过OEM或者命令行接口。 Oracle Clusterware的命令集可以分为以下4种:
节点层:osnodes
网络层:oifcfg
集群层:crsctl, ocrcheck,ocrdump,ocrconfig
应用层:srvctl,onsctl,crs_stat
下面分别来介绍这些命令。 
一. 节点层
只有一个命令: osnodes, 这 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号