了解Maclean Liu@诗檀软件

 askMaclean 技术博客文章入口:http://www.askmaclean.com/archives/author/admin

 

诗檀软件Maclean开办的免费ORACLE 技术学习QQ群号: 318952819

 

 

AskMaclean  网站地图


MAR_8473Maclean Liu 中文名:刘相兵

商务合作电话: +86 13764045638

技术咨询邮箱: service@parnassusdata.com

所在企业:诗檀软件 www.parnassusdata.com

个人技术博客地址:http://www.askmaclean.com

 

 

 

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

 

诗檀软件专业数据库修复团队

 

服务热线 : 400-690-3643   备用电话: 18501767907    邮箱:service@parnassusdata.com

 

ORACLE PRM是诗檀软件独立研发的ORACLE数据库灾难恢复软件,其具有全程图形化界面、简单高效等特点。

欢迎下载使用ORACLE PRM。 下载地址:http://parnassusdata.com/sites/default/files/ParnassusData_PRMForOracle_3206.zip

PRM用户使用手册。http://www.parnassusdata.com/sites/default/files/ParnassusData%20Recovery%20Manager%20For%20Oracle%20Database%E7%94%A8%E6%88%B7%E6%89%8B%E5%86%8C%20v0.3.pdf

 

 

诗檀软件PRM

刘相兵(Maclean Liu):

 

Maclean Liu, 诗檀(上海)软件系统有限公司(ParnassusData Software , Inc.) 联合创始人,联系诗檀软件。

 

同时Maclean也是上海Oracle用户组(Shanghai Oracle Users Group)的创始人之一。

 

 

拥有8年数据库领域从业经验,目前在甲骨文公司中国上海工作,离开Oracle甲骨文中国后创建了诗檀软件公司(ParnassusData Software) 。

所服务的行业包括电信运营商、通讯设备制造商、银行、金融业等。

 

主要客户包括:

工商银行、中国银行、交通银行、外汇交易中心、中国人寿保险、浦发银行、上海银行、人民银行、银联数据、银商资讯、太平人寿保险

上海电信、上海联通、上海移动、浙江电信、湖北电信、湖北联通、湖北移动、江苏移动、德邦物流、东方航空

 

 

Maclean Liu对研究Oracle 内部原理、新特性、高可用和性能调优饶有兴趣,同时撰写了大量Oracle数据库技术相关的专题文章。

 

Maclean Liu愿意通过网络同大家分享Oracle知识和经验,也愿意在能力范围能帮助大家解决实际工作中遇到的问题。

 

视角不同,不一样的Oracle!

 

Maclean Liu 的Timeline :

 

askmaclean blogoracle

 

 

 

oracle ace4 oracle_ace3

oracle_ace2

专题 标题 地址
Oracle性能调优 【视频教学:性能优化】Maclean Liu的Oracle性能优化讲座第一回《真正读懂Oracle SQL执行计划》 http://www.askmaclean.com/archives/read-sql-execution-plan.html
【技术分享】开Oracle调优鹰眼,深入理解AWR性能报告  第一讲 http://www.askmaclean.com/archives/awr-hawk-eyes-training.html
【技术分享】开Oracle调优鹰眼,深入理解AWR性能报告  第二讲 http://www.askmaclean.com/archives/awr-tuning-hawk-eyes.html
【AskMaclean技术分享Oracle数据库优化】AWR鹰眼系列AWR报告全面指标分析 http://www.askmaclean.com/archives/awr-tuning-doc.html
【Maclean Liu技术分享】拨开Oracle优化器迷雾探究Histogram之秘 http://t.askmaclean.com/thread-2172-1-1.html
Maclean讲SQL调优精要 http://t.askmaclean.com/thread-2702-1-1.html
Maclean技术分享Oracle数据库优化经验- ADDM DBA http://t.askmaclean.com/thread-2607-1-1.html
Maclean教你读Oracle 10046 SQL TRACE http://www.askmaclean.com/archives/maclean-10046-sql-trace.html
Maclean教你读SQL TRACE TKProf报告 http://www.askmaclean.com/archives/maclean-tech-tkprof-10046.html
Maclean博客Oracle SQL性能优化专题 https://blogs.oracle.com/askmaclean/entry/oracle_sql%E6%80%A7%E8%83%BD%E4%BC%98%E5%8C%96%E4%B8%93%E9%A2%98
Oracle基础学习篇 Maclean的Oracle基础学习攻略 http://t.askmaclean.com/thread-2699-1-1.html
【仍在连载中】maclean liu的oracle学习经历 http://t.askmaclean.com/thread-1485-1-1.html
【Maclean技术分享】学习甲骨文数据库的自由之翼 http://t.askmaclean.com/thread-2560-1-1.html
Oracle学前Unix/Linux基础 http://train.askmaclean.com/node/35
新来的去学习Oracle前的准备知识 做题目,做完给出成绩 http://train.askmaclean.com/node/5 
【AskMaclean技术分享】Oracle dba必须的技能列表 http://t.askmaclean.com/thread-3256-1-1.html
【技术分享】DBA十大核心竞争力 基于Oracle TRACE的故障诊断 http://t.askmaclean.com/thread-2347-1-1.html
RAC安装篇 Maclean教你用Vbox安装 10g/11g RAC cluster 信息汇总贴 http://t.askmaclean.com/thread-2067-1-1.html
【Maclean Liu技术分享】12c 12.1.0.1 RAC安装教学视频  基于Vbox+Oracle Linux 5.7 http://t.askmaclean.com/thread-2667-1-1.html
 [视频教学]Maclean教你用Vbox在Enterprise Linux 5安装Oracle 10gR2 RAC 10g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-891-1-1.html
【视频教学】Maclean教你用Vbox在Linux 5安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-1061-1-1.html
【视频教学】Maclean教你用Vbox在Linux 6.3上安装Oracle 11gR2 RAC 11g RAC按照这个装不会有任何问题 http://t.askmaclean.com/thread-2007-1-1.html
DataGuard Standby篇 【Maclean Liu视频技术分享】11g ocm考纲复习Active Data Guard http://t.askmaclean.com/thread-2530-1-1.html
11g/12c新特性 升级到11g 必备工具:一张列表帮助你摆脱升级11gR2带来的烦恼 http://t.askmaclean.com/thread-1642-1-1.html
Maclean 研究12c新特性篇,Oracle Database 12c新特性汇总页面 https://blogs.oracle.com/askmaclean/entry/oracle_database_12c%E6%96%B0%E7%89%B9%E6%80%A7
other Maclean 的Oracle数据恢复专题 https://blogs.oracle.com/askmaclean/entry/oracle%E6%95%B0%E6%8D%AE%E6%81%A2%E5%A4%8D%E4%B8%93%E9%A2%98
关于Maclean 个人的介绍 http://www.askmaclean.com/know-maclean-liu
https://blogs.oracle.com/askmaclean/
以上部分视频的下载地址 https://www.box.com/s/ckrhvr9dklejbm9dgstl

 

Oracle (OTN) Discussion Forum User Profile:https://community.oracle.com/people/LiuMaclean(%E5%88%98%E7%9B%B8%E5%85%B5)

微博 : http://weibo.com/liumaclean

He is very influential person in Oracle Database community in China and Asia-Pacific. He would like to answer Questions Posted on both OTN and other Oracle Forum, till now he had answered about 4000 Oracle Database Questions on internet.

  1. Maclean has been very active with the community and setup a Q&A section on his blog, amazingly 4000+ Oracle RDBMS questions had been answered by him.
  2. Maclean published several introduction videos about Oracle technology to the internet and they are widely watched by Chinese audience.
  3. Active Shanghai Oracle User Group field activities participant and organizer.
  4. A qualified evangelist for Oracle 12c and Exadata products.
  5. Have a special passion on Oracle database related products, eager to share his Oracle knowledge with the community every day.

 

