eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

ODM.ODM_MODEL_UTIL dependencies on DUAL

Line 1: PACKAGE BODY odm_model_util wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
203
2 :e:
1PACKAGE:
1BODY:
1ODM_MODEL_UTIL:
1C_PACKAGE_NAME:
1CONSTANT:
1VARCHAR2:
130:
1INSERT_BENCHMARK_MESSAGE:
1P_MESSAGE:
1MESSAGE_SUBSTR:
150:
1MESSAGE_DATE:
1DATE:
1DBMS_SUBSTR:
1120:
1I:
1PLS_INTEGER:
1V_TABLE_NAME:
1TABLE_NAME_TYPE:
1BENCHMARK_MESSAGES:
1V_SQL_STMT:
1SQL_STATEMENT_TYPE:
1TABLE_EXIST:
1SYSDATE:
1DUAL:
10:
1SUBSTR:
11:
1WHILE:
1IS NOT NULL:
1LOOP:
1INSERT INTO :
1||:
1 VALUES(message_sequence.nextval, TO_DATE(:
1':
1TO_CHAR:
1DD-MON_YYYY HH24::MI::SS:
1, :
1), :
1REPLACE:
1'':
1):
1EXECUTE:
1IMMEDIATE:
1+:
1:
1COMMIT:
1OTHERS:
1FUNCTION:
1UNIQUE_SCHEMA_OBJECT_NAME:
1P_MINING_TASK_ID:
1MINING_TASK_ID_TYPE:
1RETURN:
1SCHEMA_OBJECT_NAME_TYPE:
1V_SCHEMA_OBJECT_NAME:
1V_UNIQUE_OBJECT_ID:
1UNIQUE_OBJECT_ID_TYPE:
1SEQ_ODM_UNIQUE_OBJECT_ID:
1NEXTVAL:
1Z:
1SYSTIMESTAMP:
1HH24_MI_SS_FF:
1DBMS_RANDOM:
1STRING:
110:
1UNIQUE_DBLINK_NAME:
1DBLINK_NAME_TYPE:
1UNIQUE_SEQUENCE_NAME:
1SEQUENCE_NAME_TYPE:
1UNIQUE_TABLE_NAME:
1UNIQUE_VIEW_NAME:
1VIEW_NAME_TYPE:
1UNIQUE_INDEX_NAME:
1INDEX_NAME_TYPE:
1UNIQUE_COLUMN_NAME:
1P_TABLE_NAME:
1TABLE_LOCATION_TYPE:
1COLUMN_NAME_TYPE:
1V_COLUMN_NAME:
1YYYYMMDDHH24MISSFF:
1CREATE_DBLINK:
1P_USER_NAME:
1P_PASSWORD:
1P_CONNECT_STRING:
1CONNECT_STRING_TYPE:
1P_DBLINK_NAME:
1P_DBLINK_CREATED:
1OUT:
1BOOLEAN:
1CREATE DATABASE LINK :
1 :
1CONNECT TO :
1IDENTIFIED BY :
1USING ':
1TRUE:
1CREATE_SEQUENCE:
1P_SEQUENCE_NAME:
1P_SEQUENCE_CREATED:
1CREATE SEQUENCE :
1CREATE_INDEX:
1P_COLUMN_LIST:
1COLUMN_LIST_TYPE:
1P_INDEX_NAME:
1P_INDEX_CREATED:
1V_SQL_COLUMNS:
1:
1COUNT:
1,:
1RTRIM:
1CREATE INDEX :
1 ON :
1:n (:
1CREATE_FUNCTION_INDEX:
1P_FUNCTION_STMT:
1:n (:
1CREATE_DISTINCT_TABLE:
1P_DISTINCT_TABLE_NAME:
1P_DISTINCT_TABLE_CREATED:
1CREATE TABLE :
1 AS :n SELECT DISTINCT :
1:n FROM :
1CREATE_SAMPLE_TABLE:
1P_SAMPLE_SIZE:
1NUMBER:
1P_SAMPLE_TABLE_NAME:
1P_SAMPLE_TABLE_CREATED:
1 AS :n SELECT :n FROM :
1 SAMPLE (:
1CREATE_SUBSET_TABLE:
1P_REFERENCE_TABLE_NAME:
1P_UNIQUE_ID_COLUMN_NAME:
1P_SUBSET_TABLE_NAME:
1P_SUBSET_TABLE_CREATED:
1V_SQL_UNIQUE:
1DENSE_RANK() OVER (ORDER BY :
1) :
1 AS:n SELECT :
1 t.:n FROM :
1 t:n WHERE (:
1) IN :n (SELECT :
1:n FROM :
1CREATE_MINUS_TABLE:
1P_DISCARD_TABLE_NAME:
1P_MINUS_TABLE_NAME:
1P_MINUS_TABLE_CREATED:
1 AS:n SELECT :n FROM :
1 :n MINUS:n SELECT :n FROM :
1DROP_SCHEMA_OBJECT:
1P_OBJECT_TYPE:
1P_OBJECT_NAME:
1P_OBJECT_CREATED:
1C_DEBUG_FLAG:
1NOT:
1=:
1DROP :
1FALSE:
1DROP_DBLINK:
1DATABASE LINK:
1DROP_TABLE:
1P_TABLE_CREATED:
1TABLE:
1DROP_VIEW:
1P_VIEW_NAME:
1P_VIEW_CREATED:
1VIEW:
1DROP_SEQUENCE:
1SEQUENCE:
1DROP_INDEX:
1INDEX:
1P_DEBUG_ENABLED:
1V_ID:
1INTEGER:
1C_SUBPROGRAM_NAME:
1DEBUG_DUMP:
1Enter :
1.:
1Parameter p_object_type:: :
1Parameter p_object_name:: :
1Parameter p_object_created:: TRUE:
1Parameter p_object_created:: FALSE:
1SELECT odm_debug_catalog_seq.nextval FROM dual:
1INSERT INTO odm_debug_catalog (id, object_type, object_name) :
1VALUES (::id, ::object_type, ::object_name):
1USING:
1DROP %object_type% %object_name%:
1%object_type%:
1%object_name%:
1Done:
1Leave :
1ROLLBACK:
1ROLLBACK_NR:
1Error :
1SQLERRM:
1RAISE:
1ANALYZE_TABLE:
1P_COMPUTATION_METHOD:
1E_VIEW_DETECTED:
1PRAGMA:
1EXCEPTION_INIT:
1-:
101702:
1C_AT_COMPUTE:
1ANALYZE TABLE :
1COMPUTE STATISTICS:
1ELSIF:
1C_AT_ESTIMATE:
1ESTIMATE STATISTICS SAMPLE :
1 PERCENT:
1COUNT_ALL:
1V_ROW_COUNT:
1SELECT COUNT() :n FROM :
1COUNT_DISTINCT:
1SELECT COUNT() :n FROM (SELECT DISTINCT :
1:n FROM :
1P_COLUMN_NAME:
1COMPUTE_PROFILE_STAT:
1P_CNT_PROFILE:
1P_AVG_PROFILE:
1V_SQL_WHERE:
1P_WHERE_CLAUSE:
1V_TC_SQL_STMT:
1SELECT COUNT() cnt_profile, AVG(cnt_item) avg_profile :
1 FROM (SELECT /+ PARALLEL (:
1) / COUNT(*) cnt_item :
1 FROM :
1 GROUP BY :
1getting profile count:
1got profile count:
1p_

1: PACKAGE BODY odm_model_util wrapped
0
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
3
b
9200000
1
4
0
203
2 :e:
1PACKAGE:
1BODY:
1ODM_MODEL_UTIL:
1C_PACKAGE_NAME:
1CONSTANT:
1VARCHAR2:
130:
1INSERT_BENCHMARK_MESSAGE:
1P_MESSAGE:
1MESSAGE_SUBSTR:
150:
1MESSAGE_DATE:
1DATE:
1DBMS_SUBSTR:
1120:
1I:
1PLS_INTEGER:
1V_TABLE_NAME:
1TABLE_NAME_TYPE:
1BENCHMARK_MESSAGES:
1V_SQL_STMT:
1SQL_STATEMENT_TYPE:
1TABLE_EXIST:
1SYSDATE:
1DUAL:
10:
1SUBSTR:
11:
1WHILE:
1IS NOT NULL:
1LOOP:
1INSERT INTO :
1||:
1 VALUES(message_sequence.nextval, TO_DATE(:
1':
1TO_CHAR:
1DD-MON_YYYY HH24::MI::SS:
1, :
1), :
1REPLACE:
1'':
1):
1EXECUTE:
1IMMEDIATE:
1+:
1*:
1COMMIT:
1OTHERS:
1FUNCTION:
1UNIQUE_SCHEMA_OBJECT_NAME:
1P_MINING_TASK_ID:
1MINING_TASK_ID_TYPE:
1RETURN:
1SCHEMA_OBJECT_NAME_TYPE:
1V_SCHEMA_OBJECT_NAME:
1V_UNIQUE_OBJECT_ID:
1UNIQUE_OBJECT_ID_TYPE:
1SEQ_ODM_UNIQUE_OBJECT_ID:
1NEXTVAL:
1Z:
1SYSTIMESTAMP:
1HH24_MI_SS_FF:
1DBMS_RANDOM:
1STRING:
110:
1UNIQUE_DBLINK_NAME:
1DBLINK_NAME_TYPE:
1UNIQUE_SEQUENCE_NAME:
1SEQUENCE_NAME_TYPE:
1UNIQUE_TABLE_NAME:
1UNIQUE_VIEW_NAME:
1VIEW_NAME_TYPE:
1UNIQUE_INDEX_NAME:
1INDEX_NAME_TYPE:
1UNIQUE_COLUMN_NAME:
1P_TABLE_NAME:
1TABLE_LOCATION_TYPE:
1COLUMN_NAME_TYPE:
1V_COLUMN_NAME:
1YYYYMMDDHH24MISSFF:
1CREATE_DBLINK:
1P_USER_NAME:
1P_PASSWORD:
1P_CONNECT_STRING:
1CONNECT_STRING_TYPE:
1P_DBLINK_NAME:
1P_DBLINK_CREATED:
1OUT:
1BOOLEAN:
1CREATE DATABASE LINK :
1 :
1CONNECT TO :
1IDENTIFIED BY :
1USING ':
1TRUE:
1CREATE_SEQUENCE:
1P_SEQUENCE_NAME:
1P_SEQUENCE_CREATED:
1CREATE SEQUENCE :
1CREATE_INDEX:
1P_COLUMN_LIST:
1COLUMN_LIST_TYPE:
1P_INDEX_NAME:
1P_INDEX_CREATED:
1V_SQL_COLUMNS:
1:
1COUNT:
1,:
1RTRIM:
1CREATE INDEX :
1 ON :
1:n (:
1CREATE_FUNCTION_INDEX:
1P_FUNCTION_STMT:
1:n (:
1CREATE_DISTINCT_TABLE:
1P_DISTINCT_TABLE_NAME:
1P_DISTINCT_TABLE_CREATED:
1CREATE TABLE :
1 AS :n SELECT DISTINCT :
1:n FROM :
1CREATE_SAMPLE_TABLE:
1P_SAMPLE_SIZE:
1NUMBER:
1P_SAMPLE_TABLE_NAME:
1P_SAMPLE_TABLE_CREATED:
1 AS :n SELECT *:n FROM :
1 SAMPLE (:
1CREATE_SUBSET_TABLE:
1P_REFERENCE_TABLE_NAME:
1P_UNIQUE_ID_COLUMN_NAME:
1P_SUBSET_TABLE_NAME:
1P_SUBSET_TABLE_CREATED:
1V_SQL_UNIQUE:
1DENSE_RANK() OVER (ORDER BY :
1) :
1 AS:n SELECT :
1 t.*:n FROM :
1 t:n WHERE (:
1) IN :n (SELECT :
1:n FROM :
1CREATE_MINUS_TABLE:
1P_DISCARD_TABLE_NAME:
1P_MINUS_TABLE_NAME:
1P_MINUS_TABLE_CREATED:
1 AS:n SELECT *:n FROM :
1 :n MINUS:n SELECT *:n FROM :
1DROP_SCHEMA_OBJECT:
1P_OBJECT_TYPE:
1P_OBJECT_NAME:
1P_OBJECT_CREATED:
1C_DEBUG_FLAG:
1NOT:
1=:
1DROP :
1FALSE:
1DROP_DBLINK:
1DATABASE LINK:
1DROP_TABLE:
1P_TABLE_CREATED:
1TABLE:
1DROP_VIEW:
1P_VIEW_NAME:
1P_VIEW_CREATED:
1VIEW:
1DROP_SEQUENCE:
1SEQUENCE:
1DROP_INDEX:
1INDEX:
1P_DEBUG_ENABLED:
1V_ID:
1INTEGER:
1C_SUBPROGRAM_NAME:
1DEBUG_DUMP:
1Enter :
1.:
1Parameter p_object_type:: :
1Parameter p_object_name:: :
1Parameter p_object_created:: TRUE:
1Parameter p_object_created:: FALSE:
1SELECT odm_debug_catalog_seq.nextval FROM dual:
1INSERT INTO odm_debug_catalog (id, object_type, object_name) :
1VALUES (::id, ::object_type, ::object_name):
1USING:
1DROP %object_type% %object_name%:
1%object_type%:
1%object_name%:
1Done:
1Leave :
1ROLLBACK:
1ROLLBACK_NR:
1Error :
1SQLERRM:
1RAISE:
1ANALYZE_TABLE:
1P_COMPUTATION_METHOD:
1E_VIEW_DETECTED:
1PRAGMA:
1EXCEPTION_INIT:
1-:
101702:
1C_AT_COMPUTE:
1ANALYZE TABLE :
1COMPUTE STATISTICS:
1ELSIF:
1C_AT_ESTIMATE:
1ESTIMATE STATISTICS SAMPLE :
1 PERCENT:
1COUNT_ALL:
1V_ROW_COUNT:
1SELECT COUNT(*) :n FROM :
1COUNT_DISTINCT:
1SELECT COUNT(*) :n FROM (SELECT DISTINCT :
1:n FROM :
1P_COLUMN_NAME:
1COMPUTE_PROFILE_STAT:
1P_CNT_PROFILE:
1P_AVG_PROFILE:
1V_SQL_WHERE:
1P_WHERE_CLAUSE:
1V_TC_SQL_STMT:
1SELECT COUNT(*) cnt_profile, AVG(cnt_item) avg_profile :
1 FROM (SELECT /*+ PARALLEL (:
1) */ COUNT(*) cnt_item :
1 FROM :
1 GROUP BY :
1getting profile count:
1got profile count:
1p_2: cnt_profile:: :
1, p_avg_profile:: :
1COMPUTE_PROFILE_PAIRS:
1P_CNT_PAIRS:
1SELECT COUNT(*) cnt_profile, SUM(cnt_item * (cnt_item - 1) / 2) cnt_pairs :
1SPLIT_TRAIN_TEST:
1P_DATA_TABLE_NAME:
1P_TID_COLUMN_LIST:
1P_TEST_PERCENTAGE:
1P_TEST_COUNT:
1P_TEST_TABLE_NAME:
1V_TEST_TID_TABLE_NAME:
1V_TEST_TID_TABLE_CREATED:
1V_TEST_TABLE_CREATED:
1 AS:n SELECT * :n FROM (SELECT DISTINCT :
1 :n FROM :
1 SAMPLE(:
1)):n WHERE rownum <= :
1:n WHERE (:
1) IN:n (SELECT * FROM :
1DELETE FROM :
1) IN :n (SELECT * FROM :
1PARTITIONING_AVAILABLE:
1V_PARTITIONING_VALUE:
1V_PARTITIONING_AVAILABLE:
1SELECT value :
1FROM v$option :
1WHERE parameter = 'Partitioning':
1GET_PARTITION_LIST:
1PARTITION_LIST_TYPE:
1V_PARTITION_LIST:
1SELECT :
1 PARTITION(' || partition_name || ')' :
1FROM user_tab_partitions :
1WHERE table_name = ':
1UPPER:
1BULK:
1COLLECT:
1IS NULL:
1GET_COLUMN_LIST:
1V_COLUMN_LIST:
1SELECT column_name :
1FROM user_tab_columns :
1QUERY_VALID:
1P_QUERY:
1V_CURSOR:
1V_IS_VALID:
1DBMS_SQL:
1OPEN_CURSOR:
1PARSE:
1NATIVE:
1CLOSE_CURSOR:
1IS_OPEN:
1SELECT * FROM :
1TABLE_EMPTY:
1TYPE:
1GENERIC_CURSOR_TYPE:
1REF:
1CURSOR:
1OPEN:
1SELECT COUNT(*) :
1FROM (SELECT * :
1FROM :
1WHERE rownum <= 1):
1CLOSE:
1ISOPEN:
1COLUMN_EXIST:
1COLUMNS_EXIST:
1P_INVALID_COLUMN_NAME:
1DISTINCT_COLUMN_EXIST:
1FROM (SELECT DISTINCT :
1>:
1DISTINCT_COLUMNS_EXIST:
12:
1 , :
1COLUMNS_DISTINCT:
1J:
1COLUMN_RESERVED:
1P_RESERVED_COLUMN_LIST:
1COLUMNS_RESERVED:
1P_RESERVED_COLUMN_NAME:
1COLUMN_TYPE_VALID:
1P_COLUMN_TYPE:
1COLUMN_DATA_TYPE:
1P_SCHEMA_NAME:
1V_COLUMN_TYPE:
1V_SCHEMA_NAME:
1V_VALID:
1DATA_TYPE:
1ALL_TAB_COLUMNS:
1OWNER:
1TABLE_NAME:
1COLUMN_NAME:
1USER_TAB_COLUMNS:
1CONNECTION_VALID:
1V_DBLINK_NAME:
1V_DBLINK_CREATED:
1SELECT * FROM dual@:
1FORM_SUBSTITUTED_STRING:
1P_ORIGINATOR:
1P_EXCEPTION_NUM:
1P_SUBSTITUTE_1:
1P_SUBSTITUTE_2:
1P_SUBSTITUTE_3:
1P_SUBSTITUTE_4:
1V_ERROR_MESSAGE:
14000:
1ERROR_STRING_CUR:
1P_LANGUAGE:
1P_ERROR_NUMBER:
1ERROR_STRING:
1ODM_ERROR_TABLE:
1LANGUAGE:
1ERROR_NUMBER:
1ENGLISH_STRING_CUR:
1C_CURRENT_LANGUAGE:
1NOTFOUND:
1C_US_ENGLISH_LANG:
1Unknown exception number:: :
1SUBSTRB:
1%1%:
1C_MAX_ERROR_STRING_LEN:
1%2%:
1%3%:
1%4%:
1:: :
1THROW_EXCEPTION:
1RAISE_APPLICATION_ERROR:
1CREATE_TID:
1P_TRAINING_TABLE_NAME:
1P_TID_TABLE_NAME:
1P_TID_TABLE_CREATED:
1V_TID_COLUMNS:
1 AS :
1COUNT(*) AS pcount :
1GROUP BY :
1PROFILE_COUNT:
1SELECT COUNT(*) cnt_profile, AVG(pcount) avg_profile :
1INIT_TABLE:
1P_INPUT_TABLE_NAME:
1P_INPUT_TABLE_CREATED:
1LOOKUP_AND_LOG_OPUTIL_MESSAGE:
1P_MESSAGE_TYPE:
1P_MESSAGE_LEVEL:
1P_MESSAGE_GROUP:
1P_LOCATION:
1P_MESSAGE_ID:
1P_DETAILS:
1P_UPSTREAM_COMPONENT:
1P_DOWNSTREAM_COMPONENT:
1V_MESSAGE_STRING:
1LOG_OPUTIL_MESSAGE:
1P_SUBSTITUTED_STRING:
1V_ERROR_INSTANCE_ID:
1V_ERROR_STACK:
1ERROR_STACK_TYPE:
1DBMS_UTILITY:
1FORMAT_CALL_STACK:
1DMT_OPUTIL:
1GETERRORINSTANCEID:
1RECORDDIAGNOSTICMESSAGE:
1C_SESSION_USER:
1C_SESSION_DETAILS:
1LOG_TRACE_MESSAGE:
1P_MESSAGE_TEXT:
1P_MESSAGE_DETAILS:
1P_CURRENT_COMPONENT:
1V_MESSAGE_DETAIL:
1V_CURRENT_DETAIL:
1GET_TRACE_DETAIL:
1P_LEVEL:
1HIGH_DETAIL:
13:
1MODERATE_DETAIL:
1LOW_DETAIL:
1GETTRACESETTING:
1<=:
1TRACE:
1P_TEXT:
1V_TIME:
1TIMESTAMP:
1V_SUBTEXT:
180:
1V_TOT_LEN:
1V_CUR_LEN:
1V_SUB_LEN:
1V_CUR_POS:
1V_END_POS:
1V_END_POS1:
1V_END_POS2:
1C_MAX_SUB_LEN:
1LENGTH:
1INSTR:
1>=:
1SELECT odm_debug_dump_seq.nextval FROM dual:
1INSERT INTO odm_debug_dump (id, time, text) VALUES (::id, ::time, ::text):
1P_LONG_TEXT:
1LONG_SQL_STATEMENT_TYPE:
1P_LONG_COUNT:
1BINARY_INTEGER:
1P_DEBUG_TEXT:
1V_POS:
1ODM_DEBUG_DUMP:
1CHOP_UP:
1P_SHORT_STMT:
1P_LONG_STMT:
1C_LONG_SQL_STATEMENT_LENGTH:
1GET_TIME:
1GET_DBMS_TIME:
1P_TIME_OUT:
1GET_ELAPSED_TIME:
1P_TIME_IN_1:
1P_TIME_IN_2:
1GET_TIME_MILLISECONDS:
1PERSIST_APPLY_RESULT:
1P_APPLY_RESULT_NAME:
1P_MODEL_NAME:
1P_ORIGINAL_TABLE_LOCATION:
1P_RESULT_TABLE_LOCATION:
1P_TIME_START:
1P_TIME_END:
1V_RESULT_ID:
1SEQ_CLASSIFICATION_RESULT_ID:
1ODM_APPLY_RESULT:
1ID:
1NAM3: E:
1START_TIMESTAMP:
1END_TIMESTAMP:
1DATA_LOCATION:
1MODEL_NAME:
1OUTPUT_TABLE_LOCATION:
1GETRANGEPARTITIONPARAMETERS:
1P_F1_TABLE_NAME:
1P_NUM_PARTITIONS:
1P_NUM_FREQUENT_ITEMS:
1P_EXCLUSIONS_CNT:
1P_SQL_WHERE:
1V_MAX_NUM_ROWS:
1V_MAX_AVG_PROFILE:
1V_NUM_PROFILES:
1V_GROSS_EXPECTED_PAIRS:
1V_NET_EXPECTED_PAIRS:
1V_EFFECTIVE_AVG_PROFILE:
1V_PARTITION_AVAILABLE:
1V_FUNCTION_NAME:
165:
1ODM_MODEL_UTIL.GETRANGEPARTITIONPARAMETERS:
1V_NUM_PARTITION_ERROR:
1getting max rows...:
1select floor((sum(BYTES)/54)/6) from dba_data_files where TABLESPACE_NAME=(:
1select TEMPORARY_TABLESPACE from user_users where username=(select user from +
1dual)):
1done getting max rows:: :
1SQRT:
1/:
12.0:
1<:
1CEIL:
1select count(*) from :
1getting num frequent items...:
1got num frequent items:
1VALUE:
1V$OPTION:
1PARAMETER:
1Partitioning:
1partitioning is available:
1partitioning is not available:
1Partitions Exceeded 1 , Aborting Build :
1E_MODEL_ORA_ERROR_NUM:
1SDIGIT:
1P_NUMBER:
1P_INTEGER:
1V_SHIFT:
1FLOOR:
1LOG:
1ABS:
1TRUNC:
1!=:
1SROUND:
1ROUND:
1TO_DISPLAY:
1P_LEFT:
1P_RIGHT:
1P_ROUND:
1V_LEFT:
1V_RIGHT:
1V_ROUND:
1EXIT:
0
0
0
1b2d
2
0 :2 a0 97 87 :2 a0 51 a5 1c
6e 1b b0 9a 8f a0 b0 3d
b4 55 6a a3 a0 51 a5 1c
81 b0 a3 a0 1c 81 b0 a3
a0 51 a5 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 6e 81
b0 a3 a0 1c 81 b0 :2 a0 6b
a0 a5 b a0 ac :2 a0 b2 ee
ac e5 d0 b2 e9 a0 51 d
:3 a0 :2 51 a5 b d :2 a0 7e b4
2e a0 82 a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e :2 a0 6e a5 b b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e :2 a0 :2 6e a5
b b4 2e 7e 6e b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
7e 51 b4 2e d :4 a0 7e 51
b4 2e 7e 51 b4 2e 51 a5
b d b7 a0 47 a0 57 a0
b4 e9 b7 4f b7 :2 19 3c b7
a0 53 4f b7 a6 9 a4 a0
b1 11 68 4f a0 8d 8f a0
4d b0 3d b4 :2 a0 2c 6a a3
a0 1c 81 b0 a3 a0 1c 81
b0 a0 7e b4 2e :3 a0 6b a5
b ac :2 a0 b2 ee ac e5 d0
b2 e9 6e 7e a0 b4 2e 7e
a0 b4 2e ac :2 a0 b2 ee ac
e5 d0 b2 e9 b7 6e 7e :2 a0
6e a5 b b4 2e 7e :2 a0 6b
4d 51 a5 b b4 2e ac :2 a0
b2 ee ac e5 d0 b2 e9 b7
:2 19 3c :2 a0 65 b7 a4 a0 b1
11 68 4f a0 8d 8f a0 4d
b0 3d b4 :2 a0 2c 6a :3 a0 a5
b 65 b7 a4 a0 b1 11 68
4f a0 8d 8f a0 4d b0 3d
b4 :2 a0 2c 6a :3 a0 a5 b 65
b7 a4 a0 b1 11 68 4f a0
8d 8f a0 4d b0 3d b4 :2 a0
2c 6a :3 a0 a5 b 65 b7 a4
a0 b1 11 68 4f a0 8d 8f
a0 4d b0 3d b4 :2 a0 2c 6a
:3 a0 a5 b 65 b7 a4 a0 b1
11 68 4f a0 8d 8f a0 4d
b0 3d b4 :2 a0 2c 6a :3 a0 a5
b 65 b7 a4 a0 b1 11 68
4f a0 8d 8f a0 b0 3d b4
:2 a0 2c 6a a3 a0 1c 81 b0
6e 7e :2 a0 6e a5 b b4 2e
ac :2 a0 b2 ee ac e5 d0 b2
e9 :2 a0 65 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 90 :2 a0 b0 3f b4
55 6a :2 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
11e 11d :2 a0 d b7 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
90 :2 a0 b0 3f b4 55 6a :2 a0
6e 7e a0 b4 2e 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a0 6e d 91 51
:2 a0 6b a0 63 37 :2 a0 7e :2 a0
a5 b b4 2e 7e 6e b4 2e
d b7 a0 47 :3 a0 6e a5 b
d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a0 6e d 91 51
:2 a0 6b a0 63 37 :2 a0 7e :2 a0
a5 b b4 2e 7e 6e b4 2e
d b7 a0 47 :3 a0 6e a5 b
d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e d
:3 a0 11e 11d :2 a0 d b7 a4 a0
b1 11 68 4f 9a 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
a3 a0 1c 81 b0 a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e d
:3 a0 11e 11d :2 a0 d b7 a4 a0
b1 11 68 4f 9a 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 4: 3d 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a3 a0 1c 81 b0 a3
a0 1c 81 b0 a0 6e d 91
51 :2 a0 6b a0 63 37 :2 a0 7e
:2 a0 a5 b b4 2e 7e 6e b4
2e d b7 a0 47 :3 a0 6e a5
b d a0 7e b4 2e a0 6e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
d b7 a0 6e d b7 :2 19 3c
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e d :3 a0 11e 11d :2 a0 d
b7 a4 a0 b1 11 68 4f 9a
8f a0 b0 3d 8f a0 b0 3d
8f a0 b0 3d 90 :2 a0 b0 3f
b4 55 6a a3 a0 1c 81 b0
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e d :3 a0
11e 11d :2 a0 d b7 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
8f a0 b0 3d 90 :2 a0 b0 3f
b4 55 6a a0 7e b4 2e :2 a0
7e b4 2e :2 a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e a0 b4
2e 11e 11d :2 a0 d b7 19 3c
b7 19 3c b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a0 6e
:2 a0 a5 57 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a0 6e
:2 a0 a5 57 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a0 6e
:2 a0 a5 57 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a0 6e
:2 a0 a5 57 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a0 6e
:2 a0 a5 57 b7 a4 a0 b1 11
68 4f 9a 90 :2 a0 b0 3f 8f
a0 b0 3d 8f a0 b0 3d 90
:2 a0 b0 3f b4 55 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
87 :2 a0 51 a5 1c 6e 1b b0
:2 a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
:2 a0 6e 7e a0 b4 2e a5 57
:2 a0 6e 7e a0 b4 2e a5 57
:3 a0 6e a5 57 b7 :2 a0 6e a5
57 b7 :2 19 3c :3 a0 6e d :4 a0
11e 11d a0 6e 7e 6e b4 2e
d :5 a0 112 a0 112 a0 112 11e
11a 11d a0 57 a0 b4 e9 b7
a0 53 a0 6e d :3 a0 6e a0
a5 b d :3 a0 6e a0 a5 b
d :3 a0 a5 57 :3 a0 11e 11d :2 a0
6e a5 57 b7 a6 9 a4 b1
11 4f b7 a0 6e d :3 a0 6e
a0 a5 b d :3 a0 6e a0 a5
b d :3 a0 11e 11d b7 :2 19 3c
:2 a0 d b7 19 3c :2 a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e a5 57 b7 a0 53
a0 57 a0 b4 e9 a0 57 a0
b4 e9 :2 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
a5 57 :3 a0 a5 57 a0 62 b7
a6 9 a4 a0 b1 11 68 4f
9a 90 :2 a0 b0 3f 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
:2 a0 6e :2 a0 a5 57 b7 a4 a0
b1 11 68 4f 9a 90 :2 a0 b0
3f 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a :2 a0 6e :2 a0 a5
57 b7 a4 a0 b1 11 68 4f
9a 90 :2 a0 b0 3f 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
:2 a0 6e :2 a0 a5 57 b7 a4 a0
b1 11 68 4f 9a 90 :2 a0 b0
3f 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a :2 a0 6e :2 a0 a5
57 b7 a4 a0 b1 11 68 4f
9a 90 :2 a0 b0 3f 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
:2 a0 6e :2 a0 a5 57 b7 a4 a0
b1 11 68 4f 9a 8f a0 b0
3d 8f a0 b0 3d 8f a0 4d
b0 3d b4 55 6a 8b b0 2a
:3 a0 7e 51 b4 2e b4 5d :2 a0
7e b4 2e :2 a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e 6e b4
2e 11e 11d a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e 6e b4
2e a5 57 a0 b7 :2 a0 7e b4
2e :2 a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 11e
11d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e a5
57 b7 :2 19 3c b7 a0 4f b7
a6 9 a4 a0 b1 11 68 4f
a0 8d 8f a0 b0 3d b4 :2 a0
2c 6a a3 a0 1c 81 b0 a3
a0 1c 81 b0 a0 6e 7e a0
b4 2e d :4 a0 11e 11d :2 a0 65
b7 a4 a0 b1 11 68 4f a0
8d 8f a0 b0 3d 8f a0 b0
3d b4 :2 a0 2c 6a a3 a0 1c
81 b0 a3 a0 1c 81 b0 a3
a0 1c 81 b0 a3 a0 1c 81
b0 a0 6e d 91 51 :2 a0 6b
a0 63 37 :2 a0 7e :2 a0 a5 b
b4 2e 7e 6e b4 2e d b7
a0 47 :3 a0 6e a5 b d a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e d :4 a0 11e 11d :2 a0 65 b7
a4 a0 b1 11 68 4f a0 8d
8f a0 b0 3d 8f a0 b0 3d
b4 :2 a0 2c 6a a3 a0 1c 81
b0 :5 a0 a5 b a5 b d :2 a0
65 b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 96 :2 a0 b0 54 96 :2 a0 b0
54 b4 55 6a a3 a0 1c 81
b0 a0 6e d :6 a0 a5 57 b7
a4 a0 b1 11 68 4f 9a 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 96 :2 a0 b0 54 96
:2 a0 b0 54 b4 55 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a0 6e d 91 51 :2 a0
6b a0 63 37 :2 a0 7e :2 a0 a5
b b4 2e 7e 6e b4 2e d
b7 a0 47 :3 a0 6e a5 b d
a0 6e 7e 6e b4 2e 7e a0
b4 2e 7e 6e b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e d a0 6e a5 57 :2 a0
a5 57 :5 a0 11e 5 11d a0 6e
a5 57 a0 6e 7e a0 b4 2e
7e 6e b4 25: e 7e a0 b4 2e
a5 57 b7 a4 a0 b1 11 68
4f 9a 8f a0 b0 3d 8f a0
b0 3d 96 :2 a0 b0 54 96 :2 a0
b0 54 b4 55 6a a3 a0 1c
81 b0 a0 6e d :6 a0 a5 57
b7 a4 a0 b1 11 68 4f 9a
8f a0 b0 3d 8f a0 b0 3d
8f a0 b0 3d 96 :2 a0 b0 54
96 :2 a0 b0 54 b4 55 6a a3
a0 1c 81 b0 a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a0 6e d 91 51
:2 a0 6b a0 63 37 :2 a0 7e :2 a0
a5 b b4 2e 7e 6e b4 2e
d b7 a0 47 :3 a0 6e a5 b
d a0 6e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :5 a0 11e 5 11d
b7 a4 a0 b1 11 68 4f 9a
8f a0 b0 3d 8f a0 b0 3d
8f a0 b0 3d 8f a0 b0 3d
8f a0 b0 3d b4 55 6a a3
a0 1c 81 b0 a3 a0 1c a0
81 b0 a3 a0 1c a0 81 b0
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a3 a0 1c 81 b0 a0
6e d 91 51 :2 a0 6b a0 63
37 :2 a0 7e :2 a0 a5 b b4 2e
7e 6e b4 2e d b7 a0 47
:3 a0 6e a5 b d :3 a0 6b d
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e d :3 a0
11e 11d :2 a0 d :4 a0 6b a5 57
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e d :3 a0 11e 11d :2 a0 d
a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e 7e 6e
b4 2e d :3 a0 11e 11d :3 a0 a5
57 a0 57 a0 b4 e9 b7 a0
53 a0 57 a0 b4 e9 :3 a0 a5
57 :3 a0 a5 57 a0 57 a0 b4
e9 a0 62 b7 a6 9 a4 a0
b1 11 68 4f a0 8d 90 :2 a0
b0 3f b4 :2 a0 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
a3 a0 1c 81 b0 87 :2 a0 51
a5 1c 6e 1b b0 :2 a0 6b a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 a0
6e 7e 6e b4 2e 7e 6e b4
2e d :2 a0 6b :2 a0 a5 57 :4 a0
11e 11d :2 a0 6b a0 6e a5 57
a0 7e 6e b4 2e :2 a0 d b7
:2 a0 d b7 :2 19 3c b7 a0 53
:2 a0 d b7 a6 9 a4 b1 11
4f :2 a0 6b a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e a0 b4
2e a5 57 :2 a0 65 b7 a0 53
:2 a0 6b a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
a5 57 :3 a0 a5 57 a0 62 b7
a6 9 a4 a0 b1 11 68 4f
a0 8d 90 :2 a0 b0 3f 8f a0
b0 3d b4 :2 a0 2c 6a a3 a0
1c 81 b0 a3 a0 1c 81 b0
87 :2 a0 51 a5 1c 6e 1b b0
:2 a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
:2 a0 a5 b a0 6e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e :2 a0 a5 b b4 2e 7e
6e b4 2e d :3 a0 a5 57 :6 a0
11e 11d :2 a0 6e a5 57 a0 7e
b4 2e :2 a0 6b 7e 51 b4 2e
52 10 :3 a0 a5 b d b7 19
3c b7 a0 53 :3 a0 a5 b d
b7 a6 9 a4 b1 11 4f b7
:3 a0 a5 b d b7 :2 19 3c :2 a0
6e 7e a0 b4 2e 7e 6e b4
2e 7e a0 b4 2e a5 57 :2 a0
65 b7 a0 53 :2 a0 6e 7e a0
b4 2e 7e 6e b4 2e 7e a0
b4 2e a5 57 :3 a0 a5 57 a0
62 b7 a6 9 a4 a0 b1 11
68 4f a0 8d 90 :2 a0 b0 3f
8f a0 b0 3d b4 :2 a0 2c 6a
a3 a0 1c 81 b0 a3 a0 1c
81 b0 87 :2 a0 51 a5 1c 6e
1b b0 :2 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e a0 b4 2e
a5 57 a0 6e 7e 6e b4 2e
7e 6e b4 2e 7e :2 a0 a5 b
b4 2e 7e 6e b4 2e d :3 a0
a5 57 :6 a0 11e 11d :2 a0 6e a5
57 :2 a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e a5
57 :2 a0 65 b7 a0 53 a0 57
a0 b4 e9 a0 57 a0 b4 e9
:2 a0 6e 7e a0 b4 2e 7e 6e
b4 2e 7e a0 b4 2e a5 57
:3 a0 a5 57 a0 62 b7 a6 9
a4 a0 b1 11 68 4f a0 8d
8f a0 b0 3d b4 :2 a0 2c 6a
a3 a0 1c 81 b0 a3 a0 1c
81 b0 :3 a0 6b d :2 a0 6b :4 a0
6b a5 57 :2 a0 6b a0 a5 57
:2 a0 d b7 a0 53 :2 a0 6b a0
a5 b :2 a0 6b a0 a5 57 b7
19 3c :2 a0 d b7 a6 9 a4
b1 11 4f :2 a0 65 b7 a4 a0
b1 11 68 4f a0 8d 8f a0
b0 3d b4 :2 a0 2c 6a :2 a0 6e
7e a0 b4 2e a5 b 65 b7
a4 a0 b1 11 68 4f a0 8d
8f a0 b0 3d b4 :2 a0 2c 6a
a0 9d :2 a0 c8 77 a3 a0 1c
81 b0 a3 a0 1c 81 b0 :2 a0
6e 7e 6e b4 2e 7e 6e b4
2e 7e a0 b4 2e 7e 6e b4
2e 7e 6e b4 2e 11c 11d :2 a0
e9 d3 :2 a0 e9 c1 a0 7e 51
b4 2e :2 a0 65 b7 :2 a0 65 b7
:2 19 3c b7 a0 53 :2 a0 f :2 a0
e9 c1 b7 19 3c a0 62 b7
a6 9 a4 a0 b1 11 68 4f
a0 8d 8f a0 b0 3d 8f a0
b0 3d b4 :2 a0 2c 6a :2 a0 6e
7e a0 b4 2e 7e 6e b4 2e
7e a0 b4 2e a5 b 65 b7
a4 a0 b1 11 68 4f a0 8d
8f a0 b0 3d 8f a0 b0 3d
96 :2 a0 b0 54 b4 :2 a0 2c 6a
a3 a0 1c 81 b0 91 51 :2 a0
6b a0 63 37 :3 a0 a5 b a0
a5 b 7e b4 2e :3 a0 a5 b
d :2 a0 65 b7 19 3c b7 a0
47 a0 6e d :2 a0 65 b7 a4
a0 b1 11 68 4f a0 8d 8f
a0 b0 3d 8f a0 b0 3d b4
:2 a0 2c 6a a3 a0 1c 81 b0
a3 a0 1c 81 b0 a3 a0 1c
81 b0 a0 6e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2

Line 2: cnt_profile:: :
1, p_avg_profile:: :
1COMPUTE_PROFILE_PAIRS:
1P_CNT_PAIRS:
1SELECT COUNT() cnt_profile, SUM(cnt_item (cnt_item - 1) / 2) cnt_pairs :
1SPLIT_TRAIN_TEST:
1P_DATA_TABLE_NAME:
1P_TID_COLUMN_LIST:
1P_TEST_PERCENTAGE:
1P_TEST_COUNT:
1P_TEST_TABLE_NAME:
1V_TEST_TID_TABLE_NAME:
1V_TEST_TID_TABLE_CREATED:
1V_TEST_TABLE_CREATED:
1 AS:n SELECT * :n FROM (SELECT DISTINCT :
1 :n FROM :
1 SAMPLE(:
1)):n WHERE rownum <= :
1:n WHERE (:
1) IN:n (SELECT * FROM :
1DELETE FROM :
1) IN :n (SELECT * FROM :
1PARTITIONING_AVAILABLE:
1V_PARTITIONING_VALUE:
1V_PARTITIONING_AVAILABLE:
1SELECT value :
1FROM v$option :
1WHERE parameter = 'Partitioning':
1GET_PARTITION_LIST:
1PARTITION_LIST_TYPE:
1V_PARTITION_LIST:
1SELECT :
1 PARTITION(' || partition_name || ')' :
1FROM user_tab_partitions :
1WHERE table_name = ':
1UPPER:
1BULK:
1COLLECT:
1IS NULL:
1GET_COLUMN_LIST:
1V_COLUMN_LIST:
1SELECT column_name :
1FROM user_tab_columns :
1QUERY_VALID:
1P_QUERY:
1V_CURSOR:
1V_IS_VALID:
1DBMS_SQL:
1OPEN_CURSOR:
1PARSE:
1NATIVE:
1CLOSE_CURSOR:
1IS_OPEN:
1SELECT * FROM :
1TABLE_EMPTY:
1TYPE:
1GENERIC_CURSOR_TYPE:
1REF:
1CURSOR:
1OPEN:
1SELECT COUNT() :
1FROM (SELECT :
1FROM :
1WHERE rownum <= 1):
1CLOSE:
1ISOPEN:
1COLUMN_EXIST:
1COLUMNS_EXIST:
1P_INVALID_COLUMN_NAME:
1DISTINCT_COLUMN_EXIST:
1FROM (SELECT DISTINCT :
1>:
1DISTINCT_COLUMNS_EXIST:
12:
1 , :
1COLUMNS_DISTINCT:
1J:
1COLUMN_RESERVED:
1P_RESERVED_COLUMN_LIST:
1COLUMNS_RESERVED:
1P_RESERVED_COLUMN_NAME:
1COLUMN_TYPE_VALID:
1P_COLUMN_TYPE:
1COLUMN_DATA_TYPE:
1P_SCHEMA_NAME:
1V_COLUMN_TYPE:
1V_SCHEMA_NAME:
1V_VALID:
1DATA_TYPE:
1ALL_TAB_COLUMNS:
1OWNER:
1TABLE_NAME:
1COLUMN_NAME:
1USER_TAB_COLUMNS:
1CONNECTION_VALID:
1V_DBLINK_NAME:
1V_DBLINK_CREATED:
1SELECT * FROM dual@:
1FORM_SUBSTITUTED_STRING:
1P_ORIGINATOR:
1P_EXCEPTION_NUM:
1P_SUBSTITUTE_1:
1P_SUBSTITUTE_2:
1P_SUBSTITUTE_3:
1P_SUBSTITUTE_4:
1V_ERROR_MESSAGE:
14000:
1ERROR_STRING_CUR:
1P_LANGUAGE:
1P_ERROR_NUMBER:
1ERROR_STRING:
1ODM_ERROR_TABLE:
1LANGUAGE:
1ERROR_NUMBER:
1ENGLISH_STRING_CUR:
1C_CURRENT_LANGUAGE:
1NOTFOUND:
1C_US_ENGLISH_LANG:
1Unknown exception number:: :
1SUBSTRB:
1%1%:
1C_MAX_ERROR_STRING_LEN:
1%2%:
1%3%:
1%4%:
1:: :
1THROW_EXCEPTION:
1RAISE_APPLICATION_ERROR:
1CREATE_TID:
1P_TRAINING_TABLE_NAME:
1P_TID_TABLE_NAME:
1P_TID_TABLE_CREATED:
1V_TID_COLUMNS:
1 AS :
1COUNT() AS pcount :
1GROUP BY :
1PROFILE_COUNT:
1SELECT COUNT() cnt_profile, AVG(pcount) avg_profile :
1INIT_TABLE:
1P_INPUT_TABLE_NAME:
1P_INPUT_TABLE_CREATED:
1LOOKUP_AND_LOG_OPUTIL_MESSAGE:
1P_MESSAGE_TYPE:
1P_MESSAGE_LEVEL:
1P_MESSAGE_GROUP:
1P_LOCATION:
1P_MESSAGE_ID:
1P_DETAILS:
1P_UPSTREAM_COMPONENT:
1P_DOWNSTREAM_COMPONENT:
1V_MESSAGE_STRING:
1LOG_OPUTIL_MESSAGE:
1P_SUBSTITUTED_STRING:
1V_ERROR_INSTANCE_ID:
1V_ERROR_STACK:
1ERROR_STACK_TYPE:
1DBMS_UTILITY:
1FORMAT_CALL_STACK:
1DMT_OPUTIL:
1GETERRORINSTANCEID:
1RECORDDIAGNOSTICMESSAGE:
1C_SESSION_USER:
1C_SESSION_DETAILS:
1LOG_TRACE_MESSAGE:
1P_MESSAGE_TEXT:
1P_MESSAGE_DETAILS:
1P_CURRENT_COMPONENT:
1V_MESSAGE_DETAIL:
1V_CURRENT_DETAIL:
1GET_TRACE_DETAIL:
1P_LEVEL:
1HIGH_DETAIL:
13:
1MODERATE_DETAIL:
1LOW_DETAIL:
1GETTRACESETTING:
1<=:
1TRACE:
1P_TEXT:
1V_TIME:
1TIMESTAMP:
1V_SUBTEXT:
180:
1V_TOT_LEN:
1V_CUR_LEN:
1V_SUB_LEN:
1V_CUR_POS:
1V_END_POS:
1V_END_POS1:
1V_END_POS2:
1C_MAX_SUB_LEN:
1LENGTH:
1INSTR:
1>=:
1SELECT odm_debug_dump_seq.nextval FROM dual:
1INSERT INTO odm_debug_dump (id, time, text) VALUES (::id, ::time, ::text):
1P_LONG_TEXT:
1LONG_SQL_STATEMENT_TYPE:
1P_LONG_COUNT:
1BINARY_INTEGER:
1P_DEBUG_TEXT:
1V_POS:
1ODM_DEBUG_DUMP:
1CHOP_UP:
1P_SHORT_STMT:
1P_LONG_STMT:
1C_LONG_SQL_STATEMENT_LENGTH:
1GET_TIME:
1GET_DBMS_TIME:
1P_TIME_OUT:
1GET_ELAPSED_TIME:
1P_TIME_IN_1:
1P_TIME_IN_2:
1GET_TIME_MILLISECONDS:
1PERSIST_APPLY_RESULT:
1P_APPLY_RESULT_NAME:
1P_MODEL_NAME:
1P_ORIGINAL_TABLE_LOCATION:
1P_RESULT_TABLE_LOCATION:
1P_TIME_START:
1P_TIME_END:
1V_RESULT_ID:
1SEQ_CLASSIFICATION_RESULT_ID:
1ODM_APPLY_RESULT:
1ID:
1NAM

Line 3: E:
1START_TIMESTAMP:
1END_TIMESTAMP:
1DATA_LOCATION:
1MODEL_NAME:
1OUTPUT_TABLE_LOCATION:
1GETRANGEPARTITIONPARAMETERS:
1P_F1_TABLE_NAME:
1P_NUM_PARTITIONS:
1P_NUM_FREQUENT_ITEMS:
1P_EXCLUSIONS_CNT:
1P_SQL_WHERE:
1V_MAX_NUM_ROWS:
1V_MAX_AVG_PROFILE:
1V_NUM_PROFILES:
1V_GROSS_EXPECTED_PAIRS:
1V_NET_EXPECTED_PAIRS:
1V_EFFECTIVE_AVG_PROFILE:
1V_PARTITION_AVAILABLE:
1V_FUNCTION_NAME:
165:
1ODM_MODEL_UTIL.GETRANGEPARTITIONPARAMETERS:
1V_NUM_PARTITION_ERROR:
1getting max rows...:
1select floor((sum(BYTES)/54)/6) from dba_data_files where TABLESPACE_NAME=(:
1select TEMPORARY_TABLESPACE from user_users where username=(select user from +
1dual)):
1done getting max rows:: :
1SQRT:
1/:
12.0:
1<:
1CEIL:
1select count(*) from :
1getting num frequent items...:
1got num frequent items:
1VALUE:
1V$OPTION:
1PARAMETER:
1Partitioning:
1partitioning is available:
1partitioning is not available:
1Partitions Exceeded 1 , Aborting Build :
1E_MODEL_ORA_ERROR_NUM:
1SDIGIT:
1P_NUMBER:
1P_INTEGER:
1V_SHIFT:
1FLOOR:
1LOG:
1ABS:
1TRUNC:
1!=:
1SROUND:
1ROUND:
1TO_DISPLAY:
1P_LEFT:
1P_RIGHT:
1P_ROUND:
1V_LEFT:
1V_RIGHT:
1V_ROUND:
1EXIT:
0
0
0
1b2d
2
0 :2 a0 97 87 :2 a0 51 a5 1c
6e 1b b0 9a 8f a0 b0 3d
b4 55 6a a3 a0 51 a5 1c
81 b0 a3 a0 1c 81 b0 a3
a0 51 a5 1c 81 b0 a3 a0
1c 81 b0 a3 a0 1c 6e 81
b0 a3 a0 1c 81 b0 :2 a0 6b
a0 a5 b a0 ac :2 a0 b2 ee
ac e5 d0 b2 e9 a0 51 d
:3 a0 :2 51 a5 b d :2 a0 7e b4
2e a0 82 a0 6e 7e a0 b4
2e 7e 6e b4 2e 7e 6e b4
2e 7e :2 a0 6e a5 b b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e :2 a0 :2 6e a5
b b4 2e 7e 6e b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
7e 51 b4 2e d :4 a0 7e 51
b4 2e 7e 51 b4 2e 51 a5
b d b7 a0 47 a0 57 a0
b4 e9 b7 4f b7 :2 19 3c b7
a0 53 4f b7 a6 9 a4 a0
b1 11 68 4f a0 8d 8f a0
4d b0 3d b4 :2 a0 2c 6a a3
a0 1c 81 b0 a3 a0 1c 81
b0 a0 7e b4 2e :3 a0 6b a5
b ac :2 a0 b2 ee ac e5 d0
b2 e9 6e 7e a0 b4 2e 7e
a0 b4 2e ac :2 a0 b2 ee ac
e5 d0 b2 e9 b7 6e 7e :2 a0
6e a5 b b4 2e 7e :2 a0 6b
4d 51 a5 b b4 2e ac :2 a0
b2 ee ac e5 d0 b2 e9 b7
:2 19 3c :2 a0 65 b7 a4 a0 b1
11 68 4f a0 8d 8f a0 4d
b0 3d b4 :2 a0 2c 6a :3 a0 a5
b 65 b7 a4 a0 b1 11 68
4f a0 8d 8f a0 4d b0 3d
b4 :2 a0 2c 6a :3 a0 a5 b 65
b7 a4 a0 b1 11 68 4f a0
8d 8f a0 4d b0 3d b4 :2 a0
2c 6a :3 a0 a5 b 65 b7 a4
a0 b1 11 68 4f a0 8d 8f
a0 4d b0 3d b4 :2 a0 2c 6a
:3 a0 a5 b 65 b7 a4 a0 b1
11 68 4f a0 8d 8f a0 4d
b0 3d b4 :2 a0 2c 6a :3 a0 a5
b 65 b7 a4 a0 b1 11 68
4f a0 8d 8f a0 b0 3d b4
:2 a0 2c 6a a3 a0 1c 81 b0
6e 7e :2 a0 6e a5 b b4 2e
ac :2 a0 b2 ee ac e5 d0 b2
e9 :2 a0 65 b7 a4 a0 b1 11
68 4f 9a 8f a0 b0 3d 8f
a0 b0 3d 8f a0 b0 3d 8f
a0 b0 3d 90 :2 a0 b0 3f b4
55 6a :2 a0 6e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
7e 6e b4 2e 7e a0 b4 2e
7e 6e b4 2e 7e 6e b4 2e
7e a0 b4 2e 7e 6e b4 2e
11e 11d :2 a0 d b7 a4 a0 b1
11 68 4f 9a 8f a0 b0 3d
90 :2 a0 b0 3f b4 55 6a :2 a0
6e 7e a0 b4 2e 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a0 6e d 91 51
:2 a0 6b a0 63 37 :2 a0 7e :2 a0
a5 b b4 2e 7e 6e b4 2e
d b7 a0 47 :3 a0 6e a5 b
d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e d :3 a0 11e 11d :2 a0
d b7 a4 a0 b1 11 68 4f
9a 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0 3d 90 :2 a0 b0
3f b4 55 6a a3 a0 1c 81
b0 a3 a0 1c 81 b0 a3 a0
1c 81 b0 a0 6e d 91 51
:2 a0 6b a0 63 37 :2 a0 7e :2 a0
a5 b b4 2e 7e 6e b4 2e
d b7 a0 47 :3 a0 6e a5 b
d a0 6e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e 7e
6e b4 2e 7e a0 b4 2e d
:3 a0 11e 11d :2 a0 d b7 a4 a0
b1 11 68 4f 9a 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 90 :2 a0 b0 3f b4 55 6a
a3 a0 1c 81 b0 a0 6e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e 7e
a0 b4 2e 7e 6e b4 2e d
:3 a0 11e 11d :2 a0 d b7 a4 a0
b1 11 68 4f 9a 8f a0 b0
3d 8f a0 b0 3d 8f a0 b0
3d 8f a0 b0