Henry Xie 's blog
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...
How To Delete Backupset Via BP Key
›
Sometimes we have 2 copies of 1 backupset, they are with the same tag. If we wanna delete 1 and keep only 1 copy, we can't delete it vi...
Monday, November 12, 2012
How To Use NETSTAT To Find Interrupted Connections
›
This note is taking ldap connection for example. We use can the same method for other type of connections Below example is to show ldap c...
‹
›
Home
View web version