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

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

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Speak Your Mind

沪ICP备14014813号

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569