Oracle 相关博客: http://www.askmaclean.com/Ask Maclean Oracle 技术论坛http://t.askmaclean.com/  超过2200名邀请会员
发表的白皮书或专题 《深入理解Oracle SQL执行计划》中文http://t.askmaclean.com/forum.php?mod=attachment&aid=MjQ4MnxmMjYzODY1MXwxMzk4Nzc2MjAxfDF8MzIzNw%3D%3D《Oracle Histogram直方图的秘密》in Chinesehttp://www.slideshare.net/liumaclean/maclean-liuoracle-cbohistogram-0321《Oracle Database tuning: Hawk Eyes on AWR I》http://t.askmaclean.com/forum.php?mod=attachment&aid=MTU2M3w0MWUwMGM4NXwxMzg0MDAyNzUzfDJ8MjA4Ng%3D%3D《Oracle Database tuning: Hawk Eyes on AWR II》http://t.askmaclean.com/forum.php?mod=attachment&aid=MTczMnwwZjBhY2M0YXwxMzg0MDAyMzgyfDJ8MjIzOQ%3D%3D《Know more about Oracle Latch from 9i》http://www.askmaclean.com/archives/oracle-latch.html《Oracle Database 12c New Features》http://www.askmaclean.com/archives/12c-new-feature-summary.html《know more about Oracle Mutex》http://www.slideshare.net/liumaclean/maclean-liuoraclemutex

《Oracle Background Process SMON: Something you don’t know》http://www.slideshare.net/liumaclean/smon

《Essential oracle security internal for dba》 http://www.slideshare.net/liumaclean/essential-oracle-security-internal-for-dba-13569701

《Oracle SQL tuning Essentials》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjA5N3w0Yjk5ZmQwZXwxMzczODgyNDQyfDJ8MjcwMg%3D%3D

《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D

《Know more about Enqueue Deadlock Detection》http://www.askmaclean.com/archives/know-more-about-enqueue-deadlock-detection.html

《MINSCN AND Cache Fusion Read Consistent》http://www.askmaclean.com/archives/minscn%E4%B8%8Ecache-fusion-read-consistent.html

《Index Cluster factor can slowdown your delete》

Who pulls the background process dbwr’s trigger? http://www.askmaclean.com/archives/who-pulls-the-background-process-dbwrs-trigger.html

《Oracle AWR Statistics Explained》

《Something About RAC Brain Split》http://www.slideshare.net/liumaclean/oracle-rac-brain-split-resolution

《11g New Feature: Online Hot Patching》http://www.slideshare.net/liumaclean/11g-online-patching

《Know more about Oracle Critical Patch Update》http://www.slideshare.net/liumaclean/oracle-critical-patch-update

 

 

网络会议与视频分享

  1. 《How to Learn Oracle Database: Wings of liberty》http://www.tudou.com/programs/view/46S4t6wwaQw/
  2. 《Install 11gR2 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/xAOpQowNlU0/
  3. 《Install 10gR2 RAC Using VirtualBox Best Practice》http://t.askmaclean.com/thread-891-1-1.html
  4. 《Install 12.1.0.1 RAC Using VirtualBox Best Practice》http://www.tudou.com/programs/view/rPYR4H6GKZ8/?bid=03&pid=02&resourceId=78129035_03_05_02
  5. 《Oracle Database tuning: Hawk Eyes on AWR I》 http://www.tudou.com/programs/view/Dp_YYjvX-KM/
  6. 《Oracle Database tuning: Hawk Eyes on AWR I》http://www.tudou.com/programs/view/ORRvMVNLKaU/
  7. 《Oracle数据库的保护之手》  http://v.youku.com/v_show/id_XODc3MDIwOTQ0.html

会议演讲

  1. SHOUG Forum COLLABORATE 14: 《Oracle Database 12c New Feature:Information Lifecycle Management ILM and Storage Enhancements》  http://www.askmaclean.com/archives/12c-ilm.html
  2. SHOUG Forum COLLABORATE 13 : 《Oracle Database 12c New Feature:12c Pluggable Database Container Database》  http://www.askmaclean.com/archives/pluggable-container-db-12c.html
  3. Orcl-Con 2014 :http://f.shoug.info/?/question/16    《oracle数据库的保护之手》
  4. Oracle ACS 技术研讨会: 《Oracle Tuning: An ADDM DBA》http://t.askmaclean.com/forum.php?mod=attachment&aid=MjAyNHxhNzYxNTU2YXwxMzcyMDYzNTY0fDJ8MjYwNw%3D%3D

 

来读一读 Maclean Liu 发表的一些文章吧!

 

Slide:Oracle数据库升级前必要的准备工作
Slide:11g新特性-在线实施补丁online patching

Slide:了解Oracle critical patch update

Slide:配置Oracle 10g双向流复制

Slide:深入了解Oracle自动内存管理ASMM by Maclean Liu

