Henry Xie 's blog
Monday, December 17, 2012
How To Check Dead Process in Linux
›
use lsof command to check if any files deleted when processes are running * lsof -p PID use strace to check the pids are not process...
Sunday, December 02, 2012
How to Recover Datafile From Standby DB
›
Goal Problem Statement How to recover the primary database's datafile using a copy of a standby database's datafile. and How...
Thursday, November 22, 2012
A Useful Sql To Check Tablespace Growth
›
To find latest 30 days tablespace growth report: set heading on set linesize 5500 set pages 999 SELECT TO_CHAR (sp.begin_interval_time,'...
Sunday, November 18, 2012
How To View Oracle Text Query Exec Plan
›
Oracle Text Query is not like normal sql which we can get sql plan via "explain plan for" "select * from table(dbms_xplan.dis...
Wednesday, November 14, 2012
How Exadata Offload Some RMAN Incremtal Backup Load To Cell
›
It's well known that from 10g, oracle db has a new feature to enable block change tracking. It does a great job to avoid RMAN to scan th...
‹
›
Home
View web version