dbthink.com

acoug.org

ACOUG会员项目(ACOUG MEMBERSHIP PROGRAM)-中国 Oracle 用户组

http://www.acoug.org/acoug-membership-program

ACOUG Senior Member(ASM) 资深会员. 会员 是该项目的入门级，是那些在ACOUG社区中刚刚开始活动但是渴望在更高的层次做出贡献的人士 ASM 则是那些已经在社区中做出卓越贡献的人士。 成为 ACOUG Member(AM) 会员 有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Member 会员. ACOUG Member(AM) 会员 的义务. 成为 ACOUG Senior Member(ASM) 资深会员 有哪些好处. 在ACOUG网站中被标志和推荐为 ACOUG Senior Member 专家. 可使用ACOUG Senior Member(ASM) logo. 有机会参加每年的ACOUG Borad Member(ABM) 董事成员候选人评选，进入ACOUG董事会. ACOUG Senior Member(ASM) 资深会员 的义务. 对于当年没有任何文章、活动贡献的会员，将保留把该会员的ACOUG Member状态修改为 ACOUG Alumnus(ACOUG校友(前会员) 的权力，直至下一次申请通过。 Eygle – 盖国强. 老熊 – 熊军.

uhesse.com

Reorganizing Tables in Oracle – is it worth the effort? | The Oracle Instructor

https://uhesse.com/2010/08/23/reorganizing-tables-in-oracle-is-it-worth-the-effort

Explain, Exemplify, Empower. Laquo; Using Flashback in a Data Guard Environment. Data Guard and Oracle Restart in 11gR2. Reorganizing Tables in Oracle – is it worth the effort? This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. I decided therefore to cover it briefly here in order to be able to point to this post in the future. Short answer: Probably not. SQL select * from v$version;. CORE 11.2.0.1.0 Production. SQL delete from...

hellodb.net

Hello Database » MySQL单机多实例方案

http://www.hellodb.net/2011/06/mysql_multi_instance.html

Stay Hungry. Stay Foolish. 6 28th, 2011 Posted by jacky. 虽然MySQL后续版本一直在改进这个问题，包括Innodb plugin和Percona XtraDB都对多核CPU的利用率改进了很多，但是依然无法实现性能随着CPU core的增加而提升。 MySQL采用了线程模式，对于NUMA特性的支持并不好，如果单机只运行一个MySQL实例，我们可以选择关闭NUMA，关闭的方法有三种 1.硬件层，在BIOS中设置关闭 2.OS内核，启动时设置numa=off 3.可以用numactl命令将内存分配策略修改为interleave 交叉 ，有些硬件可以在BIOS中设置。 Numactl –cpubind=0 –localalloc，此. 6 28th, 201123:28. 6 29th, 201110:04. 6 29th, 201111:26. 6 29th, 201118:25. 6 29th, 201118:26. 6 29th, 201118:28. 7 2nd, 201100:19. 10 22nd, 201111:58.

penglixun.com

数据库大牛 | P.Linux Laboratory

http://www.penglixun.com/masters_books/dba_masters

2008-2016 P.Linux Laboratory. 更新时间: 5月 15th, 2010. Http:/ www.alidba.net/. Http:/ www.hellodba.net/. Http:/ www.isky000.com/. Http:/ www.dbthink.com/. 8212;——————————————————————————-. Http:/ rdc.taobao.com/blog/dba/. Http:/ rdc.taobao.com/blog/dw/. Http:/ www.orawh.com/. Http:/ www.ixdba.com/. Http:/ www.ningoo.net/. 8212;——————————————————————————-. Http:/ bitirainy.spaces.live.com/. Http:/ www.dbanotes.net/. 楼方鑫 dc.b.a. Http:/ www.anysql.net/. Http:/ roujiaweize.spaces.live.com/. 3月 12th, 201516:51.

hycz.wordpress.com

Cassandra 0.8.0流程分析（1）——CassandraDaemon启动流程 | Hycz's Blog

https://hycz.wordpress.com/2011/11/07/cassandradaemon_activate_process

Life is a game. Why so serious? Cassandra 0.8.0流程分析 1 CassandraDaemon启动流程. On November 7, 2011. Public static void main(String[] args) { new CassandraDaemon().activate(); }. 全名orgapache.cassandra.config.DatabaseDescriptor。 第2部分是建立各种system tables，这些系统表的配置是直接写在代码中的 hardcode ，而不是从配置中读取。 Persistent metadata for the local node，本节点的持久化元数据. Individual schema mutations，单个 schema改变. Current state of the schema，当前schema状态. Indexes that have been completed，已完成索引. NodeId and their metadat. Hardcoded system tables KS...

anysql.net

AnySQL.net » Blog Archive » orastats & mysqlstats通用监控工具

http://www.anysql.net/tools/oracle-mysql-stats-perf-tool.html

Orastats & mysqlstats通用监控工具. Raquo; http:/ www.anysql.net/tools/oracle-mysql-stats-perf-tool.html. Select name, bytes from v$sgastat. Select name, value from v$sysstat. Select name, value from v$sga. Key {CURR DELTA} Label …. Query=select name, value from v$sga. Format=Fixed Size curr Fixed. Variable Size curr VarS. Database Buffers curr Data. D: MyTools x64 orastats parfile=orastats.txt. 2013-03-19 22:57:08 Fixed VarS Data. 2013-03-19 22:57:08 2174k 134m 134m. 2013-03-19 22:57:13 2174k 134m 134m.

anysql.net

AnySQL.net » DBA

http://www.anysql.net/category/dba

Step XX Done, Next XX.sql. SQL Server Express 2005. Oracle DBA By ……. Oracle 11G OLTP Compress支持的含义. ORA-30175: invalid type given for an argument. Internal error: ulconnect: OCIInitialize [1804]. 问题解答 — 如何得知一张表的纪录有变化? Oracle 10.2.0.3修复的一些Bug, 需要看看…. Linux裸设备在Oracle 10.2.0.2版本中要过时了. DBA notes (Web 2.0). Eagle's fan (eBay DBA). Orastats & mysqlstats通用监控工具. HP-UX编译出错: Undeclared variable 'prepareSql'. Perhaps 'prepa. Hp-ux下编译提示 Error 203: "ociuldr.c", line 326 # Cannot assig. By Windows Vista Security.

anysql.net

AnySQL.net » 工具下载

http://www.anysql.net/download

Java版本Oracle SQL * Plus. DBA notes (Web 2.0). Eagle's fan (eBay DBA). Orastats & mysqlstats通用监控工具. HP-UX编译出错: Undeclared variable 'prepareSql'. Perhaps 'prepa. Hp-ux下编译提示 Error 203: "ociuldr.c", line 326 # Cannot assig. 修改了SELECT 的查询语句，发现 - DATADATE DATE, RCV DATE VARCHAR2(4. SQL*UnLoader: Fast Oracle Text Unloader (GZIP), Relea. 对了，环境是这样的，服务端HP-UX rx6600-2 B.11.31 U ia64 unlimited-user li. By Windows Vista Security.