Slide:了解真实的Oracle Unbreakable Database Appliance

Slide:配置GoldenGate同步DDL语句
Slide:如何安装Oracle one-off 临时小补丁及注意事项 by Maclean.liu

Slide:Upgrade 11.2.0.1 RAC DB/RDBMS to 11.2.0.2 in Linux By Maclean

Slide:Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux

了解Oracle RAC Brain Split Resolution
Probe how does your PGA consume

Does Rman Backup benefit from Large Pool?
Oracle Enterprise Manager Cloud Control 12c(12.1) OMS&Agent安装图文指南

还原真实的cache recovery

Oracle优化器:星型转换
深入理解Oracle Universal Installer (OUI)

Basic Oracle For Developer & Beginner
Startup Upgrade为我们做了什么?
11g新特性:Rolling Upgrade With Physical Standby
Duplicate standby database from active database

Examine 11g automatic block Corruption recovery
How to recover from root.sh on 11.2 Grid Infrastructure Failed
为10g RAC Cluster添加节点
11g新特性:Streams同步捕获
Convert your single instance to 10g RAC by manual

为Oracle Clusterware修改公用及私有网络接口
Discover Your Missed ASM Disks
GoldenGate实现Live Standby主备库切换
再议RAC Brain Split脑裂
一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
Oracle数据恢复:解决ORA-00600:[4000] ORA-00704: bootstrap process failure错误一例
CBO为什么不走索引?
何时会发生db file sequential read等待事件?
SQL调优:Clustering Factor影响数据删除速度一例
Oracle Internal Research深入研究Oracle内部原理
快速升级Oracle 11.2.0.2 RAC到11.2.0.3
Oracle中加速索引创建或重建的方法
手工模拟Oracle数据块逻辑讹误引发ORA-00600:[13013], [5001]一例
使用bbed解决ORA-01189错误
总结ORA-00600问题

 

 

文章列表

ORA-600篇:

Oracle内部错误:ORA-600:[4097]一例
Oracle内部错误:ORA-600[15801], [1]一例
Oracle内部错误:ORA-600:[6033]一例

Oracle内部错误:ORA-600[OSDEP_INTERNAL]一例

Oracle内部错误:ORA-600[kgskdecrstat1]一例

Oracle内部错误:ORA-600[kfioTranslateIO03]一例

Oracle内部错误ORA-600:[pfri.c: pfri8: plio mismatch ]一例

Oracle内部错误:ORA-600[2608]一例

Oracle内部错误:ORA-600[13013][5001]故障诊断一例

Oracle内部错误:ORA-600[17175]一例

Oracle内部错误ORA-600:[2667]一例

Oracle RAC内部错误:ORA-600[keltnfy-ldmInit]一例

ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [729], [10992], [SPACE LEAK] Example

手工模拟Oracle数据块逻辑讹误引发,ORA-600:[13013] [5001]一例

ORA-600
[4400][48]错误一例

ORA-600 [KCBZPB_1], [59033077], [4], [1], [] example

ORA-600:[qctcte1]内部错误一例

ORA-600
: internal error code, arguments: [15160]

ORA-600
: internal error code, arguments: [kdsgrp1] example

Oracle内部错误:ORA-600[25012]一例

ora-600
:[17281], [1001]一例

ORA-600
:[kclchkinteg_2]及[kjmsm_epc]内部错误一例

Oracle内部错误:ORA-600[kccchb_3]一例

ORA-600
: [qksrcBuildRwo]内部错误一例

ORA-600
:[32695], [hash aggregation can’t be done]错误一例

ORA-600
[6711]错误一例

ora-600
[kkocxj:pjpCtx]内部错误一例

ORA-600
[kcbz_check_objd_typ_3]错误一例

ORA-600
:[15570]内部错误一例

ORA-600
[3756]内部错误一例

ORA-600
[kddummy_blkchk]错误一例

How to trigger ORA-600,ORA-7445 by manual

ora-600 [17182]错误一例

Database Force open example

ora-600[qesmmCValStat4]一例

ORA-600 [kddummy_blkchk] [18038] 一例

Oracle内部错误:ORA-600[kgskdecrstat1]一例

famous summary stack trace from Oracle Version 8.1.7.4.0 Bug Note

