- 博客(16)
- 资源 (6)
- 收藏
- 关注
转载 如何诊断节点重启问题
By Allen Gao-Oracle on 三月 28, 2012本文对如何诊断RAC环境中节点重启问题进行了介绍。适用于10gR2和11gR1.首先我们对能够导致节点重启的CRS进程进行介绍。1.ocssd : 它的主要功能是节点监控(Node Monitoring)和组管理(Group Management),它是CRS的核心进程之一。节点监控是指监控集群中节点的健康
2015-10-28 17:07:57 582
转载 vmstat 命令
第一个要使用的工具是 vmstat 命令,该命令可迅速提供关于各种系统资源和与之相关的性能问题的简要信息。vmstat 命令报告关于内核线程的统计信息,包括处于运行和等待队列中的、内存中的、页面调度中的、磁盘中的、中断、系统调用、上下文切换和 CPU 活动的内核线程。所报告的 CPU 活动是用户方式、系统方式、空闲时间和等待磁盘 I/O 的百分比细目分类。注: 如果在没有任何时间间隔的
2015-10-28 14:32:36 359
转载 Understanding Linux /proc/cpuinfo
A hyperthreaded processor has the same number of function units as an older, non-hyperthreaded processor. It just has two execution contexts, so it can maybe achieve better function unit utilization b
2015-10-28 12:57:40 269
转载 Monitoring Storage Devices with iostat
Monitoring Storage Devices with iostatJeff LaytonIf you are a system administrator of many systems, or even of just a desktop or laptop, you are likely monitoring your system in some
2015-10-27 13:05:30 470
转载 gc buffer busy acquire vs release
Last week (March 2012), I was conducting Advanced RAC Training online. During the class, I was recreating a ‘gc buffer busy’ waits to explain the concepts and methods to troubleshoot the issue.Def
2015-10-23 13:45:39 496
转载 gc cr block flush time
gc cr block flush timeThe CR block flush time is part of the service time for a CR buffer.The redo log write time and redo log sync time can influence the gc cr blockflush time significantly. Ea
2015-10-20 21:20:44 967
转载 RAC Wait Event: gcs log flush sync
ContentsOverview : gcs log flush sync wait eventMonitor gv$session wait events for LGWR, LMS processes Gcs Log Flush Sync Wait histogrammsReferencesOverview : gcs log flu
2015-10-20 14:33:27 1290
转载 Troubleshooting ‘DFS lock handle’ waits
https://orainternals.wordpress.com/2011/11/08/troubleshooting-dfs-lock-handle-waits/Posted by Riyaj Shamsudeen on November 8, 2011Waits for ‘DFS lock handle’ can cause massive performance
2015-10-19 22:08:26 913
转载 WAITEVENT: "buffer busy waits" Reference Note (Doc ID 34405.1)
WAITEVENT: "buffer busy waits" Reference Note (Doc ID 34405.1)To Bottom***Checked for relevance on 14-Jun-2012***"buffer busy waits" Reference NoteThi
2015-10-17 11:06:14 587
转载 WAITEVENT: "read by other session" Reference Note (Doc ID 732891.1)
WAITEVENT: "read by other session" Reference Note (Doc ID 732891.1)To Bottom"read by other session" Reference NoteThis is a reference note for the wai
2015-10-17 11:04:52 1005
原创 触发light work rule的一种情况
The lightwork rule is invoked when CR construction involves too much work and nocurrent block or PI block is available in the cache for block cleanouts. Any additional diskI/O to serve the CR bloc
2015-10-12 13:39:35 510
转载 gc cr disk read
You might encounter RAC wait event ‘gc cr disk read’ in 11.2 while tuning your applications in RAC environment. Let’s probe this wait event to understand why a session would wait for this wait event.
2015-10-12 11:05:13 1294
原创 Manual Database Creation in Oracle10g(RAC)
1 环境(1)节点:SDB1,SDB2 10.2.0.5(ASM/Cluster/DB) on ORACLE Linux 5.8(2)已经安装完毕ORACLE Cluster、ASM Home(Rac enable)及ORACLE HOME(Rac enabled)(3)ASM已经正常开启,DATA diskgourp已经正常mount2 准备init file在每个节点上建立
2015-10-04 10:06:17 436
原创 使用dbms_file_transfer传输ASM file出现ORA-15001
10.2.0.5 on oracle linus 5.8使用dbms_file_transfer.copy_file出现ORA-15001错误,尝试直接在ASM diskgroup上直接创建tablespace ,但是没有出现这个错误。ASM 已经正常mount。后来使用asmcmd进入相应目录,copy文件名称作为source_file_name参数才没有出现这个错误。dbm
2015-10-02 17:11:47 535
转载 Copying files from ASM to file system
Copying files from ASM to file systemPosted by Srikrishna Murthy Annam on January 9, 2011In the present article i am going to describe the various methods that we have to copy(Not moving,just co
2015-10-02 17:05:59 510
转载 Demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MB
Demystifying ASM REQUIRED_MIRROR_FREE_MB and USABLE_FILE_MBPosted by Harald van Breederode on January 3, 2013A recurring question in my classes is how Oracle Automatic Storage Management (ASM) c
2015-10-01 10:18:07 1196
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人