了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support，N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群，空位多多。欢迎有一定基础的Oracle骨友加入，现在入群需要经过Maclean的技术面试，欢迎面试，请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学，会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群，空位多多，无需面试

05 2009 档案

Most of library cache latches have gone in 11g
摘要：10gSELECT t1.ksllasnam "parent_name",t2.ksllwnam "location"FROM x$ksllw t2, x$kslwsc t1WHERE t2.indx = t1.indxAND ksllasnam like '%library cache%'parent_name lo... 阅读全文

posted @ 2009-05-20 19:22 Oracle和MySQL 阅读(343) 评论(0) 推荐(0) 编辑

[Repost]List of X$ Tables
摘要：This is a summary list of X$ Table Definitions - Last revision was 7.3.2The main purpose of this note is to show the naming conventions.[K]ernel Layer[2]-Phase Commit[G]lobal [T]ransaction [E]ntryX$K2... 阅读全文

posted @ 2009-05-16 21:38 Oracle和MySQL 阅读(635) 评论(0) 推荐(0) 编辑

Script:Translate RDBA relative data block address
摘要：Script:Translate RDBA relative data block address -- scripts/admin/rdba/rdba_to_file_block.sqlselect trunc( to_number('&rdba','XXXXXXXX') / power(2,22) ) as rfile# , trunc(to_number('&r... 阅读全文

posted @ 2009-05-09 19:06 Oracle和MySQL 阅读(216) 评论(0) 推荐(0) 编辑

Trace obtained enqueue information by set event 10704
摘要：Oracle事件10704可以帮助我们了解队列Enqueue的使用情况，使用方法如下:[oracle@rh2 bdump]$ oerr ora 1070410704, 00000, "Print out information about what enqueues are being obtained"// *Cause: When enabled, prints out arguments ... 阅读全文

posted @ 2009-05-08 05:13 Oracle和MySQL 阅读(256) 评论(0) 推荐(0) 编辑

导航

< 2025年3月 >
日 一 二 三 四 五 六
23 24 25 26 27 28 1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31 1 2 3 4 5
点击右上角即可分享
微信分享提示