Oracle内部错误ORA-600:[1112]

一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
ORA-600 quick reference guide
ORA-600[kglhdunp2_2]错误一例
ORA-600:[kclchkinteg_2]及[kjmsm_epc]内部错误一例
ORA-600: [7005], [192]内部错误一例
ORA-600 internal error[kqrfrpo]一例
ORA-600[4194]错误一例
How to trigger ORA-600,ORA-7445 by manual
ORA-600[kjpsod1]&ORA-44203错误一例

ORA-7445篇:


Oracle内部错误:ORA-7445[kcflfi()+466] [INT_DIVIDE_BY_ZERO]一例

ORA-7445: [__lwp_kill()+8] [SIGIOT]错误一例

Oracle内部错误ORA-7445:[_memcmp()+88] [SIGSEGV]一例

Oracle内部错误ORA-7445[kpopfr()+339] [SIGFPE]一例

ORA-7445:[SIGFPE] [Integer divide by zero]内部错误一例

Oracle内部错误ORA-7445: [ACCESS_VIOLATION] [unable_to_trans_pc][UNABLE_TO_READ]

ORA-7445 [SIGBUS] [Object specific hardware error]错误一例

PMON: TERMINATING INSTANCE DUE TO ERROR 600 on 8i

ora-7445 [kghalp+0500] [SIGSEGV]错误

11g新特性篇:


11g新特性:A useful View V$DIAG_INFO
11gR2新特性:LMHB Lock Manager Heart Beat后台进程
给11gR2 RAC添加LISTENER监听器并静态注册
11.2 中Oracle Cluster Registry(OCR)可选的存储设备
11.2.0.3 实例启动现在提供Large Pages Information大内存页信息了
Does Duplicate Target Database need Pre-existing DB backup?
11gR2新特性:STANDBY_MAX_DATA_DELAY
11g 新特性IGNORE_ROW_ON_DUPKEY_INDEX提示
11g新特性SQL执行计划管理(SQL Plan Management)
11g新特性-在线实施补丁online patching
11g新特性:Rolling Upgrade With Physical Standby
11g新特性-SQL PLUS 错误日志
11g新特性:Note raised when explain plan for create index
11g compression 新特性
11g新特性之闪回事务处理取消
11g新动态性能视图V$SQL_MONITOR,V$SQL_PLAN_MONITOR
11g默认审计选项
Examine 11g automatic block Corruption recovery
Duplicate standby database from active database
11g Database Installation flow
Setup Oracle Direct NFS Client
Recreate failovered primary database using Flashback Database
11g中的db_block_checking参数
11.2.0.2补丁集安装体验
Oracle 11g中数据库能有多大?
undo backup optimization does not work on 11.2.0.1?
11g新特性之IO校准(IO Calibration)
11g中AWR新快照视图
11g r2中对闪回数据归档的增强
11g Release 2 enhanced Tablespace Point In Time Recovery
11g新特性:Streams同步捕获
Applying online patch on 11gr2
How to recover from root.sh on 11.2 Grid Infrastructure Failed
Uninstall/Remove 11.2.0.2 Grid Infrastructure & Database in Linux
为11.2.0.2 Grid Infrastructure添加节点
Find password cracker in 11g
11g Multi-Column Correlation Stats and Dynamic Sampling
11g内存管理新特性的internal表现
Oracle database 11g release2发布
How to check and disable Adaptive Cursor Sharing in 11g
How does SGA/PGA allocate on 11g AMM?
crsctl status resource -t -init in 11.2.0.2 grid infrastructure
Learning 11g New Background Processes

Exadata篇

