摘要:
一. 官网说明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... 阅读全文