-
编辑 删除
一次ORA-60死锁故障的处理
在一个数据库的警告日志中发现产生大量的ORA-60死锁报错，并导致了udump下产生了大量的trace文件。导致/app文件系统迅速增长。分析警告日志，和死锁产生的trace文件。 警告日志节选Tue Feb 9 14:19...
-
编辑 删除
用分析函数显示日志切换的频率
用分析函数显示日志切换的频率[@more@]select thread#, to_char(first_time,'dd hh24:mi:ss') first_time, round(24 * 60 * ( lead(first_time,1) over ( partition by thread# order by first_time ) - first_time ),2) minutesfrom v$log_history vwhere recid >= 117order by thread#, recid; THREAD# FIRST_TIME MINUTES---
-
编辑 删除
expand our circle of knowledge
As our circle of knowledge expands, so does the circumference of darkness surrounding it.[@more@]The more you know, the more you realise you don’t know…Recently i read a blog post from http://www.oracle-base.com/blog/2007/03/26/the-more-you-know-the-more-you-realise-you-dont-know/. and i have also the same feeling,there are so many things to learn,sometime really feel frustrated. Einstein got there first:“As our circle of knowledge expands, so does the circumference of darkness surrounding it
-
编辑 删除
RAC学习摘记 part1 - 负载均衡和透明应用切换
RAC的2个关键特性是负载均衡和切换。RAC扩展了单个实例的负载均衡能力，单个实例只能在本地的调度器（使用MTS时）间均衡，而RAC可以在组成一个群集的多个实例间实现负载均衡。通过在多个节点上配置LISTENER来管理客户端对同一个数据库服务的连接请求，从而实现切换。连接负载均衡和切换都需要跨实例的注册。[@more@]RAC的2个关键特性是负载均衡和切换。RAC扩展了单个实例的负载均衡能力，单个实例只能在本地的调度器（使用MTS时）间均衡，而RAC可以在组成一个群集的多个实例间实现负载均衡。通过在多个节点上配置LISTENER来管理客户端对同
