Oracle和MySQL - 博客园

Basic Oracle For Developer & Beginner

摘要：得闲做了一个给初学者和开发人员介绍基础概念的PPT,本来还想把前前后后写的SMON功能的帖子汇总到一个PPT里，但是现在要开始忙婚礼的事了，估计这半年里是没空了。。 Basic oracle for developer&beginner View more presentations from Maclean Liu 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(136) 评论(0) 推荐(0)

How to Uninstall/Reinstall 10g CRS Clusterware?

摘要：如何重装10g clusterware集群软件?一般情况下我会说把DB、CRS停掉,手动删除ORA_CRS_HOME及/etc(或者/opt)目录下的ora*配置文件，使用dd命令清理LUN的头部。再重装一般就没有问题了，但实践过程中往往会因为清理地不够彻底而出现问题。今天同事问我有没有彻底卸载CRS的文档，到metalink上搜了一圈结果还真没有，最后从Alejandro Vargas' Blo... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(276) 评论(0) 推荐(0)

Know about Oracle RAC Heartbeat

摘要： Oracle CRS的心跳主要分为Disk和Network Heartbeat，不同种类的心跳超时会对RAC造成不同的影响。Heartbeat MechanismsDisk Heartbeat ( Voting device ) – IOTNetwork Heartbeat ( across the interconnect ) – misscountMisscount – max time a ... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(247) 评论(0) 推荐(0)

利用ProcDump工具诊断Windows平台上的Oracle数据库性能

摘要： ProcDump与Procexp一样是Windows平台上的内部调试工具，Procexp采用图形界面体现系统整体及个别进程的性能信息，而ProcDump则与我们在Unix平台上使用的性能分析工具类似使用CLI命令行界面。Procdump目前的版本号为3.04，可以从其Homepage上下载到该工具，该监控软件由Mark Russinovich开发，是一款Free Software。其官方介绍如下:... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(348) 评论(0) 推荐(0)

Restore Production Database to Development Platform A step-by-step example

摘要： Overview of setup and configuration Oracle Enterprise Edition 11gR2. 11.2.0.1.0 Linux RH5 NetBackup 6.5.5 Identical environments: Identical versions of Oracle. Same ORACLE_HOME and ORACLE_BASE. The ar... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(141) 评论(0) 推荐(0)

Library Cache Hit Ratio

摘要： The library cache (a component of the shared pool) stores the executable (parsed or compiled) form of recently referenced SQL and PL/SQL code. Oracle tries to reuse this code. If the code has been exe... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(225) 评论(0) 推荐(0)

PX Deq: Execute Reply等待事件

摘要： Occurs when the query coordinator is waiting for a response from a parallel slave. This is normally considered an idle event, but can cause excessive CPU in some cases. SolutionReduce the degree of ... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(500) 评论(0) 推荐(0)

PX Deq: Execution Msg等待事件

摘要： Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases. SolutionReduce the degree of parallelism in the q... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(540) 评论(0) 推荐(0)

PX Deq: Table Q Normal等待事件

摘要： Occurs when a parallel slave is waiting for data from another slave. Investigate why the other slaves are not sending data fast enough. This is normally considered an idle event, but can cause excessi... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(934) 评论(0) 推荐(0)

PX qref latch等待事件

摘要： Contention caused by communication between parallel query processes. SolutionsDecrease the degree of parallelism for the queriesTune the parallel_execution_message_size parameter (may require larger... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(280) 评论(0) 推荐(0)