Archive - DBAeyes

2023

April

April 13, 2023 » Notion

March

March 15, 2023 » Grafana

February

February 8, 2023 » New Year 2023

2022

December

December 13, 2022 » 2022-12-12

October

October 6, 2022 » CloudWatch Agent for Mem, Disk and App logs

September

September 3, 2022 » New in 2022

2021

April

April 8, 2021 » New in 2021

2018

November

November 13, 2018 » aphorism
November 12, 2018 » Double eleven Single Day
November 9, 2018 » 4 Years to now

2017

March

March 7, 2017 » 漫长的一段时间

2016

September

September 3, 2016 » Keep Writing

August

August 22, 2016 » new in Melbourne

June

June 6, 2016 » Jekylly Post

May

May 8, 2016 » 最近

April

April 6, 2016 » Australian English Glossary - Study

March

March 28, 2016 » 复活节
March 24, 2016 » Blog 迁移记

2015

March

March 11, 2015 » 什么心情
March 8, 2015 » 不可任性

February

February 26, 2015 » 坚持写blog 呗

2014

October

October 30, 2014 » 时间变化

July

July 15, 2014 » time_zone timestamp datetime in MySQL
July 15, 2014 » 世界杯 2014

June

June 24, 2014 » 身体健康
June 17, 2014 » 烧得不轻
June 15, 2014 » 巴西世界杯 2014
June 13, 2014 » 美食之行 -- 成都 outing
June 13, 2014 » Blog 跑起来

March

March 2, 2014 » 什么是自己的财富

January

January 6, 2014 » 我的2013

2013

November

November 20, 2013 » 静心
November 8, 2013 » MySQL从压缩文件恢复数据库

September

September 5, 2013 » Running

August

August 28, 2013 » 寄语在风中游荡在心中
August 26, 2013 » 快一年了

June

June 29, 2013 » 你乐观一点，可以不
June 9, 2013 » A sample of MySQL procedure -- 带判断条件

May

May 24, 2013 » 规律起来

April

April 27, 2013 » 买了点书

February

February 27, 2013 » MySQL lock info -- Waiting for table metadata lock

January

January 21, 2013 » MySQL error 1535 --table definition on master and slave does not match
January 21, 2013 » Airbnb coupon 2013 25$ off
January 20, 2013 » 不管怎么样写点东西
January 3, 2013 » bye-bye 2012, new in 2013

2012

November

November 1, 2012 » Iterm2 auto login 自动登录脚本

October

October 22, 2012 » breakdown caused by swap in MySQL
October 22, 2012 » Trouble shooting the high SYS CPU in MySQL server
October 21, 2012 » replace the "or" with "union all" in MySQL subquery
October 17, 2012 » 杭州西湖博览会国际烟花节
October 5, 2012 » The sequence of updated value in MySQL

September

September 30, 2012 » Holiday
September 29, 2012 » How to do with the duplicated data in MySQL
September 29, 2012 » something was changed in my work
September 28, 2012 » Yeah!!!
September 26, 2012 » 忙傻掉了呗
September 19, 2012 » MySQL覆盖索引 LIKE优化
September 14, 2012 » 不能说忙
September 13, 2012 » command: nc
September 13, 2012 » mysql逻辑备份完成备库搭建
September 8, 2012 » Hello world!

2011

March

March 29, 2011 » Oracle degree 小点
March 16, 2011 » 瞎忙
March 14, 2011 » 锻炼身体
March 14, 2011 » Mysql日期和时间函数
March 13, 2011 » 早起早睡

February

February 24, 2011 » mysql int 长度

January

January 26, 2011 » mysql select into outfile
January 18, 2011 » 最近很少发博
January 12, 2011 » linux if命令
January 5, 2011 » Win7清除程序的最近打开记录
January 2, 2011 » 结婚3周年
January 1, 2011 » 展望2011

2010

November

November 23, 2010 » MySQL：MySQL日期数据类型、MySQL时间类型使用总结
November 5, 2010 » 天气刚刚好

September

September 28, 2010 » 上善若水
September 11, 2010 » 手抖了一下差点买了奔驰 Smart

August

August 31, 2010 » MYSQL拆表用存储过程
August 30, 2010 » Oracle 10g的闪回查询概述
August 9, 2010 » mysql 使用临时表+存储过程删除大表中的大量数据

July

July 1, 2010 » 三亚 outing

June

June 30, 2010 » Launchy & AutoHotKey 大大提高工作效率的两个免费软件
June 16, 2010 » 保时捷之旅5
June 10, 2010 » 关于MySql explain 中的ID

May

May 19, 2010 » mysql limit 扫描行数 & order by 与索引关系
May 12, 2010 » MYSQL index 锁的一点情况
May 8, 2010 » sql 分页

April

April 28, 2010 » MySQL的 explain
April 26, 2010 » MYSQL 取随机数 random
April 10, 2010 » 可爱的小家伙

March

March 30, 2010 » mysql float double 类型
March 27, 2010 » 最近都在忙啥
March 25, 2010 » watch list
March 8, 2010 » 心境
March 8, 2010 » 天气
March 7, 2010 » 乐天

February

February 24, 2010 » ORACCLE 临时表
February 14, 2010 » 虎年
February 12, 2010 » 要过年了
February 12, 2010 » 小逛MZD 4S店
February 11, 2010 » perl学习笔记 --zt

January

January 29, 2010 » 通过bulk collect减少loop处理的开销
January 25, 2010 » 我的2010
January 23, 2010 » QQ赚钱--厉害财付通充值--麻烦
January 17, 2010 » 牙疼
January 9, 2010 » N73 拆解

2009

December

December 29, 2009 » v$sql_bind_capture 获取绑定变量
December 28, 2009 » LINUX TAR
December 25, 2009 » Oracle Index Internals (zt)
December 24, 2009 » 电烙铁
December 20, 2009 » 房子晃动了
December 19, 2009 » 淘宝评价体系的一点看法
December 18, 2009 » mysql 分页小测
December 10, 2009 » mysql set names
December 8, 2009 » rownum max 谁先谁后
December 7, 2009 » 游泳
December 6, 2009 » 6种心态

November

November 10, 2009 » 我恨阴井盖

October

October 29, 2009 » 时间
October 28, 2009 » 调整sequence大小之脚本
October 26, 2009 » 2009 西博车展
October 18, 2009 » windows 7 兼容性相当不错

September

September 28, 2009 » MySQL的转义字符“\”
September 25, 2009 » MYSQL 存储过程
September 13, 2009 » 摄影知识简单记录+累积
September 6, 2009 » 买了单反 D90 kit
September 2, 2009 » 考虑买个单反
September 1, 2009 » 查看是否还在使用特定的索引或者sql
September 1, 2009 » 又是一个不眠夜

August

August 27, 2009 » 对大表的快速复制

July

July 28, 2009 » 人的能量需要释放
July 24, 2009 » 几百年一次的事情
July 19, 2009 » 生活真的在改变
July 10, 2009 » PL/SQL developer几个设置
July 10, 2009 » GRID 漂移
July 8, 2009 » 滨江新生活
July 6, 2009 » 这些天

June

June 29, 2009 » MYSQL 排序索引小测
June 24, 2009 » 变形金刚2 卷土重来
June 24, 2009 » dbms_xplan.display_cursor 获取执行过的sql的执行计划
June 22, 2009 » Hope is a good thing!
June 22, 2009 » 单一索引和联合索引简单测试
June 16, 2009 » oracle的一些字符转义
June 15, 2009 » MySQL导入导出方法与工具 (zt)
June 12, 2009 » Oracle start with...connect by prior 子句用法 (zt)
June 8, 2009 » Exchanging Partitions 小测
June 5, 2009 » insert append vs. create table as
June 3, 2009 » 建主键唯一索引非唯一索引

May

May 25, 2009 » 车这么些天
May 25, 2009 » imp -- commit array insert
May 14, 2009 » 第一天开车上班
May 13, 2009 » 小马到家了
May 7, 2009 » 用SQL完成对比
May 5, 2009 » 这个五一
May 4, 2009 » 数字、字符、日期类型的长度

April

April 30, 2009 » 近来学习的太少
April 30, 2009 » MYSQL 一点一点来
April 26, 2009 » 再一次刷机-- 等待DB
April 22, 2009 » mysql 开始
April 20, 2009 » 又到谷雨
April 16, 2009 » 系统自动产生的临时段
April 15, 2009 » CBO体系结构
April 15, 2009 » 健身行动
April 13, 2009 » 初始化数据
April 7, 2009 » 试驾小记
April 3, 2009 » 足球

March

March 31, 2009 » 随想
March 26, 2009 » 挤啊挤啊挤公交
March 24, 2009 » 根据rowid建临时表更新大表数据
March 15, 2009 » 又是一个不眠之夜
March 8, 2009 » 今天出太阳了
March 6, 2009 » 监控表的DML操作

February

