ITPub博客

How to Install and Use iostat

oracle session trace

Sometimes we need to add new disk for existing server

这20个Docker Command

http://www.cnblogs.com/gomysql/p/3816031.html 一. MySQL 5.6引入了GTID的概念，那么GTID是何方神圣？其实也不复杂，就是一个全局事务标示符。使用GTID时，每次事务提交都会在binlog里生成1个唯一的标示符，它由UUID和事务ID组成。首次提交的事务ID为1，第二次为2，第三次为3，以此例推。uuid是服务器的身份ID，在第一

Check connection related issue of mysql

Sort_Buffer_Size 设置对服务器性能的影响

redis and sentinel configuration

5.5开始新增一个数据库：PERFORMANCE_SCHEMA，主要用于收集数据库服务器性能参数。并且库里表的存储引擎均为PERFORMANCE_SCHEMA，而用户是不能创建存储引擎为PERFORMANCE_SCHEMA的表。

Build mysql replication

Configure innodb 表空间

After mysql installation, we need to change the password of root as below

replacement_timeout https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/6/html/storage_administration_guide/iscsi-replacement-timeout   iSCSI Settings With dm-multipath https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/5/html/onlin...

create tablespace DATA datafile '+ORA_DATA' size 100M autoextend on;create user OWNER identified by **** default tablespace DATA temporary tablespace TEMP;create user USER identified by **** default tablespace DATA temporary tablespace TEMP;grant connect, resource to OWNER;grant crea...

Question:  I wan to modify the frequency that I take my AWR snapshots.  I understand that there is a utility that allows me to modify my AWR automatic snapshot settings.  Can you please advise me on how to modify this snapshot settings? Answer:&n...

http://heliosguneserol.com/2013/01/03/how-to-stopstart-rac-components/How to Stop/Start RAC componentsIn this article, I am going to explain how to stop/start rac components. Here is the my system:My db version : 11.2.0.3My Operating System : AIX 7.1My servers host...

CRS RESOURCE STATUS   srvctl status database -d<database-name> [-f] [-v] [-S <level>] srvctl status instance -d<database-name> -i <instance-name>>[,<instance-name-list>]  [-f] [-v] [-S <level>] srvctl status service -d<database-name> -s <service-name>[,<se...

1. Net Logging and Trace when it is oci driverhttp://docs.oracle.com/cd/A57673_01/DOC/net/doc/NWTR23/ch3trc.htmLoggingThe following parameters can be set to configure Oracle Net logging in sqlnet.ora: ParameterDescriptionLOG_D...

参考：http://www.infoq.com/cn/news/2013/11/introducing-nosqlhttp://www.cnblogs.com/sunli/archive/2011/01/24/nosql_or_relation.html 列式存储面向列的DBMS是这样一种数据库管理系统，它将数据表存储为数据列而非行的形式。从物理上来说，表是列的集合，每一列从本质上来说都是只有一个字段的表。这...

How to audit failed logon attemptsOracle Audit -- failed connectionBackground:In some situation DBA team wants to audit failed logon attempts when "unlock account"  requirement becomes frequently and user cannot figure out who from where is using incorrect password ...