Oracle Exadata v2的价格
Exadata V2 Pricing
一次Exadata上的ORA-600[kjbmprlst:shadow]故障分析
Exadata Server Hardware Details
Exadata用户的困境
My Opinion On Exadata V2
Warning:Even Exadata has a wrong memlock setting
Oracle Exadata Database Recommended Patch (BP3) for Bug 10387939
Exadata Database Machine Host的操作系统OS版本
数据仓库:Oracle Exadata和Netezza的比较
Exadata Smart Flash Logging新特性
Database Appliance并非Mini版的Exadata-还原真实的Oracle Unbreakable Database Appliance
Oracle Sun Exadata V2 ,X2-2,X2-8 主要配置对比
Exadata X2-2 vs EMC Greenplum DCA vs Netezza TwinFin 12主要配置大对比
Booting Exadata!
I/O Resource Management with Exadata
Exadata. Are you ready?
Database Machine & Exadata Storage
Oracle Exadata Overview
Exadata and Database Machine 11.2
Exadata MAA Best Practices Series Using DBFS on Exadata (Use Cases and Performance Expectations)
Teradata to Exadata Migration Methodology
Exadata V2 Sun Oracle Database Machine
Updates on New Exadata Pricing & Packaging
Exadata MAA Best Practices Series Session:Exadata Backup and Recovery
Maximizing Database Application Performance with Flash and Solid State Disks (SSDs)
Extreme Performance with Oracle Data Warehousing

脚本Script篇:


Script:收集Enterprise Manager Grid Control/Agent/Database Control诊断信息
Script:收集Exadata诊断信息
Script:收集RAC诊断信息
Script:收集自动SGA内存管理ASMM诊断信息
Script:Collect vip resource Diagnostic Information
11g新特性:hangdiag.sql实例hang诊断脚本
Script:verify Oracle Object timestamp discrepancy
Script:SQL调优健康检查脚本
Script:列出本会话的细节信息
利用rowid分块实现非分区表的并行update与delete
Script:计算Oracle Streams进程所占用的内存大小
利用RMAN检测数据库坏块的脚本
Script:利用外部表实现SQL查询Oracle告警日志Alert.log
Script: 收集RAC DRM 诊断信息
Script:10g中不用EM显示Active Session Count by Wait Class
Script:数据库最近的性能度量
Script:收集数据库中用户的角色和表空间等信息
Script:收集介质恢复诊断信息
Script:收集Flashback Database Log诊断信息
Script:列出Oracle每小时的redo重做日志产生量
Script:收集11g Oracle实例IO性能信息
Script:检查数据库当前是否有备份操作在执行中
Script:List Schema/Table Constraints
Script:RAC Failover检验脚本loop.sh
Script:Diagnostic Resource Manager
Script:List Grid Control Jobs
Script:GridControl Repository Health Check
Script:诊断Scheduler信息
Script:优化crs_stat命令的输出
Script:Diagnostic Oracle Locks
Script:列出用户表空间的定额
Backup Script:Expdp Schema to ASM Storage
Script:Speed Up Large Index Create or Rebuild
Script:列出失效索引或索引分区
Script:列出数据库中5%以上链式行的表
Script:列出没有主键或唯一索引的表
Script:收集ASM诊断信息
Script:收集Oracle备份恢复信息
监控一个大事务的回滚
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
Script:partition table into rowid extent chunks
Script:Oracle EBS数据库初始化参数健康检查脚本
Script:Monitoring Memory and Swap Usage to Avoid A Solaris Hang
SQL脚本:监控当前重做日志文件使用情况
Streams Health Check on 10g Release 2
从视图查询表分区的相关信息
Script To Monitor RDBMS Session UGA and PGA Current And Maximum Usage Over Time
Script:收集RAC性能诊断信息
Script:收集UNDO诊断信息
Script:列出数据库中子表上没有对应索引的外键
Script: Listing Memory Used By All Sessions
Collecting Diagnostic Data for OCFS2 Issues
Script to Identify Objects and Amount of Blocks in the Buffer Pools – Default, Keep, Recycle, nK Cache
Script:Generate A DDL Script For A Table
SCRIPT TO CHECK FOR FOREIGN KEY LOCKING ISSUES
如何找出Oracle中需要或值得重建的索引
Script:Diagnostic ORA-01000 maximum open cursors exceeded
ORA-4030 PGA Usage Diagnostic Script
Script:Tune Very Large Hash Join
Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)
Script:List Buffer Cache Details
Script:List NLS Parameters and Timezone
Script:List SORT ACTIVITY
Script:List OBJECT DEPENDENT
Script:Logfile Switch Frequency Map
Script:Tablespace Report
Script:收集数据库安全风险评估信息
脚本:格式化的V$SQL_SHARED_CURSOR报告
脚本:监控并行进程状态
脚本:监控数据库中的活跃用户及其运行的SQL
脚本:监控临时表空间使用率
Script to show Active Distributed Transactions
Gather DBMS_STATS Default parameter
Script:Datafile Report
Script to Collect Data Guard Diagnostic Information
Script:To Report Information on Indexes
ORA-4031 Common Analysis/Diagnostic Scripts
Script:when transaction will finish rollback
Script: Computing Table Size
Script to Detect Tablespace Fragmentation
“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g
Script to Prevent Excessive Spill of Message From the Streams Buffer Queue To Disk
Oracle Systemstate dump analytic tool: ASS.AWK V1.09
SCRIPT TO GENERATE SQL*LOADER CONTROL FILE


