oracle调优
jiawancai
IT
展开
-
Opt_param: a new optimizer hint for 10gR2
"OPT_PARAM" is a new optimizer hint introduced in 10gR2. This hint behaves the same way as setting a parameter (e.g, using alter session) but the effect is for the next statement only. Two IN params a转载 2007-02-27 21:56:00 · 947 阅读 · 0 评论 -
Shows the reason for multiple statement childs in shared pool
rem output only those statements that have more than 5 versions:define versions=5select version_count,address,hash_value,parsing_schema_name,reason,sql_text from (selectaddress,||decode(max(转载 2007-03-27 13:24:00 · 821 阅读 · 0 评论 -
Explain plan for last executed statement
define plan_table=PLAN_TABLEset linesize 132 pagesize 1000 feedback off verify off column statement_id new_value statement_idcolumn prev_sql_addr new_value sql_addrselect prev_sql_addr||/||prev_chil转载 2007-03-27 13:07:00 · 674 阅读 · 0 评论