http://ggf0626.itpub.net ggf0626 Fri,21 11 2008 18:34:24 http://ggf0626.itpub.net/post/26381/279021 用分析函数显示日志切换的频率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---------- ----------- ---------- 1 03 21:06:25 473.83 1 04 05:00:15 962.68 1 04 21:02:56 380.22 1 05 03:23:09 937.87 1 05 19:01:01 477.12 1 06 02:58:08 1083.63 1 06 21:01:46 384.72 1 07 03:26:29 214.55 1 07... ORACLE Tue,10 04 2007 12:27:35 ggf0626 http://ggf0626.itpub.net/post/26381/276167 As our circle of knowledge expands, so does the circumference of darkness surrounding it.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.”so,ju... RANDOM Sun,01 04 2007 10:20:17 ggf0626 http://ggf0626.itpub.net/post/26381/275084 RAC的2个关键特性是负载均衡和切换。RAC扩展了单个实例的负载均衡能力，单个实例只能在本地的调度器（使用MTS时）间均衡，而RAC可以在组成一个群集的多个实例间实现负载均衡。通过在多个节点上配置LISTENER来管理客户端对同一个数据库服务的连接请求，从而实现切换。连接负载均衡和切换都需要跨实例的注册。RAC的2个关键特性是负载均衡和切换。RAC扩展了单个实例的负载均衡能力，单个实例只能在本地的调度器（使用MTS时）间均衡，而RAC可以在组成一个群集的多个实例间实现负载均衡。通过在多个节点上配置LISTENER来管理客户端对同一个数据... ORACLE Tue,27 03 2007 12:23:17 ggf0626 http://ggf0626.itpub.net/post/26381/233801 请牢记您BLOG的域名http://ggf0626.itpub.net/您BLOG的控制面板在http://ggf0626.itpub.net/admin.php登陆口令就是论坛口令，BLOG的口令和论坛是捆绑的。您可以在控制面板里完成发表文章，修改名称，模版以及观察统计数据等功能全体ITPUB BLOG的内容首页在http://weblog.itpub.net/可以在这里了解整个ITPUB BLOG的状况，包括最新文章，BLOG列表，排名，统计数据等怎样才可以使自己的BLOG变得知名？只有宣传才可以使网站的访问增多，您可以把您的BLOG连接写在签名档里，或者在帖子里介绍给别的会员，也可以在别的网站和现实场合进行广泛的宣... 一般分类 Fri,01 12 2006 23:10:08 ggf0626