升级与补丁Upgrade篇:

甲骨文发布2012 1月数据库安全补丁Critical Patch Update January 2012
Oracle数据库版本10.2实际进入扩展支持Extended Support周期
Patch Set Update and Critical Patch Update October 2011补丁更新发布了
11.2.0.3 Patch Set – List of Bug Fixes by Problem Type
快速升级Oracle 11.2.0.2 RAC到11.2.0.3
Upgrade GI/CRS 11.1.0.7 to 11.2.0.2. Rootupgrade.sh Hanging
Oracle补丁集的补丁号Patch ID/Number速查
Oracle 11gR2发布11.2.0.3 Patchset补丁集-又一重量级更新
Slide:11g新特性-在线实施补丁online patching
Slide:Oracle数据库升级前必要的准备工作
深入了解Oracle数据字典升级脚本catupgrd.sql调用过程
Slide:如何安装Oracle one-off 临时小补丁及注意事项 by Maclean.liu
Slide:了解Oracle critical patch update
Slide:Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Slide:Upgrade 11.2.0.1 RAC DB/RDBMS to 11.2.0.2 in Linux By Maclean
Upgrade 11.2.0.1 DB/RDBMS to 11.2.0.2 in Linux
Upgrade 11.2.0.1 GI/CRS to 11.2.0.2 in Linux
Applying 11G R2 GI PSU 11.2.0.2.3
Critical Patch Update July 2011 Released
了解Oracle Critical Patch Update
了解Oracle数据库的版本号
Pre-check while you are applying one-off patch
Advise on OS patch upgrade with RAC
Oracle Patch Set Update and Critical Patch Update April 2011 Released
11g新特性:Rolling Upgrade With Physical Standby
Patch your 10g Oracle database to PSU 10.2.0.4.5
7月最新发布10.2.0.4.5 Patch Set Update
Oracle Exadata Database Recommended Patch (BP3) for Bug 10387939
Startup Upgrade为我们做了什么?
深入理解Oracle Universal Installer (OUI)
Script to Collect DB Upgrade/Migrate Diagnostic Information (dbupgdiag.sql)
介绍dbms_registry PL/SQL程序包
Applying online patch on 11gr2
January 2011 Patch set Update发布
Advice on upgrading to 11.2.0.2 and converting to RAC
Oracle 9iR2 RAC to Oracle 10gR2 RAC Upgrade
Upgrading to Oracle Database 11g
如何确定所打Patch是否需要停机
Database Upgrade using Transportable Tablespaces
Upgrading to 11g–Why,How and Best Practices
Upgrade from Oracle Database 10g to 11g:What to Expect From the Optimizer
Upgrade to Oracle Database 11g: Single Instance to RAC & ASM
Applying Database PSU 10.2.0.4.6
Oct 12: Patch Set Update Released
Oracle Critical Patch Updates Unwrapped
11.2.0.2补丁集安装体验
Upgrading to RAC 11g R2 What you should know
Oracle 9i/10g/11g数据库升级路线图总览
OPatch工具相关的环境变量
使用OPATCH_DEBUG环境变量调试Opatch工具
opatch java.lang.OutOfMemoryError:Java heap space错误一例

 

