摘要： 一. 官网说明1.1 v$session_longops V$SESSION_LONGOPS displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Or 阅读全文

摘要： 一. Recursive Calls 说明在执行计划的统计信息里有如下信息：SYS@anqing2(rac2)> set autot trace statisticsSYS@anqing2(rac2)> select * from ta,tb where ta.id=tb.id and ta.id <10; 9 rows selected.Statistics---------------------------------------------------------- 5 recursive calls 0 db block gets 2081 consistent g 阅读全文

摘要： 一. Shared Pool 概述 在之前的blog对Oracle 的内存架构也做了一个概述，参考： Oracle 内存 架构 详解 http://blog.csdn.net/tianlesoftware/archive/2010/05/15/5594080.aspx 在网上搜到一篇介绍shared pool 非常详细的pdf资料。 原文链接以找不到，但还是要感谢作者Kamus的辛勤劳动。 结合Kamus 的pdf和csdn 网友的blog，重新整理了一下，链接如下： http://blog.csdn.net/robinson1988/archive/2010/11/26/6037925... 阅读全文