Trace file /u01/app/oracle/diag/rdbms/wcnetdb/wcnetdb1/trace/wcnetdb1_ora_28257.trc Oracle Database 11g Release 11.1.0.7.0 - 64bit Production With the Real Application Clusters option ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1 System name: Linux Node name: liveora1.webcollage.net Release: 2.6.18-128.4.1.el5 Version: #1 SMP Thu Jul 23 19:59:19 EDT 2009 Machine: x86_64 Instance name: wcnetdb1 Redo thread mounted by this instance: 1 Oracle process number: 341 Unix process pid: 28257, image: oracle@liveora1.webcollage.net *** 2011-04-12 11:50:47.077 *** SESSION ID:(836.8325) 2011-04-12 11:50:47.077 *** CLIENT ID:(LIVE2009R1MC:WCNET\LIVEMC) 2011-04-12 11:50:47.077 *** SERVICE NAME:(taf_online) 2011-04-12 11:50:47.077 *** MODULE NAME:(tomcat5.exe) 2011-04-12 11:50:47.077 *** ACTION NAME:() 2011-04-12 11:50:47.077 --- PROTOCOL VIOLATION DETECTED --- ----- Dump Cursor sql_id=465dq2gqard9w xsc=0x2b932a378ba8 cur=0x2b9329ee4b90 ----- Dump Parent Cursor sql_id=465dq2gqard9w phd=0x6573e75a0 plk=0x64f1e3208 sqltxt(0x6573e75a0)=select distinct user0_.Id as Id1_, user0_.UpdateTime as UpdateTime1_, user0_.active as active1_, user0_.password as password1_, user0_.isInternal as isInternal1_, user0_.firstName as firstName1_, user0_.lastName as lastName1_, user0_.manufacturerId as manufac21_1_, user0_.showInactiveItems as showInac8_1_, user0_.email as email1_, user0_.title as title1_, user0_.PhoneNumber as PhoneNu11_1_, user0_.notes as notes1_, user0_.isEnabled as isEnabled1_, user0_.dateCreated as dateCre14_1_, user0_.temporaryAssignedPassword as tempora15_1_, user0_.confirmationDate as confirm16_1_, user0_.shouldNotConfirm as shouldN17_1_, user0_.tempPasswordExpiration as tempPas18_1_, user0_.tmpAssignedPasswordUpdateTime as tmpAssi19_1_, user0_.optInDate as optInDate1_, roles1_.userId as userId0__, roles1_.role as role0__, roles1_.roleAcronym as roleAcro3_0__, roles1_.consumerSiteId as consumer4_0__, roles1_.campaignId as campaignId0__, roles1_.moduleId as moduleId0__ from Users user0_ left outer join UsersRoles roles1_ on user0_.Id=roles1_.userId inner join UsersNotifications notificati2_ on user0_.Id=notificati2_.userId where user0_.isInternal=:1 and notificati2_.notificationId=:2 and notificati2_.moduleId=:3 order by roles1_.role asc hash=a1860ffa96d16beb4315b613ecabb53c parent=0x617c0ef60 maxchild=07 plk=0x64f1e3208 ppn=n cursor instantiation=0x2b932a378ba8 used=1302623446 exec_id=16777231 exec=1 child#6(0x6579cb188) pcs=0x617075a00 clk=0x64dbe8378 ci=0x616c21d50 pn=0x64cfc09e8 ctx=0x5e305f098 kgsccflg=0 llk[0x2b932a378bb0,0x2b932a378bb0] idx=0 xscflg=c0190676 fl2=5d000008 fl3=42222008 fl4=180 sharing failure(s)=800000040000 ----- Bind Info (kkscoacd) ----- Bind#0 oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00 oacflg=03 fl2=1000000 frm=00 csi=00 siz=72 off=0 kxsbbbfp=2b932a34cef0 bln=22 avl=00 flg=05 Bind#1 oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00 oacflg=03 fl2=1000000 frm=00 csi=00 siz=0 off=24 kxsbbbfp=2b932a34cf08 bln=22 avl=00 flg=01 Bind#2 oacdty=02 mxl=22(21) mxlc=00 mal=00 scl=00 pre=00 oacflg=03 fl2=1000000 frm=00 csi=00 siz=0 off=48 kxsbbbfp=2b932a34cf20 bln=22 avl=00 flg=01 Frames pfr 0x2b932a8068d8 siz=35104 efr 0x2b932a8067a8 siz=35088 kxscphp=0x2b932ac56c68 siz=984 inu=520 nps=440 kxscbhp=0x2b932a796298 siz=984 inu=280 nps=96 kxscwhp=0x2b932afa8ba8 siz=21584 inu=19696 nps=1816 Starting SQL statement dump SQL Information user_id=101 user_name=LIVE2009R1MC module=tomcat5.exe action= sql_id=465dq2gqard9w plan_hash_value=-153763842 problem_type=4 ----- Current SQL Statement for this session (sql_id=465dq2gqard9w) ----- select distinct user0_.Id as Id1_, user0_.UpdateTime as UpdateTime1_, user0_.active as active1_, user0_.password as password1_, user0_.isInternal as isInternal1_, user0_.firstName as firstName1_, user0_.lastName as lastName1_, user0_.manufacturerId as manufac21_1_, user0_.showInactiveItems as showInac8_1_, user0_.email as email1_, user0_.title as title1_, user0_.PhoneNumber as PhoneNu11_1_, user0_.notes as notes1_, user0_.isEnabled as isEnabled1_, user0_.dateCreated as dateCre14_1_, user0_.temporaryAssignedPassword as tempora15_1_, user0_.confirmationDate as confirm16_1_, user0_.shouldNotConfirm as shouldN17_1_, user0_.tempPasswordExpiration as tempPas18_1_, user0_.tmpAssignedPasswordUpdateTime as tmpAssi19_1_, user0_.optInDate as optInDate1_, roles1_.userId as userId0__, roles1_.role as role0__, roles1_.roleAcronym as roleAcro3_0__, roles1_.consumerSiteId as consumer4_0__, roles1_.campaignId as campaignId0__, roles1_.moduleId as moduleId0__ from Users user0_ left outer join UsersRoles roles1_ on user0_.Id=roles1_.userId inner join UsersNotifications notificati2_ on user0_.Id=notificati2_.userId where user0_.isInternal=:1 and notificati2_.notificationId=:2 and notificati2_.moduleId=:3 order by roles1_.role asc sql_text_length=1230 sql=select distinct user0_.Id as Id1_, user0_.UpdateTime as UpdateTime1_, user0_.active as active1_, user0_.password as password1_, user0_.isInternal as isInternal1_, user0_.firstName as firstName1_, user0_.lastName as lastName1_, user0_.manufacturerId as manu sql=fac21_1_, user0_.showInactiveItems as showInac8_1_, user0_.email as email1_, user0_.title as title1_, user0_.PhoneNumber as PhoneNu11_1_, user0_.notes as notes1_, user0_.isEnabled as isEnabled1_, user0_.dateCreated as dateCre14_1_, user0_.temporaryAssigned sql=Password as tempora15_1_, user0_.confirmationDate as confirm16_1_, user0_.shouldNotConfirm as shouldN17_1_, user0_.tempPasswordExpiration as tempPas18_1_, user0_.tmpAssignedPasswordUpdateTime as tmpAssi19_1_, user0_.optInDate as optInDate1_, roles1_.userId sql= as userId0__, roles1_.role as role0__, roles1_.roleAcronym as roleAcro3_0__, roles1_.consumerSiteId as consumer4_0__, roles1_.campaignId as campaignId0__, roles1_.moduleId as moduleId0__ from Users user0_ left outer join UsersRoles roles1_ on user0_.Id=ro sql=les1_.userId inner join UsersNotifications notificati2_ on user0_.Id=notificati2_.userId where user0_.isInternal=:1 and notificati2_.notificationId=:2 and notificati2_.moduleId=:3 order by roles1_.role asc Compilation Environment Dump optimizer_mode_hinted = false optimizer_features_hinted = 0.0.0 parallel_execution_enabled = false parallel_query_forced_dop = 0 parallel_dml_forced_dop = 0 parallel_ddl_forced_degree = 0 parallel_ddl_forced_instances = 0 _query_rewrite_fudge = 90 optimizer_features_enable = 11.1.0.7 _optimizer_search_limit = 5 cpu_count = 16 active_instance_count = 0 parallel_threads_per_cpu = 2 hash_area_size = 131072 bitmap_merge_area_size = 1048576 sort_area_size = 65536 sort_area_retained_size = 0 _sort_elimination_cost_ratio = 0 _optimizer_block_size = 8192 _sort_multiblock_read_count = 2 _hash_multiblock_io_count = 0 _db_file_optimizer_read_count = 8 _optimizer_max_permutations = 2000 pga_aggregate_target = 2555904 KB _pga_max_size = 511180 KB _query_rewrite_maxdisjunct = 257 _smm_auto_min_io_size = 56 KB _smm_auto_max_io_size = 248 KB _smm_min_size = 1024 KB _smm_max_size = 255590 KB _smm_px_max_size = 1277952 KB _cpu_to_io = 0 _optimizer_undo_cost_change = 11.1.0.7 parallel_query_mode = enabled parallel_dml_mode = disabled parallel_ddl_mode = enabled optimizer_mode = all_rows sqlstat_enabled = false _optimizer_percent_parallel = 101 _always_anti_join = choose _always_semi_join = choose _optimizer_mode_force = true _partition_view_enabled = true _always_star_transformation = false _query_rewrite_or_error = false _hash_join_enabled = true cursor_sharing = exact _b_tree_bitmap_plans = true star_transformation_enabled = false _optimizer_cost_model = choose _new_sort_cost_estimate = true _complex_view_merging = true _unnest_subquery = true _eliminate_common_subexpr = true _pred_move_around = true _convert_set_to_join = false _push_join_predicate = true _push_join_union_view = true _fast_full_scan_enabled = true _optim_enhance_nnull_detection = true _parallel_broadcast_enabled = true _px_broadcast_fudge_factor = 100 _ordered_nested_loop = true _no_or_expansion = false optimizer_index_cost_adj = 1 optimizer_index_caching = 0 _system_index_caching = 0 _disable_datalayer_sampling = false query_rewrite_enabled = true query_rewrite_integrity = enforced _query_cost_rewrite = true _query_rewrite_2 = true _query_rewrite_1 = true _query_rewrite_expression = true _query_rewrite_jgmigrate = true _query_rewrite_fpc = true _query_rewrite_drj = true _full_pwise_join_enabled = true _partial_pwise_join_enabled = true _left_nested_loops_random = true _improved_row_length_enabled = true _index_join_enabled = true _enable_type_dep_selectivity = true _improved_outerjoin_card = true _optimizer_adjust_for_nulls = true _optimizer_degree = 0 _use_column_stats_for_function = true _subquery_pruning_enabled = true _subquery_pruning_mv_enabled = false _or_expand_nvl_predicate = true _like_with_bind_as_equality = false _table_scan_cost_plus_one = true _cost_equality_semi_join = true _default_non_equality_sel_check = true _new_initial_join_orders = true _oneside_colstat_for_equijoins = true _optim_peek_user_binds = true _minimal_stats_aggregation = true _force_temptables_for_gsets = false workarea_size_policy = auto _smm_auto_cost_enabled = true _gs_anti_semi_join_allowed = true _optim_new_default_join_sel = true optimizer_dynamic_sampling = 1 _pre_rewrite_push_pred = true _optimizer_new_join_card_computation = true _union_rewrite_for_gs = yes_gset_mvs _generalized_pruning_enabled = true _optim_adjust_for_part_skews = true _force_datefold_trunc = false statistics_level = typical _optimizer_system_stats_usage = true skip_unusable_indexes = true _remove_aggr_subquery = true _optimizer_push_down_distinct = 0 _dml_monitoring_enabled = true _optimizer_undo_changes = false _predicate_elimination_enabled = true _nested_loop_fudge = 100 _project_view_columns = true _local_communication_costing_enabled = true _local_communication_ratio = 50 _query_rewrite_vop_cleanup = true _slave_mapping_enabled = true _optimizer_cost_based_transformation = linear _optimizer_mjc_enabled = true _right_outer_hash_enable = true _spr_push_pred_refspr = true _optimizer_cache_stats = false _optimizer_cbqt_factor = 50 _optimizer_squ_bottomup = true _fic_area_size = 131072 _optimizer_skip_scan_enabled = true _optimizer_cost_filter_pred = false _optimizer_sortmerge_join_enabled = true _optimizer_join_sel_sanity_check = true _mmv_query_rewrite_enabled = true _bt_mmv_query_rewrite_enabled = true _add_stale_mv_to_dependency_list = true _distinct_view_unnesting = false _optimizer_dim_subq_join_sel = true _optimizer_disable_strans_sanity_checks = 0 _optimizer_compute_index_stats = true _push_join_union_view2 = true _optimizer_ignore_hints = false _optimizer_random_plan = 0 _query_rewrite_setopgrw_enable = true _optimizer_correct_sq_selectivity = true _disable_function_based_index = false _optimizer_join_order_control = 3 _optimizer_cartesian_enabled = true _optimizer_starplan_enabled = true _extended_pruning_enabled = true _optimizer_push_pred_cost_based = true _optimizer_null_aware_antijoin = true _optimizer_extend_jppd_view_types = true _sql_model_unfold_forloops = run_time _enable_dml_lock_escalation = false _bloom_filter_enabled = true _update_bji_ipdml_enabled = 0 _optimizer_extended_cursor_sharing = udo _dm_max_shared_pool_pct = 1 _optimizer_cost_hjsmj_multimatch = true _optimizer_transitivity_retain = true _px_pwg_enabled = true optimizer_secure_view_merging = true _optimizer_join_elimination_enabled = true flashback_table_rpi = non_fbt _optimizer_cbqt_no_size_restriction = true _optimizer_enhanced_filter_push = true _optimizer_filter_pred_pullup = true _rowsrc_trace_level = 0 _simple_view_merging = true _optimizer_rownum_pred_based_fkr = true _optimizer_better_inlist_costing = all _optimizer_self_induced_cache_cost = false _optimizer_min_cache_blocks = 10 _optimizer_or_expansion = depth _optimizer_order_by_elimination_enabled = true _optimizer_outer_to_anti_enabled = true _selfjoin_mv_duplicates = true _dimension_skip_null = true _force_rewrite_enable = false _optimizer_star_tran_in_with_clause = true _optimizer_complex_pred_selectivity = true _optimizer_connect_by_cost_based = true _gby_hash_aggregation_enabled = true _globalindex_pnum_filter_enabled = true _px_minus_intersect = true _fix_control_key = 0 _force_slave_mapping_intra_part_loads = false _force_tmp_segment_loads = false _query_mmvrewrite_maxpreds = 10 _query_mmvrewrite_maxintervals = 5 _query_mmvrewrite_maxinlists = 5 _query_mmvrewrite_maxdmaps = 10 _query_mmvrewrite_maxcmaps = 20 _query_mmvrewrite_maxregperm = 512 _query_mmvrewrite_maxmergedcmaps = 50 _query_mmvrewrite_maxqryinlistvals = 500 _disable_parallel_conventional_load = false _trace_virtual_columns = false _replace_virtual_columns = true _virtual_column_overload_allowed = true _kdt_buffering = true _first_k_rows_dynamic_proration = true _optimizer_sortmerge_join_inequality = true _aw_row_source_enabled = true _optimizer_aw_stats_enabled = true _bloom_pruning_enabled = true result_cache_mode = MANUAL _px_ual_serial_input = true _optimizer_skip_scan_guess = false _enable_row_shipping = true _row_shipping_threshold = 80 _row_shipping_explain = false transaction_isolation_level = read_commited _optimizer_distinct_elimination = true _optimizer_multi_level_push_pred = true _optimizer_group_by_placement = true _optimizer_rownum_bind_default = 10 _enable_query_rewrite_on_remote_objs = true _optimizer_extended_cursor_sharing_rel = simple _optimizer_adaptive_cursor_sharing = true _direct_path_insert_features = 0 _optimizer_improve_selectivity = true optimizer_use_pending_statistics = false _optimizer_enable_density_improvements = true _optimizer_aw_join_push_enabled = true _optimizer_connect_by_combine_sw = true _enable_pmo_ctas = 0 _optimizer_native_full_outer_join = force _bloom_predicate_enabled = true _optimizer_enable_extended_stats = true _is_lock_table_for_ddl_wait_lock = 0 _pivot_implementation_method = choose optimizer_capture_sql_plan_baselines = false optimizer_use_sql_plan_baselines = true _optimizer_star_trans_min_cost = 0 _optimizer_star_trans_min_ratio = 0 _with_subquery = OPTIMIZER _optimizer_fkr_index_cost_bias = 10 _optimizer_use_subheap = true _parallel_policy = manual parallel_degree = 0 _parallel_time_threshold = 10 _parallel_time_unit = 10 _optimizer_or_expansion_subheap = true _optimizer_free_transformation_heap = true _optimizer_reuse_cost_annotations = true _result_cache_auto_size_threshold = 100 _result_cache_auto_time_threshold = 1000 _optimizer_nested_rollup_for_gset = 100 _nlj_batching_enabled = 1 parallel_query_default_dop = 0 is_recur_flags = 0 optimizer_use_invisible_indexes = false flashback_data_archive_internal_cursor = 0 _optimizer_extended_stats_usage_control = 224 _parallel_syspls_obey_force = true cell_offload_processing = true _rdbms_internal_fplib_enabled = false db_file_multiblock_read_count = 128 _bloom_folding_enabled = true _mv_generalized_oj_refresh_opt = true cell_offload_compaction = ADAPTIVE cell_offload_plan_display = AUTO _bloom_predicate_pushdown_to_storage = true _bloom_vector_elements = 0 _bloom_pushing_max = 524288 ====================== END SQL Statement Dump ====================== opitsk: network error occurred while two-task server trying tosend break; error code = 3115