加入我的Linkedin职业网络:

  1. 你好,非常喜欢你得论坛,我是一名oracle DBA初学者,现在从事DBA工作,还在成长阶段,你得博客内容给了我很大的帮助。谢谢
    我自己也弄了个网站:www.imshunzi.com 想跟你交换下友情链接。不知道可不可以,谢谢!

    • 你好,

      首先感谢你的关注。
      我很高兴和学习Oracle的朋友交换链接, 但是浏览了你的网站后发现绝大多数内容是转载的, 只要你拥有5篇 不论长短的原创文章,那么我随时愿意和您交换链接,谢谢!

  2. Hi ,

    你好,我去浏览了ACOUG的论坛,感觉挺有意思的,可是注册的时候发现各种问题。。比如说用户名不论输入什么都验证为长度不对,验证码永远刷不出来,邮箱总说格式不对。。 是不是你们的论坛出问题了?

    • ACOUG 的论坛是Kamus 同学在管理, 你可以在他的博客http://www.dbform.com/ 上找到他的联系方式。

  3. Hi, Maclean: I am so glad that I found your article so useful. Even though I have been working with Oracle products for over 15 years but your passionate work inspired me a lot. Only for 6 years, you got OCM. incredible!! I am kind lazy to update my OCP 9 to 11. I am a DBA in US for managing over 50 Oracle 11gR1/R2 clusters. I like be one of your followers regarding Oracle products.
    BTW, I like your honeymoon pictures and hope you have a wonderful and memorable honeymoon. What a beautiful couples. In somedays, I wish to see you at the Oracle Open world at SF.

    Best wishes,

    Mike

    • Hi Mike , you are welcome . OCM Exam is not easy , but the certification doesn’t really reflect someone’s skill or knowledge , I think certification is just cert , it doesn’t ensure someone can be qualified .

      I am glad to talk with anyone interested in oracle , and your comment is so pleasure .

      Nice to see you at OOW too.

  4. Hi, Maclean:
    Great to see your reply. You are a kind humble person. It is difficult to get the OCM as I know. There are not many OCM in the world.
    Thank you
    Mike

  5. Hi Maclean 您好!
    请问您的论坛注册邀请码该如何取得呢?
    谢谢!

  6. 客户端用户是本机USER用户,运行访问ORACLE的程序就提示“ORA-01019无法在用户方分配内存”,如果客户端给它本机ADMINISTRATOR用户,所有其他地方都不变,就能正常运行。
    ORACLE客户端装在C盘。给user用户完全控制C盘权限还是不行。user用户要设置哪里才能正常运行?

  7. Oracle SQL Developer 似乎无法导入xlsx文件,不知那个版本支持?

  8. 我想注册,可是需要邀请码,能发到我的邮箱吗?谢谢

  9. Dear Maclean :
    找文章時發現了您這網站,進入後驚為天人也獲益良多。
    跟您說一聲謝謝並致上敬意。
    Wen

  10. 嗨,你好,通过浏览你的网站,对我很有帮助,因此想注册你的论坛,能否给个邀请码?

  11. hi~刘大,我想注册论坛http://t.askmaclean.com/forum.php 账号,请送我一个邀请码,谢谢~~ 我的邮箱:puxuanxi@qq.com

  12. Hi,Maclean!可以给我一个邀请码吗?我很喜欢你的论坛。谢谢!

  13. HI, Maclean!我想进去论坛和其他会员互动和学习,请给我一个邀请码,邮箱是tsw1107@163.com , 谢谢!!

  14. Hi, Maclean,您好,我想进入您的论坛学习Oracle技术,是否可以给我发一个邀请码,我的邮件是wikiwei@qq.com,Thanks….

  15. Hi, Maclean,您好,我想进入您的论坛学习Oracle技术,是否可以给我发一个邀请码,我的邮件是wikiwei@qq.com,Thanks….

  16. Hi, Maclean,您好,我想进入您的论坛学习Oracle技术,请问能给我发一个邀请码吗?我的邮箱为:miaoyiman@126.com

  17. Hi, Maclean,我是一个DBA初学者,想进入论坛学习oracle技术,申请注册码?邮箱:smk613@163.com

  18. Hi, Maclean能否给一个邀请码?想学习下,pei_xiang@hotmail.com

  19. 你好, Maclean老大, 我想进入您的论坛学习Oracle技术和大家一起分享,请问能给我发一个邀请码吗?我的邮箱258914937@qq.com 谢谢

  20. Hi, Maclean 你论坛的文章让我受益匪浅,能否给一个邀请码?想学习下,非常感谢!邮箱:kongweitao@hotmail.com

  21. Hi, Maclean 我想注册论坛http://t.askmaclean.com/forum.php 账号,请送我一个邀请码,谢谢 邮箱:kongweitao@hotmail.com