- 博客(13)
- 资源 (343)
- 收藏
- 关注
原创 统计MySQL binlog中的DML语句
MASTER@root@test 07:44:52>create table tab02(id int(10) primary key,name varchar(20));Query OK, 0 rows affected (0.10 sec)MASTER@root@test 08:34:54>MASTER@root@test 08:34:54>MASTER@root@test 08:3
2014-01-31 20:38:15 1449
原创 MySQL复制环境中使用slave_exec_mod参数
先看下slave_exec_mod官方描述Command-Line Format--slave-exec-mode=modeOption-File Formatslave_exec_modeSystem Variable Nameslave_exec_modeVariable S
2014-01-31 19:23:40 2882
原创 MySQL禁用binlog中的语句
MySQL复制是异步的,也就是说是非同步的过程,它不会校验数据库中数据的一致性,只要SQL语法正确并且没有错误就能成功执行MASTER@root@test 12:20:40>create table tab01 -> (id int(10) primary key , -> name varchar(20));Query OK, 0 rows affected (0.03 s
2014-01-30 12:29:29 3361
原创 MySQL配置Master-Slave
master库打开log-bin参数,保证master和slave的server-id参数不同在master上创建允许slave访问的rep用户MASTER@root@(none) 12:34:34>grant replication slave on *.* to 'rep'@'192.168.1.12' identified by 'rep';Query OK, 0 rows aff
2014-01-30 00:54:52 1043
原创 Oracle system系统表空间和数据表空间的insert性能测试
SQL> show user USER is "ZHONGWC"SQL> SQL> select * from v$version;BANNER----------------------------------------------------------
2014-01-23 16:53:17 1288
转载 Master Note for Automatic Storage Management (ASM) (Doc ID 1187723.1)
Automatic Storage Management (ASM) Alerts: Alert: Querying v$asm_file Gives ORA-15196 After ASM Was Upgraded From 10gR2 To 11gR2 (Doc ID 1145365.1) Automatic Storage Management (ASM) Concep
2014-01-19 18:36:08 2754
原创 Extracting Datafile Blocks From ASM
查看数据存放的file#和block#[oracle@db11g ~]$ sqlplus zwcSQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 16 14:02:27 2014Copyright (c) 1982, 2013, Oracle. All rights reserved.Enter password: Conn
2014-01-16 13:57:35 128
原创 RHEL5使用multipath配置ASMdisk
fdisk查看磁盘[root@db11g ~]# cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.9 (Tikanga)[root@db11g ~]# [root@db11g ~]# [root@db11g ~]# fdisk -lDisk /dev/sda: 32.2 GB, 3221225472
2014-01-15 13:17:30 3493
原创 Solaris11配置静态IP
Oracle Solaris11安装好默认是DHCP的,禁用DHCP。netadm enable -p ncp DefaultFixed设置net0(公网)、net1(私网)和网关ipadm create-ip net0ipadm create-addr -T static -a 192.168.1.61/24 net0/v4staticroute -p add default
2014-01-13 16:57:52 4513
原创 Solaris11添加swap方法
查看当前swap大小,是2Groot@vzwc1:~# zfs listNAME USED AVAIL REFER MOUNTPOINTrpool 8.68G 40.0G 4.90M /rpoolrpool/ROOT 4.03G 40.0G 31K
2014-01-13 16:29:36 3153 1
原创 Solaris11配置Oracle RAC ASMDisk 以及运行root.sh注意事项
root@vzwc1:~# isainfo -namd64root@vzwc1:~# unameSunOSroot@vzwc1:~# cat /etc/release Oracle Solaris 11.1 X86 Copyright (c) 1983, 2012, Oracle and/or its affiliates.
2014-01-11 22:30:58 3868
原创 GreenPlum改变表的分布策略
创建一张表,在没有primary key 或者 unique key 的情况下,GreenPlum默认会把第一个column作为分布键zwcdb=# create table tab01(id int,name varchar(20));NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'id'
2014-01-08 22:59:36 5228
原创 ORA-01578 ORA-01110 坏块解决方法
一个案例,查看跟踪文件发现如下错误信息d:\oracle\product\10.2.0\admin\dbserver\udump\orcl_ora_5888.trcCorrupt block relative dba: 0x09848269 (file 38, block 295529)Bad header found during buffer readData in bad
2014-01-03 22:18:55 7334 1
Expert_Oracle_Database_Architecture_Oracle_Database_9i,_10g,_and_11g_Programming_Techniques_and_Solu.rar
2011-01-09
Linux 下手工创建Oracle Database.rar
2010-12-30
Expert.Oracle.Database.Architecture.9i.and.10g.Programming
2011-01-24
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人