ORACLE
-
编辑 删除
ORACLE10g的新试图：DBA_BLOCKERS
DBA_BLOCKERS displays a session if it is not waiting for a locked object but is holding a lock on an object for which another session is waiting.应该是比较有用的哦。[@more@]
-
编辑 删除
AIX RAC 下等待事件
发现一个AIX5.2上oracle9I RAC 环境出现大量会话等待“FREE GLOBAL TRANSACTION TABLE ENTRY”后来经metalink上咨询，后发现，是网络参数没有设过的原因。需要按照安装文档中所述，修改网络参数[@more@]2.4.3 Configure Network Tuning ParametersVerify that the network tuning parameters shown in the following table are set to the values shown or higher values. The procedure following the table describes how to verify and set the values.Network Tuning ParameterRecommended Valueipqmaxlen512rfc13231sb_max2*655360tc
