cod42960-CSDN博客

转载 oracle备库延时的监控方法

oracle备库延时的监控方法[@more@]根据最后一个已经apply的日志文件的next_time时间戳进行判断 select /*+ rule */ nvl(round((sysdate-max(NEXT_TIME))*2...

2012-06-27 11:45:07 363

转载预警的些想法

预警的些想法[@more@]1.预警的意义通知我们某个点出现了异常，并且这个异常在可预见的未来可能会造成什么样的影响2.预警的要素监控点&触发点&对象&渠道&频率3.一次通知定义语音...

2012-05-25 14:57:30 155

转载 Bug 9290526 - Poor plan for recursive SQL used for DML involving a UNIQUE constraint [ID 9290526.8]

Bug 9290526 - Poor plan for recursive SQL used for DML involving a UNIQUE constraint [ID 9290526.8] … [@more@] A s...

2012-05-08 19:18:58 176

转载 softer soft parse

softer soft parse 软软解析[@more@]不解释，帖链接http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams228.htmhttp:/...

2012-04-11 20:05:52 141

转载 NUMA架构下oracle的oom异常

numa oracle oom[@more@]3.NUMA+oracle的一些问题 1）.rh54-hugepage oracle的sga并非完全预分配，hugepage应该是预分配出page的，虽然没有划给SGA，所以内存...

2011-06-18 17:55:11 310

转载 oracle DG VCS切换异常问题

oracle11.2.0.2 dg vcs ha 切换异常[@more@]现象：oracle11.2.0.2+vcs，当有主库的public进程连接到备库时，ha无法正常完成备库实例的切换。问题关键点如下： 1）oracle...

2011-06-18 17:50:11 228

转载 slave_exec_mode

http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#sysvar_slave_exec_mode[@more@]一直都习惯使用slave_s...

2011-02-19 16:04:58 122

转载记录：Bug 8575528 Missing entries in V$MUTEX_SLEEP.location

Bug 8575528 Missing entries in V$MUTEX_SLEEP.location[@more@]Affects:Product (Component)Oracle Server (Rdbms) Ran...

2011-01-11 10:52:39 119

转载 try mysql5.5.8

install mysql558[@more@]首先阅读下官方文档说明http://dev.mysql.com/doc/refman/5.5/en/source-installation.html按照cmake吧，就不说了,下载...

2010-12-21 13:56:27 94

转载 mysql bug 55981

blob bug[@more@]http://www.mysqlperformanceblog.com/2010/11/29/data-corruption-drbd-and-story-of-bug/http://bugs.m...

2010-11-30 18:55:13 96

转载 service_name or sid

service_name or sid[@more@]问题起源于itpub一个帖子http://www.itpub.net/thread-1358298-1-1.html，答案呢，通过service_name实现failover...

2010-10-15 23:27:28 84

转载 Oracle SQL performance with database links - dblink

Oracle SQL performance with database links - dblink[@more@]http://download.oracle.com/docs/cd/B14117_01/server.101...

2010-08-18 15:28:21 91

转载 Surge Scalability 2010

Surge Scalability 2010[@more@]Surge Scalability 2010，值得关注下，转一位speaker的演讲概要在这里，希望有所启发。http://ronaldbradford.com/blo...

2010-07-29 09:42:55 198

转载 On MySQL replication, again…

http://mituzas.lt/2010/06/30/replication/[@more@]http://mituzas.lt/2010/06/30/replication/很是认同，转载下There are few th...

2010-07-01 19:42:10 83

转载 innodb急着奔1.1？

2010-06-21 10:37:03 130

转载 Percona release 5147

2010-06-18 17:51:47 84

转载 ibdata1

ibdata1[@more@]记得之前曾在Pub上看到innodb共享表空间暴涨的案例，自己在实际测试中也遇到多（高并发情况），其中缘由也是知晓一二，今天看到peter的两篇博文进行了详细的描述，简单记录下来备查。http://...

2010-06-11 09:47:38 82

转载 _optimizer_compute_index_stats

_optimizer_compute_index_stats[@more@]COMPUTE STATISTICS In earlier releases, you could use this clause to start ...

2010-06-09 16:10:04 157

转载一些文章收集

文章收集[@more@]fast paging in the real worldhttp://cafuego.net/2010/05/26/fast-paging-real-worldFixing MySQL group co...

2010-06-01 11:19:00 67

转载 oracle之commit控制

oracle之commit控制[@more@]_lgwr_async_io_wait_for_synccommit_writehttp://download.oracle.com/docs/cd/E11882_01/server...

2010-05-24 15:09:47 95

转载 shell按列求和

http://www.linuxsong.org/2008/08/shell_05.html[@more@]Shell中如何按列求和？转载http://www.linuxsong.org/2008/08/shell_05.ht...

2010-05-21 11:29:47 719

转载 mysql表结构复制

2010-05-19 15:30:14 77

转载 InnoDB Plugin has been upgraded to version 1.0.8

test[@more@]InnoDB Plugin has been upgraded to version 1.0.8http://dev.mysql.com/doc/refman/5.1/en/news-5-1-47.htm...

2010-05-14 10:07:51 108

转载 How to Brainstorm New Ideas

http://www.theopenforce.com/2010/05/more_brainstorm.html[@more@]转载自http://www.theopenforce.com/2010/05/more_brains...

2010-05-13 09:48:21 610

转载 How To Kill Good Ideas

http://www.theopenforce.com/2010/05/brainstorm.htmlhttp://mysqlmusings.blogspot.com/2006/08/two-more-ways-to-kill-...

2010-05-13 09:47:42 176

转载 DBI@参数数据类型

DBI@[@more@]简单记录下先http://search.cpan.org/~timb/DBI/DBI.pm#DBI_Constantshttp://perl.enstimac.fr/perl5.6.1/site_perl...

2010-05-10 20:01:14 161

转载 mysql innodb之select for update nowait

2010-05-10 10:57:32 592

转载 mysql dead lock detection

2010-05-09 11:55:10 96

转载解决TIME_WAIT的问题

原文链接：http://bbs.linuxtone.org/thread-853-1-1.html IT运维专家网--"自由平等，互助分享！"[@more@]原文链接：http://bbs.linuxtone.org/threa...

2010-05-05 10:54:09 57

转载并发执行hang问题

2010-04-27 18:12:53 83

转载一些关于磁盘IO的文章

一些关于磁盘IO的文章[@more@]http://www.fishpool.org/post/2008/03/31/Optimizing-Linux-I/O-on-hardware-RAIDhttp://en.wikipedi...

2010-04-24 19:53:47 75

转载转：linux io调度深入分析

http://www.lupaworld.com/56821/viewspace-142725.html[@more@]读完这篇最好读下http://kerneltrap.org/node/7637，really great转自...

2010-04-24 17:28:03 3561

转载 ocfs2之琐记

2010-04-23 16:12:36 127

转载通过hostname获取IP的perl脚本

2010-04-21 15:17:43 105

转载 oracle & NFS & backup & event & 10298

2010-04-20 10:34:24 285

转载 oracle10g之standby tempfile自动创建

2010-04-20 09:55:33 161

转载 Opiino: Attach Failed! Error=-1 Ifvp=0

2010-04-19 18:59:10 561

转载 Improve reporting with duplicate server-ids

2010-04-16 09:04:00 149

转载 linux cron三言两语

2010-04-13 16:07:36 79

转载 innodb plugin 1.0.7 GA版本

2010-04-13 14:26:01 62

空空如也

空空如也