158 lines
5.7 KiB
SQL
158 lines
5.7 KiB
SQL
set linesize 201
|
|
|
|
set echo on
|
|
/*
|
|
01 sql_type_mismatch 02 optimizer_mismatch 03 outline_mismatch 04 stats_row_mismatch 05 literal_mismatch
|
|
06 force_hard_parse 07 explain_plan_cursor 08 buffered_dml_mismatch 09 pdml_env_mismatch 10 inst_drtld_mismatch
|
|
11 slave_qc_mismatch 12 typecheck_mismatch 13 auth_check_mismatch 14 bind_mismatch 15 describe_mismatch
|
|
16 language_mismatch 17 translation_mismatch 18 bind_equiv_failure 19 insuff_privs 20 insuff_privs_rem
|
|
21 remote_trans_mismatch 22 logminer_session_mismatch 23 incomp_ltrl_mismatch 24 overlap_time_mismatch 25 edition_mismatch
|
|
26 mv_query_gen_mismatch 27 user_bind_peek_mismatch 28 typchk_dep_mismatch 29 no_trigger_mismatch 30 flashback_cursor
|
|
31 anydata_transformation 32 pddl_env_mismatch 33 top_level_rpi_cursor 34 different_long_length 35 logical_standby_apply
|
|
36 diff_call_durn 37 bind_uacs_diff 38 plsql_cmp_switchs_diff 39 cursor_parts_mismatch 40 stb_object_mismatch
|
|
41 crossedition_trigger_mismatch 42 pq_slave_mismatch 43 top_level_ddl_mismatch 44 multi_px_mismatch 45 bind_peeked_pq_mismatch
|
|
46 mv_rewrite_mismatch 47 roll_invalid_mismatch 48 optimizer_mode_mismatch 49 px_mismatch 50 mv_staleobj_mismatch
|
|
51 flashback_table_mismatch 52 litrep_comp_mismatch 53 plsql_debug 54 load_optimizer_stats 55 acl_mismatch
|
|
56 flashback_archive_mismatch 57 lock_user_schema_failed 58 remote_mapping_mismatch 59 load_runtime_heap_failed 60 hash_match_failed
|
|
61 purged_cursor 62 bind_length_upgradeable 63 use_feedback_stats
|
|
*/
|
|
set echo off
|
|
|
|
column 01 format a2
|
|
column 02 format a2
|
|
column 03 format a2
|
|
column 04 format a2
|
|
column 05 format a2
|
|
column 06 format a2
|
|
column 07 format a2
|
|
column 08 format a2
|
|
column 09 format a2
|
|
column 10 format a2
|
|
column 11 format a2
|
|
column 12 format a2
|
|
column 13 format a2
|
|
column 14 format a2
|
|
column 15 format a2
|
|
column 16 format a2
|
|
column 17 format a2
|
|
column 18 format a2
|
|
column 19 format a2
|
|
column 20 format a2
|
|
column 21 format a2
|
|
column 22 format a2
|
|
column 23 format a2
|
|
column 24 format a2
|
|
column 25 format a2
|
|
column 26 format a2
|
|
column 27 format a2
|
|
column 28 format a2
|
|
column 29 format a2
|
|
column 30 format a2
|
|
column 31 format a2
|
|
column 32 format a2
|
|
column 33 format a2
|
|
column 34 format a2
|
|
column 35 format a2
|
|
column 36 format a2
|
|
column 37 format a2
|
|
column 38 format a2
|
|
column 39 format a2
|
|
column 40 format a2
|
|
column 41 format a2
|
|
column 42 format a2
|
|
column 43 format a2
|
|
column 44 format a2
|
|
column 45 format a2
|
|
column 46 format a2
|
|
column 47 format a2
|
|
column 48 format a2
|
|
column 49 format a2
|
|
column 50 format a2
|
|
column 51 format a2
|
|
column 52 format a2
|
|
column 53 format a2
|
|
column 54 format a2
|
|
column 55 format a2
|
|
column 56 format a2
|
|
column 57 format a2
|
|
column 58 format a2
|
|
column 59 format a2
|
|
column 60 format a2
|
|
column 61 format a2
|
|
column 62 format a2
|
|
column 63 format a2
|
|
|
|
|
|
select
|
|
child_number
|
|
,sql_type_mismatch "01"
|
|
,optimizer_mismatch "02"
|
|
,outline_mismatch "03"
|
|
,stats_row_mismatch "04"
|
|
,literal_mismatch "05"
|
|
,force_hard_parse "06"
|
|
,explain_plan_cursor "07"
|
|
,buffered_dml_mismatch "08"
|
|
,pdml_env_mismatch "09"
|
|
,inst_drtld_mismatch "10"
|
|
,slave_qc_mismatch "11"
|
|
,typecheck_mismatch "12"
|
|
,auth_check_mismatch "13"
|
|
,bind_mismatch "14"
|
|
,describe_mismatch "15"
|
|
,language_mismatch "16"
|
|
,translation_mismatch "17"
|
|
,bind_equiv_failure "18"
|
|
,insuff_privs "19"
|
|
,insuff_privs_rem "20"
|
|
,remote_trans_mismatch "21"
|
|
,logminer_session_mismatch "22"
|
|
,incomp_ltrl_mismatch "23"
|
|
,overlap_time_mismatch "24"
|
|
,edition_mismatch "25"
|
|
,mv_query_gen_mismatch "26"
|
|
,user_bind_peek_mismatch "27"
|
|
,typchk_dep_mismatch "28"
|
|
,no_trigger_mismatch "29"
|
|
,flashback_cursor "30"
|
|
,anydata_transformation "31"
|
|
,pddl_env_mismatch "32"
|
|
,top_level_rpi_cursor "33"
|
|
,different_long_length "34"
|
|
,logical_standby_apply "35"
|
|
,diff_call_durn "36"
|
|
,bind_uacs_diff "37"
|
|
,plsql_cmp_switchs_diff "38"
|
|
,cursor_parts_mismatch "39"
|
|
,stb_object_mismatch "40"
|
|
,crossedition_trigger_mismatch "41"
|
|
,pq_slave_mismatch "42"
|
|
,top_level_ddl_mismatch "43"
|
|
,multi_px_mismatch "44"
|
|
,bind_peeked_pq_mismatch "45"
|
|
,mv_rewrite_mismatch "46"
|
|
,roll_invalid_mismatch "47"
|
|
,optimizer_mode_mismatch "48"
|
|
,px_mismatch "49"
|
|
,mv_staleobj_mismatch "50"
|
|
,flashback_table_mismatch "51"
|
|
,litrep_comp_mismatch "52"
|
|
,plsql_debug "53"
|
|
,load_optimizer_stats "54"
|
|
,acl_mismatch "55"
|
|
,flashback_archive_mismatch "56"
|
|
,lock_user_schema_failed "57"
|
|
,remote_mapping_mismatch "58"
|
|
,load_runtime_heap_failed "59"
|
|
,hash_match_failed "60"
|
|
,purged_cursor "61"
|
|
,bind_length_upgradeable "62"
|
|
,use_feedback_stats "63"
|
|
from
|
|
v$sql_shared_cursor
|
|
where
|
|
sql_id = '&sql_id'
|
|
order by
|
|
child_number
|
|
;
|