dbafan.com
eagle's home | “We are what we repeatedly do. Excellence, then, is not an act, but a habit.” -Aristotle
http://www.dbafan.com/blog
We are what we repeatedly do. Excellence, then, is not an act, but a habit. -Aristotle. June 23, 2015. CouchDB是Apache的一个开源项目http:/ couchdb.apache.org/。 December 8, 2014. Use -pr to repair only the first range returned by the partitioner. Cassandra的数据可以有多份复制,比如说A,B,C,D四个节点,keyspace的replication factor为2. A节点上有range (D,A)的primary数据,同时也有range(C,D)的replica数据。 Pr 那么会在A节点和B节点上同步range (D,A)的数据. 1 A节点和B节点上同步range (D,A)的数据. 2 A节点和D节点上同步range (C,D)的数据. Use -local to only repair against nodes in the same data center.
dbafan.com
eagle's home | “We are what we repeatedly do. Excellence, then, is not an act, but a habit.” -Aristotle | Page 2
http://www.dbafan.com/blog?paged=2
We are what we repeatedly do. Excellence, then, is not an act, but a habit. -Aristotle. Newer posts →. October 8, 2011. 这里说的所有SQL指的是存在于v$sql中还没有被age out出去的SQL. 一般频繁运行的SQL都是存在于v$sql中没有被age out出去的。 Select * from v$sql where lower(sql text) like ‘%TABLE NAME%’. Select * from v$sql where hash value in (select hash value from v$sql plan where object owner=’xxx’ and object name=’TABLE NAME’);. SYS@XFAN: SQL explain plan for select * from test where x=1;. Plan hash value: 1416057887. 1 INDEX RANGE SCAN TEST IDX.