来读一读 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职业网络: