易截截图软件、单文件、免安装、纯绿色、仅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学习笔记8 9


表分区维护:
添加分区:
Alter table student add partition 分区名 values less than(100);
删除分区:
Alter table student drop partition 分区名;
截短分区:
Alter table student truncate partition 分区名;
合并分区:
Alter table student merge partitions 分区名,...,分区名 into partition 新分区名; ......

Oracle中几个关于日期方面的SQL实例

№1:取得当前日期是本月的第几周
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;

TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09

SQL> select to_char(sysdate,'W') from dual;

T
-
4 ......

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.结束 ......

用 java调用oracle存储过程总结

1、什么是存储过程。存储过程是数据库服务器端的一段程序,它有两种类型。一种类似于SELECT查询,用于检索数据,检索到的数据能够以数据集的形式返
回给客户。另一种类似于INSERT或DELETE查询,它不返回数据,只是执行一个动作。有的服务器允许同一个存储过程既可以返回数据又可以执行动作。
2、什么时候需要用存储过程
......

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号