About ORACLE CPU, PSU, SPU Patch Nomenclature

It all started in January 2005 with Critical Patch Updates (CPU). Then Patch Set Updates (PSU) were added as cumulative patches that included priority fixes as well as security fixes.

Backup ASM metadata with shell

Creates a backup directory if required, works out the A […]

, ,

linux发送手机短信 利用fesion robot

系统监控对于严重紧急的问题发短信通知,利用中国移动的飞信就可以做到免费给飞信好友发送sms短信,飞信机器人就是调用飞信的接口,可以命令行下调用。我们恰好可以利用这点。

,

Tuning “Read by other session wait” Event

This wait event occurs when we are trying to access a buffer in the buffer cache but we find that the buffer is currently being read from disk by another user so we need to wait for that to complete before we can access it.

力挺一下sqluldr

客户要求导出大量的数据(约800万记录),开始为了格式上的好看生成的是ACCESS数据库文件,用Toad 11 […]

荆棘载途 RAC安装之NFS篇

这两天在NFS上配置一套RAC玩,实在没有好的机器就是三台PC,内存2G,每个PC还单块物理网卡,不过最终安装成功。下面记录安装过程中的一些小问题。

Tuning ‘log file sync’ Event

The log file sync wait occurs at the end of a transaction (COMMIT or End Of Job)and the database writer (DBWR) process must wait for the log file to synchronize with the database.

Troubleshooting wait event: ‘latch: row cache objects’

This latch comes into play when user processes are attempting to access or update the cached data dictionary values.

,