reading this week outside greader

ORA-04031 errors and monitoring shared pool subpool memory utilization with sgastatx.sql
http://blog.tanelpoder.com/2009/06/04/ora-04031-errors-and-monitoring-shared-pool-subpool-memory-utilization-with-sgastatxsql/comment-page-1/#comment-4456

Oracle内存全面分析(9)
http://www.hellodba.com/Doc/oracle_memory%289%29.htm

CPU used
http://jonathanlewis.wordpress.com/2009/05/26/cpu-used/

如何分析AWR (5)
http://www.os2ora.com/how-to-analyze-awr-report-5/

cardinality
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:40230704959128

Using Cursors
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14354/chapter5.htm#BABECAEF

Ref cursors
http://www.adp-gmbh.ch/ora/plsql/cursors/ref_cursors.html

Cursor Sharing 3
http://jonathanlewis.wordpress.com/2010/05/03/cursor-sharing-3/

KGH: NO ACCESS allocations in V$SGASTAT – buffer cache within shared pool!
http://blog.tanelpoder.com/2009/09/09/kgh-no-access-allocations-in-vsgastat-buffer-cache-within-shared-pool/

KGH: NO ACCESS – Buffer cache inside streams pool too!
http://blog.tanelpoder.com/2010/04/21/kgh-no-access-buffer-cache-inside-streams-pool-too/

发表评论

电子邮件地址不会被公开。 必填项已用*标注

您可以使用这些HTML标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>