February 24, 2009 » 吼一声
February 23, 2009 » Oracle 10.2.0.1.0 upgrade 10.2.0.4.0
February 23, 2009 » ora-01031 sqlplus /as sysdba
February 23, 2009 » 表空间管理
February 21, 2009 » 最近
February 13, 2009 » 触发器迁移数据
February 2, 2009 » 根据extend初始化数据
February 2, 2009 » 根据ID初始化数据

January

January 28, 2009 » 游戏？老了？
January 21, 2009 » 每天的上班路线惊讶！
January 20, 2009 » QQ又被屏蔽了
January 20, 2009 » metalink上对直方图的介绍
January 14, 2009 » 惊遇小偷
January 12, 2009 » oracle 的两个替换函数 REPLACE TRANSLATE
January 7, 2009 » Wish list - 2009
January 1, 2009 » 2009年的第一天

2008

December

November

November 25, 2008 » oracle 索引和逻辑读小测
November 24, 2008 » 百年淘宝
November 16, 2008 » 新的开始 O(∩_∩)O
November 14, 2008 » 统计信息的管理
November 14, 2008 » 使用物化视图刷表
November 10, 2008 » Linux操作系统下/etc/hosts文件配置方法 (zt)
November 7, 2008 » SecureCRT好用的设置 (zt)

October

October 23, 2008 » Oracle Hint 的重要性
October 22, 2008 » 小鱼真好
October 12, 2008 » 晚上工作的时间有点长
October 12, 2008 » crontab
October 8, 2008 » 晚上工作下
October 6, 2008 » 十一长假结束了辛苦滴

September

September 24, 2008 » linux 后台运行sql脚本
September 18, 2008 » EXP IMP 顺序
September 17, 2008 » 使用bulk collect limit处理大量数据
September 14, 2008 » 中秋小记
September 12, 2008 » 使用bulk collect实现cursor 批量fetch！
September 12, 2008 » 根据rowid 并行执行
September 12, 2008 » file_id 和 relative_fno二者的关系
September 10, 2008 » linux scp
September 8, 2008 » WEB分页与优化技术
September 3, 2008 » 旺仔牛奶
September 2, 2008 » CBO
September 1, 2008 » 在线建约束 Create constraint online

August

August 24, 2008 » 奥运会结束新的工作开始
August 20, 2008 » 看大牛们聊天
August 5, 2008 » 跟踪优化 SQL
August 4, 2008 » 索引成本计算

July

July 28, 2008 » 签了聘用意向书
July 28, 2008 » 成就DBA职业生涯 -- 转
July 24, 2008 » 窃喜一下
July 24, 2008 » EXP-00091
July 23, 2008 » 查询Top sql
July 23, 2008 » SQLPLUS 操作大全 -zt
July 23, 2008 » 基于CBO的oracle优化法则
July 17, 2008 » ORACLE EXPLAIN PLAN的总结
July 17, 2008 » alter index rebuild & alter index rebuild online
July 16, 2008 » Oracle 10046 event
July 16, 2008 » switch logfile VS archive log current
July 15, 2008 » 石膏板原来可以这样重！！！
July 14, 2008 » 挣扎了两天 oracle dataguard
July 13, 2008 » standby 管理和维护
July 12, 2008 » 全库导入的一般步骤
July 12, 2008 » RMAN 复制数据库
July 12, 2008 » Ora-12514
July 11, 2008 » 10046 event trace
July 8, 2008 » 开工了买建材了
July 6, 2008 » 装修即将开工
July 4, 2008 » EXPDP和IMPDP使用说明
July 1, 2008 » 又是一个月的开始

June

June 24, 2008 » Oracle10G Physical Standby Database笔记
June 21, 2008 » 通过oracle 1z043
June 18, 2008 » FireFox3 插件&不断增加
June 16, 2008 » Bought two Oracle Book from China-Pub
June 14, 2008 » OCP 培训第五天
June 13, 2008 » OCP 培训第四天
June 12, 2008 » OCP 培训第三天
June 12, 2008 » 住的辛苦
June 11, 2008 » OCP 培训第二天
June 10, 2008 » OCP 培训第一天
June 10, 2008 » 初到上海

May

May 28, 2008 » 稍息休息
May 26, 2008 » 再次感受去趟市区不容易
May 24, 2008 » 还是开车比较好
May 22, 2008 » Oracle University 培训考试
May 19, 2008 » 默哀
May 18, 2008 » 近来比较忙
May 10, 2008 » 滨江的房子贵租房更贵

April

April 29, 2008 » 熬夜了
April 14, 2008 » Game Time
April 13, 2008 » 10g Admin Workshop II Student Guide II
April 10, 2008 » 球赛！绿城 ---- 三连败
April 1, 2008 » 偶的新电脑
April 1, 2008 » 10g Admin Workshop II - 4 - Recovering from Noncritical Losses

