Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes

最新推荐文章于 2021-12-10 11:21:03 发布
转载 最新推荐文章于 2021-12-10 11:21:03 发布 · 807 阅读 · 0

Procwatcher是一款用于监控Oracle数据库及集群进程的工具，能够收集进程堆栈跟踪和SQL数据，适用于解决会话级挂起、性能问题及内存管理等场景。本文档详细介绍了其安装要求、适用场景及命令操作。

 

 

Purpose

Procwatcher is a tool to examine and monitor Oracle database and/or clusterware processes at an interval.   The tool will collect stack traces of these processes using Oracle tools like oradebug short_stack and/or OS debuggers like pstack, gdb, dbx, or ladebug and collect SQL data if specified.

 

Requirements

  • Must have /bin and /usr/bin in your $PATH
  • Have your instance_name or db_name set in the oratab and/or set the $ORACLE_HOME env variable.(PRW searches the oratab for the SID it finds and if it can't find the SID in the oratab it will default to $ORACLE_HOME). Procwatcher cannot function properly if it cannot find an $ORACLE_HOME to use.
  • Run Procwatcher as the oracle software owner if you are only troubleshooting homes/instances for that user. If you are troubleshooting clusterware processes (EXAMINE_CLUSTER=true or are troubleshooting for multiple oracle users) run as root.
  • If you are monitoring the clusterware you must have the relevant OS debugger installed on your platform; PRW looks for:

Linux - /usr/bin/gdb
HP-UX and HP Itanium - /opt/langtools/bin/gdb64 or /usr/ccs/bin/gdb64
Sun - /usr/bin/pstack
IBM AIX - /bin/procstack or /bin/dbx
HP Tru64 - /bin/ladebug

 

 

Procwatcher is Ideal for:

  • Session level hangs or severe contention in the database/instance. See Note: 1352623.1
  • Severe performance issues. See Note: 1352623.1
  • Instance evictions and/or DRM timeouts.
  • Clusterware or DB processes stuck or consuming high CPU (must set EXAMINE_CLUSTER=true and run as root for clusterware processes)
  • ORA-4031 and SGA memory management issues. (Set sgamemwatch=diag or sgamemwatch=avoid4031 (not the default). See Note: 1355030.1
  • ORA-4030 and DB process memory issues. (Set USE_SQL=true and process_memory=y).
  • RMAN slowness/contention during a backup. (Set USE_SQL=true and rmanclient=y).

Procwatcher is Not Ideal for...

  • Node evictions/reboots. In order to troubleshoot these you would have to enable Procwatcher for a process(es) that are capable of rebooting the machine. If the OS debugger suspends the processs for too long *that* could cause a reboot of the machine. I would only use Procwatcher for a node eviction/reboot if the problem was reproducing on a test system and I didn't care of the node got rebooted. Even in that case the INTERVAL would need to be set low (30) and many options would have to be turned off to get the cycle time low enough (EXAMINE_BG=false, USE_SQL=false, probably removing additional processes from the CLUSTERPROCS list).
  • Non-severe database performance issues. AWR/ADDM/statspack are better options for this...
  • Most installation or upgrade issues. We aren't getting data for this unless we are at a stage of the installation/upgrade where key processes are already started.

 

Procwatcher User Commands

To start Procwatcher:

./prw.sh start



Or if you want to start on all nodes in a clustered environment:

./prw.sh start all




To stop Procwatcher: :

./prw.sh stop



Or if you want to stop on all nodes in a clustered environment:

./prw.sh stop all



To check the status of Procwatcher:

./prw.sh stat

 

To package up Procwatcher files to upload to support:

./prw.sh pack



All user syntax available:

./prw.sh help

 

（第78天）DB RU 补丁升级：19C 升级到 19.22
LuciferLiu_DBA
03-24 619
目前 Oracle 19C 是最新的稳定支持的版本，生产环境中使用的越来越多。当然，随着客户使用量的增多，自然无可避免的产生了很多 BUG，Oracle 每季度都会发布一个 RU 补丁来修复当前季度所产生的一些重要 BUG 补丁。作为 DBA，DB 补丁修复必然是需要掌握的一项技能。本文将介绍如何将数据库升级到最新的 RU 版本。
【0036】 pg_ctl启动服务报错：stopped waiting， pg_ctl: could not start server，Examine the log output.
Postgres 数据库内核开发工程师
05-06 8171
文章目录1. pg_ctl启动服务报错2. 解决方案 1. pg_ctl启动服务报错     当使用pg_ctl命令启动服务时，如下： su postgres -c '/usr/local/xxxx/bin/pg_ctl -D /home/soft/xxxx/DATA -m fast start'     有时会遇到终端错误信息提示，并且服务无法起来（ps -eLf|grep postgres）。其打印的错误信息如下： 2021-05-06 16:03:34.051 GMT [128363] DEBUG:
Procwatcher: Script to Monitor and Examine Oracle DB and Clusterware Processes (文档 ID 459694.1)
weixin_30367873的博客
08-05 161
Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.2 to 12.1.0.1 [Release 10.2 to 12.1] Linux x86 HP-UX PA-RISC (64-bit) IBM AIX on POWER Systems (64-bit) Oracle Solaris on SPARC (64-...
Procwatcher: Script to Monitor and Examine DB and Clusterware Pro-459694.1
10-30 182
Procwatcher: Script. to Monitor and Examine Oracle DB and Clusterware Processes (文档 ID 459694.1)In this ...
MOS：Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructur
Zhong Weicheng Study Notes
03-21 3746
Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure RAC Best Practice and Starter Kit Information The goal of the Oracle Real Application Clusters (RA
RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) [ID
07-20 1543
RAC Assurance Support Team: RAC and Oracle Clusterware Starter Kit and Best Practices (Generic) [ID 810394.1] Modified 09-FEB-2011     Type
oracle 诊断利器之一—Procwatcher
我的Oracle DBA之路
01-07 1091
http://www.killdb.com/2011/10/16/oracle-诊断利器之一-procwatcher.html 今天有人问道，是否有工具来收集系统的诊断信息呢？比如收集crs进程的？ 收集某个进程的cpu或内存消耗等等？虽然可以通过shell脚本在实现，但是 oracle其实提供了这样的工具的，那就是Procwatcher，该工具，大家可以从MOS上下载， 那么这个功能是干什
Master Note: How to diagnose Database Performance - FAQ [ID 402983.1]
沉淀
05-10 852
如何利用oracle工具诊断性能问题，这篇问题起到提纲的作用，可以根据文中提到的方法，顺藤摸瓜，确定并解决问题
CRS 诊断数据收集：常见工具及其用法摘要 (Doc ID 1526158.1)
u010692693的专栏
11-19 768
适用于: Oracle Database - Enterprise Edition - 版本 10.2.0.1 到 11.2.0.3 [发行版 10.2 到 11.2] 本文档所含信息适用于所有平台 用途 本文档提供了用于诊断 CRS/GRID 问题的工具的快速指南。 适用范围 本文档的目标受众是需要诊断 CRS/Grid Infrastructure 问题的
Troubleshooting 'cursor: pin S wait on X' waits. (文档 ID 1349387.1)
mybluetiankong的专栏
01-04 950
In this Document   Purpose   Troubleshooting Steps   What is a 'Cursor: pin S wait on X' wait?   What causes 'Cursor: pin S wait on X' waits?
Troubleshooting 'library cache: mutex X' Waits. (文档 ID 1357946.1)
热门推荐
badman250的专栏
03-16 3万+
PURPOSE The purpose of the article is to help troubleshoot contention for the wait event 'library cache: mutex X'. TROUBLESHOOTING STEPS What is a 'library cache: mutex X' wait? The mutex feat
【论文笔记】Crop phenotyping in a context of Global Change: what to measure and how to do it
crush111的博客
12-10 1079
【论文笔记】Crop phenotyping in a context of Global Change: what to measure and how to do it 全球变化背景下的作物表型：测什么&如何去做 1.摘要： High-throughput crop phenotyping, particularly under field conditions, is nowadays perceived as a key factor limiting crop genetic advan
umbraco.examine.linq:LINQ to Lucene Umbraco的查询提供程序
04-30
umbraco.examine.linq已发布为“ Linq To Examine” 什么是Linq要检查的？ 该项目允许您根据自己的类使用LINQ查询Lucene索引。 该项目带有一个基本的Result类，使您可以直接使用它。 您可以在此处查看演示： : #...
SSH原理框架图-下载即用.zip
01-01
代码转载自：https://pan.quark.cn/s/7f503284aed9 Hibernate的核心组件总数达到五个，具体包括：Session、SessionFactory、Transaction、Query以及Configuration。 这五个核心组件在各类开发项目中都具有普遍的应用性。 借助这些组件，不仅可以高效地进行持久化对象的读取与存储，还能够实现事务管理功能。 接下来将通过图形化的方式，逐一阐述这五个核心组件的具体细节。 依据所提供的文件内容，可以总结出以下几个关键知识点：### 1. SSH框架详细架构图尽管标题提及“SSH框架详细架构图”，但在描述部分并未直接呈现关于SSH的详细内容，而是转向介绍了Hibernate的核心接口。 然而，在此我们可以简要概述SSH框架（涵盖Spring、Struts、Hibernate）的核心理念及其在Java开发中的具体作用。 #### Spring框架- **定义**：Spring框架是一个开源架构，其设计目标在于简化企业级应用的开发流程。 - **特点**： - **分层结构**：该框架允许开发者根据实际需求选择性地采纳部分组件，而非强制使用全部功能。 - **可复用性**：Spring框架支持创建可在不同开发环境中重复利用的业务逻辑和数据访问组件。 - **核心构成**： - **核心容器**：该部分包含了Spring框架的基础功能，其核心在于`BeanFactory`，该组件通过工厂模式运作，并借助控制反转（IoC）理念，将配置和依赖管理与具体的应用代码进行有效分离。 - **Spring上下文**：提供一个配置文件，其中整合了诸如JNDI、EJB、邮件服务、国际化支持等企业级服务。 - **Spring AO...
wx_camera_1767247411296.jpg
01-01
wx_camera_1767247411296.jpg
LCD1602时钟程序-下载即用.zip
最新发布
01-01
代码下载地址： https://pan.quark.cn/s/c833ef5cc71e 采用LCD1602显示屏与51微控制器内置定时器构建的电子时钟装置，支持日期与时间参数的修改功能。 经过编译验证，该程序未发现任何错误，确保安全可靠地应用。
UR机械臂ROS2仿真控制[项目代码]
01-01
本文详细介绍了如何使用Universal_Robots_ROS2_Driver实现UR机械臂的仿真控制。首先，文章指导读者搭建仿真环境，包括虚拟机、Linux环境、ROS2和Docker的配置。接着，介绍了UR机械臂的驱动接口，并详细说明了如何下载和安装Universal_Robots_ROS2_Driver驱动。随后，文章讲解了UR_sim仿真器的下载和运行方法，包括使用Docker容器拉取镜像和启动仿真器的步骤。最后，文章展示了如何通过URSim simulator示教器控制机器人运动，并基于Universal_Robots_ROS2_Driver实现UR机械臂的仿真控制。整个过程涵盖了环境搭建、驱动安装、仿真器运行和实际控制操作，为读者提供了全面的指导。
STM32F103C8T6最小系统电路设计与PCB原理图
01-01
STM32F103C8T6微控制器核心电路设计图文件。 资源来源于网络分享，仅用于学习交流使用，请勿用于商业，如有侵权请联系我删除！
QT下载安装指南[项目代码]
01-01
本文详细介绍了QT的下载与安装步骤。首先提供了QT的官方下载路径及国内镜像网站，建议使用国内高校镜像以加快下载速度。文章指出，Qt5.8.0以后的版本中，Windows平台下的64位安装包以组件形式集成在同一个exe中，安装时需注意断网以避免注册账号的麻烦。接着，文章列举了Qt 5.9.9的功能模块，包括MinGW 5.3.0 32 bit编译器模块、UWP编译模块、MSVC编译器模块、Android平台模块等，并简要说明了各模块的用途。此外，还介绍了Tools节点下的工具软件，如Qt Creator 4.3.1开发IDE和MinGW 5.3.0编译工具链。
examine and elaborate the answer in english
11-10
In SystemVerilog, there are several types of coverage used to assess the thoroughness of testing. ### Code Coverage - **Line Coverage**: It ensures that each line of code in the design is executed at least once. For example: ```systemverilog module code_coverage_example; reg a, b, c; always @(*) begin c = a & b; // This line's execution is tracked by line coverage end endmodule ``` - **Branch Coverage**: Guarantees that all possible branches of conditional statements (such as if - else, case statements) are executed. ```systemverilog module branch_coverage; reg [1:0] sel; reg out; always @(*) begin if (sel == 2'b00) begin out = 1'b0; end else if (sel == 2'b01) begin out = 1'b1; end else begin out = 1'bx; end end endmodule ``` - **Condition Coverage**: Verifies all possible outcomes of conditional expressions in the design, ensuring that all possible value combinations of conditions are tested. ```systemverilog covergroup condition_cg @(posedge clk); cond_cover: coverpoint (condition1 && condition2); endgroup ``` ### Functional Coverage Functional coverage focuses on whether the functional features of the design are fully tested. It is defined based on the design's functional specifications. For example, for a processor, functional coverage may include the execution of the instruction set and testing of different operation modes. ```systemverilog covergroup functional_cg; opcode_cover: coverpoint cpu.opcode; mode_cover: coverpoint cpu.mode; endgroup ``` ### Assertion Coverage Assertion coverage is used to verify whether the assertions in the design are triggered. Assertions are statements used to check if the design behavior meets expectations. By assertion coverage, it can be ensured that assertions are correctly executed during testing. ```systemverilog module assertion_coverage; reg clk, rst; reg [7:0] data; always @(posedge clk) begin assert (data < 8'hFF) else $error("Data out of range"); end endmodule ``` ### Toggle Coverage Toggle coverage measures the state changes of signals during testing, ensuring that all possible signal transitions (from 0 to 1, from 1 to 0) are tested. ```systemverilog covergroup toggle_cg @(posedge clk); toggle_cover: coverpoint signal iff (enable) { bins rise = (0 => 1); bins fall = (1 => 0); } endgroup ``` ### Path Coverage Path coverage is used to verify the behavior of different signal paths in the design, ensuring that all possible signal propagation paths are tested. ```systemverilog module path_coverage; reg a, b, c, d; wire e, f; assign e = a & b; assign f = c | d; wire out = e ^ f; endmodule ``` ### Interface Coverage Interface coverage focuses on the usage of interfaces in the design, ensuring that all functions and protocols of the interface are fully tested. For example, for a bus interface, interface coverage may include different bus transaction types and address ranges. ```systemverilog covergroup interface_cg; transaction_type_cover: coverpoint bus_if.transaction_type; address_range_cover: coverpoint bus_if.address; endgroup ``` ### Transaction Coverage Transaction coverage is based on transactions in the design. It ensures that all possible transaction types and sequences are tested. For example, for a communication system, transaction coverage may include different message types and message lengths. ```systemverilog covergroup transaction_cg; message_type_cover: coverpoint comm_system.message_type; message_length_cover: coverpoint comm_system.message_length; endgroup ``` ### State Machine Coverage State machine coverage verifies the behavior of state machines, ensuring that all states and state transitions of the state machine are fully tested, which helps to check if the state machine performs state transitions correctly according to the design specifications and avoid issues such as state loss or illegal state transitions [^1]. ```systemverilog covergroup state_machine_cg @(posedge clk); state_transition: coverpoint state_machine.current_state -> state_machine.next_state; endgroup ``` ### Block Coverage Block coverage focuses on the execution of code blocks, ensuring that each code block (such as always blocks, tasks, functions) in the design is executed at least once. ```systemverilog covergroup block_cg; always_block_cover: coverpoint always_block_executed; task_cover: coverpoint task_executed; endgroup ``` ### Weighted Coverage Weighted coverage can be used to specify the proportion of a certain coverage point in the overall. For example, when covering a counter, the goal is to observe a range rather than collect all cases. In this case, option.weight = 0 can be set, which means that the coverage rate of this group or point is not calculated in the overall coverage statistics [^2]. ```systemverilog covergroup weighted_cg; coverpoint counter { option.weight = 5; bins small = {[0:10]}; bins medium = {[11:50]}; bins large = {[51:$]}; } endgroup ```
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值