2017年（38）
发布时间：2017-12-07 13:48:14
http://www.eygle.com/archives/2009/11/awk_ass109.htmlhttp://space.itpub.net/38267/viewspace-731832http://space.itpub.net/38267/viewspace-731874......【阅读全文】
发布时间：2017-12-07 13:48:13
由于多节点的原因，会因为节点间的资源争用产生GC类的等待，而这其中GC Buffer Busy 最常見檢查B2B_CORE_RAC DB(VIP:10.134.130.225/226)發現 SCHEMA:WM71_AP MODULE:JDBC Connect Client 執行很多類似SQL：SELECT d.DocID, d.DocTimestamp, t.TypeName, s.Corpor.........【阅读全文】
发布时间：2017-12-07 13:48:13
1.moveanalyze table GC.R_WIP_KEYPARTS_T compute statistics; SELECT BLOCKS,EMPTY_BLOCKS FROM DBA_TABLESWHERE OWNER='GC' AND TABLE_NAME='R_WIP_KEYPARTS_T';BLOCKS:137452 EMPTY_BLOCKS:1812 SELECT BLOCKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T';BLOCKS:139264 DELE.........【阅读全文】
发布时间：2017-12-07 13:48:13
ALTER TABLE GC.R_WIP_KEYPARTS_T MOVE analyze table GC.R_WIP_KEYPARTS_T compute statistics; SELECT BLOCKS,EMPTY_BLOCKS FROM DBA_TABLESWHERE OWNER='GC' AND TABLE_NAME='R_WIP_KEYPARTS_T';BLOCKS:137381 --move之后看到BLOCKS減少EMPTY_BLOCKS:1883 SELECT BLOCKS FROM DBA_SEGMEN.........【阅读全文】
发布时间：2017-12-07 13:48:13
3.SHRINK SPACEALTER TABLE GC.R_WIP_keyparts_T SHRINK SPACE; ANALYZE TABLE GC.R_WIP_KEYPARTS_T COMPUTE STATISTICS; SELECT BLOCKS FROM DBA_SEGMENTS WHERE SEGMENT_NAME='R_WIP_KEYPARTS_T';BLOCKS:137312 SELECT BLOCKS,EMPTY_BLOCKS FROM DBA_tableS WHERE table_NAME='R_WIP_KEYPARTS_T';.........【阅读全文】
