- 博客(2)
- 收藏
- 关注
转载 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
转载 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
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人