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

2009年6月1日

Oracle内部错误:ORA-00600[25012]一例

摘要： SQL> select count(*) from WWork;COUNT(*)----------116114select count(*) from WWork where Work_WorkID = 100;select count(*) from WWork where Work_WorkID = 100*ERROR at line 1:ORA-00600: internal error ... 阅读全文

posted @ 2009-06-01 01:15 Oracle和MySQL 阅读(739) 评论(0) 推荐(0)

2009年5月20日

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 阅读(349) 评论(0) 推荐(0)

2009年5月16日

[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 阅读(646) 评论(0) 推荐(0)

2009年5月9日

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 阅读(221) 评论(0) 推荐(0)

2009年5月8日

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 阅读(264) 评论(0) 推荐(0)

2009年4月13日

脚本:格式化的V$SQL_SHARED_CURSOR报告

摘要： The function generates a summary report of the v$sql_shared_cursor view and additional diagnostic information depending on the reason code.Counts all the versions that have 'Y' in any of the columns a... 阅读全文

posted @ 2009-04-13 20:32 Oracle和MySQL 阅读(459) 评论(0) 推荐(0)

脚本:监控并行进程状态

摘要： 脚本正文:col username for a12col "QC SID" for A6col "SID" for A6col "QC/Slave" for A8col "Req. DOP" for 9999col "Actual DOP" for 9999col "Slaveset" for A8col "Slave INST" for A9col "QC INST" for A6set pag... 阅读全文

posted @ 2009-04-13 19:51 Oracle和MySQL 阅读(296) 评论(0) 推荐(0)

脚本:监控数据库中的活跃用户及其运行的SQL

摘要： 脚本正文:set linesize 120 pagesize 66col c1 for a9col c1 heading "OS User"col c2 for a9col c2 heading "Oracle User"col b1 for a9col b1 heading "Unix PID"col b2 for 9999 justify leftcol b2 heading "SID"col... 阅读全文

posted @ 2009-04-13 19:46 Oracle和MySQL 阅读(255) 评论(0) 推荐(0)

脚本：监控临时表空间使用率

摘要： 针对字典管理临时表空间:select (s.tot_used_blocks/f.total_blocks)*100 as "percent used" from (select sum(used_blocks) tot_used_blocks from v$sort_segment where tablespace_name='TEMP') s, (select sum(blocks) total... 阅读全文

posted @ 2009-04-13 19:25 Oracle和MySQL 阅读(328) 评论(0) 推荐(0)

2009年3月17日

RBO基于规则的优化器access paths优先级

摘要： RBO基于规则的优化器access paths优先级:RBO Path 1: Single Row by RowidRBO Path 2: Single Row by Cluster JoinRBO Path 3: Single Row by Hash Cluster Key with Unique or Primary KeyRBO Path 4: Single Row by Unique or... 阅读全文

posted @ 2009-03-17 13:05 Oracle和MySQL 阅读(205) 评论(0) 推荐(0)

导航