March

March 25, 2008 » 10g Admin Workshop II - 1 - Introduction
March 24, 2008 » 打算新整一台自己用的台式机
March 22, 2008 » 窃喜一下通过1z0-042
March 17, 2008 » 世界兄弟周
March 7, 2008 » 呵呵继续++
March 3, 2008 » 难得上海行

February

February 24, 2008 » 爬山and超级懒觉
February 14, 2008 » SG I: Chapter 6 | User Administration and Security
February 12, 2008 » 新春佳节 338天后再见
February 4, 2008 » 数码摄影易学易用30招

January

January 30, 2008 » 纽约摄影学院教程学习记录
January 24, 2008 » 继续努力 ^_^
January 20, 2008 » 忙碌的星期天
January 19, 2008 » 视频修饰
January 18, 2008 » 云南行~第一天~昆明
January 15, 2008 » 云南行~第六天~昆明
January 15, 2008 » 云南行~第五天~石林
January 15, 2008 » 云南行~第四天~大理
January 15, 2008 » 云南行~第三天~丽江
January 15, 2008 » 云南行~第二天~前往丽江，途经大理
January 7, 2008 » 回顾2007 展望2008
January 3, 2008 » 家已成业未立
January 1, 2008 » 新年快乐

2007

December

December 21, 2007 » 整理
December 18, 2007 » 看望大学室友的宝宝
December 17, 2007 » 承担责任
December 16, 2007 » 头晕
December 10, 2007 » 今年的朋友都得了千金
December 7, 2007 » 什么是生活
December 5, 2007 » DV出手了
December 4, 2007 » SG I: Chapter 2 | Creating and Controlling a Database
December 4, 2007 » 今天看了关于DV的一些信息
December 3, 2007 » 忙了两天关于结婚的事

November

November 30, 2007 » 又被骚扰了
November 28, 2007 » Oracle Synonym --- fell embarrassedly -_-!!
November 27, 2007 » Start the Oracle 10g Student Guide I
November 17, 2007 » 五星饭店
November 15, 2007 » 交换机双光纤冗余
November 11, 2007 » 累啊
November 11, 2007 » 打扫了一天
November 5, 2007 » Naming Method

October

October 24, 2007 » 半夜被骚扰了
October 20, 2007 » 西博车展
October 17, 2007 » Union、Union All一些概念
October 17, 2007 » English study
October 15, 2007 » N73刷机
October 14, 2007 » 偷了个大懒，好久没上blog了

September

September 27, 2007 » 空间访问量过1000
September 27, 2007 » 近来比较忙
September 19, 2007 » 不断增加的脚本
September 17, 2007 » 猛的－－朝鮮女足
September 13, 2007 » 我的网络相册
September 13, 2007 » 女足世界杯
September 10, 2007 » Do not leave any question
September 9, 2007 » 耳机工包？
September 9, 2007 » 电子信息展
September 7, 2007 » 今天的三件事
September 5, 2007 » 中华英才网

August

August 28, 2007 » 老朋友喜得千金
August 25, 2007 » 买个手表都这么难？
August 24, 2007 » 再看oracle的学习
August 22, 2007 » 今天跷课了
August 22, 2007 » 阿里巴巴公司DBA笔试题－－答案
August 22, 2007 » 阿里巴巴公司DBA笔试题－－转
August 20, 2007 » 晨练－－继续
August 17, 2007 » 真的去晨跑了
August 16, 2007 » 小鱼正式跨入本本一族＋我的计划
August 16, 2007 » Oralce性能调整的顺序
August 15, 2007 » 我家的小鱼
August 14, 2007 » 测试分区和信息统计对性能的影响
August 14, 2007 » 终于把新浪blog搬过来了
August 13, 2007 » 书的诱惑
August 13, 2007 » ORA-00257 archive log 故障解决过程
August 13, 2007 » Oracle Undo的学习
August 13, 2007 » 手工建库 EM启动问题
August 13, 2007 » sqlplus env setting 环境变量设置
August 12, 2007 » ORACLE 数据库名、实例名、ORACLE_SID
August 9, 2007 » 鱼儿开车

April

April 17, 2007 » 超频 G31M + Intel E2180

March

March 26, 2007 » 10g Admin Workshop II - 2 - Configuring Recovery Manager
March 7, 2007 » 10g Admin Workshop II - 5 - Database Recovery

February

February 17, 2007 » 你需要记住一些细节

January

January 12, 2007 » DOS命令带权限的拷贝文件