How to Reduce Parse Time Cpu (文档 ID 156262.1)

mybluetiankong

于 2013-11-25 07:49:21 发布

阅读量581

点赞数

分类专栏：网络资源_ORACLE_调优

网络资源_ORACLE_调优专栏收录该内容

109 篇文章

订阅专栏

本文介绍如何通过查询V$SQLAREA视图找到频繁解析的SQL语句，并提供了三种优化方法：改写应用程序避免重复解析；使用初始化参数SESSION_CACHED_CURSORS减少解析；利用绑定变量来降低解析次数。

  goal: How to reduce Parse Time Cpu
fact: Oracle Server - Enterprise Edition



fix:

Query V$SQLAREA to find frequently reparsed statements: 

SELECT SQL_TEXT, PARSE_CALLS, EXECUTIONS FROM V$SQLAREA
ORDER BY PARSE_CALLS;

Tune the statements with the higher numbers of parse calls. 

Following three options for tuning statements are: 

1.Rewrite the application so statements do not continually reparse. 
2.Reduce parsing by using the initialization parameter SESSION_CACHED_CURSORS. 
3.Use bind variables to reduce parsing. 

Reference:
Oracle Tuning Guide

   
            相关内容 
          
              产品 
            
       Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition