shivamy/output_proc_shell_check_files

## output_proc_shell_check_files
Connecting to the database ora-shell-shiva.
ORA-20000: ORU-10027: buffer overflow, limit of 20000 bytes
ORA-06512: at "SYS.DBMS_OUTPUT", line 32
ORA-06512: at "SYS.DBMS_OUTPUT", line 97
ORA-06512: at "SYS.DBMS_OUTPUT", line 112
ORA-06512: at "EA_SCHEMA.PROC_TEMP_ANALYSIS_CHECK_FILES", line 10
ORA-06512: at line 2
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Corridor.sgy', original_file_name) > 90
1 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Corridor_tvsw.sgy', original_file_name) > 90
2 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('se_shot_cdp_stack.sgy', original_file_name) > 90
3 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('nw_shot_cdp_stack.sgy', original_file_name) > 90
4 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('nw_shot_cdp_stack_tvsw.sgy', original_file_name) > 90
5 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('se_shot_cdp_stack_tvsw.sgy', original_file_name) > 90
6 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_stacks_y.sgy', original_file_name) > 90
7 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_stacks_y.sgy', original_file_name) > 90
8 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('3D_Stack_tvsw.sgy', original_file_name) > 90
9 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_stacks_y.sgy', original_file_name) > 90
10 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_down_x.sgy', original_file_name) > 90
11 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_down_y.sgy', original_file_name) > 90
12 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_stacks_x.sgy', original_file_name) > 90
13 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_stacks_x.sgy', original_file_name) > 90
14 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_down_y.sgy', original_file_name) > 90
15 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_down_z.sgy', original_file_name) > 90
16 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_down_x.sgy', original_file_name) > 90
17 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_main_y.sgy', original_file_name) > 90
18 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_down_x.sgy', original_file_name) > 90
19 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_down_y.sgy', original_file_name) > 90
20 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_down_z.sgy', original_file_name) > 90
21 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_stacks_z.sgy', original_file_name) > 90
22 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_stacks_x.sgy', original_file_name) > 90
23 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_stacks_z.sgy', original_file_name) > 90
24 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_main_x.sgy', original_file_name) > 90
25 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_main_x.sgy', original_file_name) > 90
26 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_main_z.sgy', original_file_name) > 90
27 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_main_z.sgy', original_file_name) > 90
28 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_stacks_z.sgy', original_file_name) > 90
29 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_main_z.sgy', original_file_name) > 90
30 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_B_gac_down_z.sgy', original_file_name) > 90
31 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_main_y.sgy', original_file_name) > 90
32 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_C_gac_main_y.sgy', original_file_name) > 90
33 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('3D_Stack.sgy', original_file_name) > 90
34 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('source_A_gac_main_x.sgy', original_file_name) > 90
35 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Shell_Slack_Box_54_2_28_1P_BARS_SP_PS_Mode_Converted.Segy', original_file_name) > 90
36 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Shell_Slack_Box_54_2_28_1P_BARS_Shear_Reflections.Segy', original_file_name) > 90
37 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Shell_Slack_Box_54_2_28_1P_BARS_PP_Reflections.Segy', original_file_name) > 90
38 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('Shell_Slack_Box_54_2_28_1P_BARS_Dipole_Shear_Reflections.segy', original_file_name) > 90
39 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-downdcon.segy', original_file_name) > 90
40 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-down.segy', original_file_name) > 90
41 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-upfinal.segy', original_file_name) > 90
42 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-upmed.segy', original_file_name) > 90
43 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk30.segy', original_file_name) > 90
44 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk40.segy', original_file_name) > 90
45 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('updcon.segy', original_file_name) > 90
46 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk50.segy', original_file_name) > 90
47 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-updcon.segy', original_file_name) > 90
48 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-upfinal.segy', original_file_name) > 90
49 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('upfinal.segy', original_file_name) > 90
50 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal50.segy', original_file_name) > 90
51 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('up.segy', original_file_name) > 90
52 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-downdcon.segy', original_file_name) > 90
53 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk15.segy', original_file_name) > 90
54 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk10.segy', original_file_name) > 90
55 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-updcon.segy', original_file_name) > 90
56 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-up.segy', original_file_name) > 90
57 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upmed.segy', original_file_name) > 90
58 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('upmed.segy', original_file_name) > 90
59 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('downdcon.segy', original_file_name) > 90
60 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstk20.segy', original_file_name) > 90
61 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-downdcon.segy', original_file_name) > 90
62 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('total.segy', original_file_name) > 90
63 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-down.segy', original_file_name) > 90
64 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg50.segy', original_file_name) > 90
65 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-up.segy', original_file_name) > 90
66 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal15.segy', original_file_name) > 90
67 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('down.segy', original_file_name) > 90
68 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg40.segy', original_file_name) > 90
69 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg15.segy', original_file_name) > 90
70 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg30.segy', original_file_name) > 90
71 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-total.segy', original_file_name) > 90
72 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg20.segy', original_file_name) > 90
73 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-total.segy', original_file_name) > 90
74 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-up.segy', original_file_name) > 90
75 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert_rot.segy', original_file_name) > 90
76 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('perp-total.segy', original_file_name) > 90
77 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg40.segy', original_file_name) > 90
78 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal20.segy', original_file_name) > 90
79 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg30.segy', original_file_name) > 90
80 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-cstkintg10.segy', original_file_name) > 90
81 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('vert-updcon.segy', original_file_name) > 90
82 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal40.segy', original_file_name) > 90
83 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal30.segy', original_file_name) > 90
84 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg10.segy', original_file_name) > 90
85 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal10.segy', original_file_name) > 90
86 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg15.segy', original_file_name) > 90
87 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg20.segy', original_file_name) > 90
88 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinalintg50.segy', original_file_name) > 90
89 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('horz_rot.segy', original_file_name) > 90
90 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('stk3c.segy', original_file_name) > 90
91 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('raw.segy', original_file_name) > 90
92 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('tran-upfinal.segy', original_file_name) > 90
93 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('31_vivsp_corstk_6_80hz_depth.sgy', original_file_name) > 90
94 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('24_vivsp_corstk_whole_waveform_depth.sgy', original_file_name) > 90
95 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('36_vivsp_synth_seismogram_5_25hz_time.sgy', original_file_name) > 90
96 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('46_vivsp_synth_seismogram_5_40hz_depth.sgy', original_file_name) > 90
97 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('21_vivsp_corstk_6_50hz_time.sgy', original_file_name) > 90
98 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('19_vivsp_corstk_6_30hz_time.sgy', original_file_name) > 90
99 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('25_vivsp_corstk_6_15hz_depth.sgy', original_file_name) > 90
100 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('16_vivsp_corstk_whole_waveform_time.sgy', original_file_name) > 90
101 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('30_vivsp_corstk_6_60hz_depth.sgy', original_file_name) > 90
102 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('27_vivsp_corstk_6_30hz_depth.sgy', original_file_name) > 90
103 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('44_vivsp_synth_seismogram_5_25hz_depth.sgy', original_file_name) > 90
104 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('23_vivsp_corstk_6_80hz_time.sgy', original_file_name) > 90
105 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('34_vivsp_synth_seismogram_5_15hz_time.sgy', original_file_name) > 90
106 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('47_vivsp_synth_seismogram_5_50hz_depth.sgy', original_file_name) > 90
107 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('32_vivsp_CDP_Mapping_time.sgy', original_file_name) > 90
108 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('39_vivsp_synth_seismogram_5_50hz_time.sgy', original_file_name) > 90
109 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('26_vivsp_corstk_6_20hz_depth.sgy', original_file_name) > 90
110 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('14_vivsp_deconvolved_upgoing_P_owt.sgy', original_file_name) > 90
111 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('11_vivsp_try.sgy', original_file_name) > 90
112 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('15_vivsp_deconvolved_upgoing_P_twt.sgy', original_file_name) > 90
113 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('40_vivsp_synth_seismogram_5_60hz_time.sgy', original_file_name) > 90
114 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('17_vivsp_corstk_6_15hz_time.sgy', original_file_name) > 90
115 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('38_vivsp_synth_seismogram_5_40hz_time.sgy', original_file_name) > 90
116 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('42_vivsp_synth_seismogram_5_15hz_depth.sgy', original_file_name) > 90
117 : 0
SELECT count(1) cnt FROM ea_schema.temp_analysis_information_item WHERE SYS.UTL_MATCH.EDIT_DISTANCE_SIMILARITY('20_vivsp_corstk_6_40hz_time.sgy', original_file_name) > 90
118 : 0
Process exited.
Disconnecting from the database ora-shell-shiva.


---  with similarity > 90 for first 1K (sl_num 0 to 1000)
-- Took > 20mins with ~150K in temp_analysis_file_to_check.  ALL had now matches!
1 : 0
2 : 0
3 : 0
4 : 0
5 : 0
6 : 0
7 : 0
8 : 0
9 : 0
10 : 0

--- With sl_num between 1000 and 1100 and simi > 90.  Had 3 out of 100 matched
1000 : 0
1001 : 0

1021 : 0
1022 : 0
1023 : 1  <<
1024 : 0
1025 : 0
1026 : 0

1046 : 0
1047 : 0
1048 : 0
1049 : 1
1050 : 0

1060 : 0
1061 : 1
1062 : 0
1063 : 0

1100 : 0
Process exited.

-- With sl_num between 1000 and 1100 and simi > 50.  Had 4 matches multiple entries!
1000 : 0

1022 : 0
1023 : 7  <<
1024 : 0

1048 : 0
1049 : 9
1050 : 0

1056 : 0
1057 : 0
1058 : 2
1059 : 0
1060 : 0
1061 : 25 <<
1062 : 0

1079 : 0
1080 : 13
1081 : 0

1100 : 0
Process exited.

---------
-- Tested on one of the entry sl_num 1023 with > 90 (had 1 match), > 50 (had 7 matches) and > 80 (had 2 matches)
---------

-- sl_num between 1000 and 2000 and simi > 80  with JARO_WINKLER_SIMILARITY

1003 : 0
1004 : 1
1005 : 0

1022 : 0
1023 : 2

1048 : 0
1049 : 11
1050 : 0

1058 : 2
1059 : 0
1060 : 0
1061 : 15

1079 : 0
1080 : 12
1081 : 0
1082 : 0

1112 : 0
1113 : 0
1114 : 2
1115 : 2
1116 : 2

1120 : 0
1121 : 1
1122 : 0


1201 : 0
1202 : 4
1203 : 1
1204 : 0

1208 : 0
1209 : 4
1210 : 10
1211 : 10
1212 : 0

1242 : 0
1243 : 2
1244 : 0

1500 : 0
Process exited.
Disconnecting from the database ora-shell-shiva.