今天Dev team给我报告说有个JOB 跑了2个小时还没跑完,平时只需要10多分钟,叫我check一下。
数据库版本:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for HPUX: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
由于我是用toad监控的,所以不方便贴出具体信息,该SQL的等待事件是 i/o slave wait,所以我怀疑I/O出现了问题
登陆HP-UNIX,用glance监控,发现Disk Util 有很大部分时间 是100%
ProcList CPU Rpt Mem Rpt Disk Rpt NextKeys SlctProc Help Exit
Glance C.05.00.100 02:31:24 bdhp4463 ia64 Current Avg High
------------------------------------------------------------------------------------------------------------------------------------------------------
CPU Util S SN NU U | 59% 52% 76%
Disk Util F F | 72% 78% 100%
Mem Util S SU UF F | 53% 57% 60%
Networkil U UR R | 29% 31% 33%
再看了看 占用 大量磁盘资源的 session,结果发现是SYS在用RMAN 备份。
赶紧给SYSDBA 发邮件说明情况,我不是SYSDBA啊,我必须推卸责任,于是SYSDBA回复了
Dear SYSDBAs,
Today, I was reported that we’re having a long running job on adw1u1.
It has running for about 156 minutes, wait event is i/o slave wait, I’ve asked DEV team, they said the job should be finished within few minutes.
According the wait event , I doubt we are lack of I/O resource, So I checked UNIX side , found that some session consumed lots of I/O resource
finally , I found that top I/O consumed user is SYS, they are backup database using RMAN.
Is there a way to avoid performance problem while you’re backup database?
SYSDBA 回复:
For non-prod we have weekly backups running.
Backups will need to read the data from disk and dump it to tape, that is indeed IO intensive.
But backups are needed and it’s not possible to run a backup without consuming IO.
i/o slave wait 是一个Idle的等待事件,通常出现该等待事件表示I/O资源不足
分享到:
相关推荐
verilog实现I2C通信的slave模块源码状态机设计可做I2C接口的仿真模型,module I2C_slv ( input [6:0] slv_id, ...////////////////////////output reg sda_o, //I2C data out output reg reg_w, //reg w ..
i2s串行线广泛用于音频通信中,这里包括了master和slave的代码.
Xilinx提供的I2C控制器代码,Master/Slave全功能
I2C verilong code 详细代码分析,根据协议每一步都有分析,进过验证,代码分slave和master部分,代码比较成熟
I2C verilong code 详细代码分析,根据协议每一步都有分析,进过验证,代码分slave和master部分,
Supports 8-bit I/O Read and Write cycles, 8-bit Memory Read/Write cycles, DMA cycles, and up to 32-bit Firmware memory read/write cycles. Serial IRQ support is also provided. None of this has been ...
salve端的i2c verilog代码,用于fpga。
实现用IO口模拟I2C slave程序,采用中断处理;
USB GPIF/Slave FIFO 开发技术手册 这是英文的 最好对照着中文一起看
最近一个项目需要做I2C的slave,在opencores.org上面找到了一个I2C的代码,不过是master的。 下载来看看,发现里面有一个I2C slave的行为级代码。 于是自己根据这个代码改写了一个I2C slave RTL的代码,并修改了...
基于FPGA的I2C SLAVE模式总线的设计.pdf
mysql master-slave 主从配置的讲解
I/O通信:I/O信息用于时序要求严格和面向控制的数据,它们在生产应用程序中和一个或多个消费应用程序之间提供了专用的通信路径。 二、DeviceNet通信的I/O设备 用于IRC5的DeviceNet网络运行在IRC5主计算机的单通道...
基于STM32F030的寄存器 的 I2C slave 代码。包含dummy read功能
I2C slave reference code. Verified on FPGA.
新建eclipse文件夹,而且eclipse里面包括features和plugins然后把org.slave4j_1.0.0.jar 丢人这两个文件里面然后重启Eclipse.(安装无污染,许多插件几乎都可以这样安装,像反编译jad插件,android插件,svn插件 CC...
Verilog i2c slave rtl + testbench 仿真ok
i2cSlave is a minimalist I2C slave IP core that provides the basic framework for the implementation of custom I2C slave devices. The core provides a means to read and write up to 256 8-byte registers....
I2C slave 的核,很经典,已经验证过,很好用。
一个I2c个 slave 模块,做成IP核挂在AVALON总线上,可通过niosII访问