Nmap (“Network Mapper”) is an open source tool for network exploration and security auditing. It was designed to rapidly scan large networks, although it works fine against single hosts. While Nmap is commonly used for security audits, many systems and network administrators find it useful for routi[……]

Read more

ASR XD报警抛出如下错误

"
dm01cel02: Hardware Error has been detected in the Flash Logs on the Cell Node
dm01cel02: Please open up a Service Request with Oracle to resolve the Error
dm01cel02: View File /tmp/ASR-Flash-Fault-Check-Log for further Information of the Error
dm01cel02: This log File c[......]
Read more

基于上次的nicstat linux还提供了nethogs,可以监控指定pid的具体流量,在这里可以下到源码.

获取过程：

open("/proc/$pid/fd")
open("/proc/net/tcp")
open("/proc/net/tcp6")
open("/etc/passwd")

eg:

[root@db-81 27274]# nethogs  -d  5

NetHogs version 0.7.snapshot

  PID USER     PRO[......]
Read more

oracle 11gR2 rac listener引入了3项主要的改变：

1. listener默认owner为grid

[oracle@db-42 ~]$ srvctl config listener
Name: LISTENER
Network: 1, Owner: grid
Home:
End points: TCP:1521

2. listener 被oracle agent 所管理 (oraagent)
[grid@db-41 admin]$ ps -ef |grep oraagent
grid 22195 18519 0 16:42 pts[……]

Read more

[……]

Read more

同事aaqwsh做的关于Exadata-X2-2的smart scan总结[……]

Read more

我们可以通过v$sql_bind_capture 捕获到 bind values 这篇文章主要阐述v$sql_bind_capture与v$sql_plan的一些联系

SQL*Plus: Release 11.2.0.3.0 Production on Tue Aug 28 14:07:13 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.[......]
Read more

整理一篇关于11g smart flash cache 的文章,louisliu

我们来做一下演示 采用FusionIO SLC 160G

[oracle@db-41 ~]$ ls -l /dev/fioa 
brw-r----- 1 oracle oinstall 252, 0 Jul 17 14:26 /dev/fioa


[root@db-41 dev]# fio-status

Found 1 ioDrive in this system
Fusion-io dri[......]
Read more

Oracle Exadata 从 11.2.2.4.0开始引入了 Smart Flash Logging的新特性，在exadata环境中,当oracle 需要写入日志的时候将会启动parallel write 同时在 disk 和 flash两端写入数据,controller中有任意一个率先写完就会通知RDBMS数据库继续工作， 该特性着力于提高Exadata对Redo写入的响应时间和吞吐量。(The feature allows redo writes to be written to both flash cache and disk controller cache, with an a[……]

Read more

对于需要使用资源控制的应用,oracle提出了resource manager这一解决方案，针对不同的schema,Oracle提供不同的资源等级,但是这种资源的分配其实本身就存在一定的资源消耗,当大量的session涌入数据库的时候,oracle需要消耗一定数量的cpu去重新分配资源的调级,此时就会伴随的大量resmgr:cpu quantum等待事件，下面总结一下这次的测试：

环境简述，本次测试resource manager采用oracle 11.2.0.3 平台为IBM power750小型机具体配置如下：

System Model: IBM,8233-E8B
Machi[......]
Read more