false false continue false 500 100 50 1450393514000 1450393514000 false true Select 1 5000 realizeDBPool jdbc:oracle:thin:@perf-assignments-2.ciynhfhfwckz.us-east-1.rds.amazonaws.com:1521/ORCL oracle.jdbc.OracleDriver true realize 10 10000 DEFAULT 60000 prod_realize ID_8nbv01j02u639.csv 8nbv01j02u639_class_uuid,8nbv01j02u639_count , false true false shareMode.all 2mrst3vrnsfwa.csv 2mrst3vrnsfwa_class_uuid,2mrst3vrnsfwa_student_uuid , false true false shareMode.all ID_71rt9n36fb9w6.csv 71rt9n36fb9w6_class_uuid,71rt9n36fb9w6_count , false true false shareMode.all ID_a5spx2rt3725d.csv a5spx2rt3725d_class_uuid,a5spx2rt3725d_student_uuid,a5spx2rt3725d_count , false true false shareMode.all 8x1pd8k9cmj79.csv 8x1pd8k9cmj79_student_uuid,8x1pd8k9cmj79_item_uuid,8x1pd8k9cmj79_item_version , false true false shareMode.all c8rfxarjgkwws.csv c8rfxarjgkwws_class_uuid , false true false shareMode.all ID_dh7rcygd7hfra.csv dh7rcygd7hfra_class_uuid,dh7rcygd7hfra_student_uuid,dh7rcygd7hfra_count , false true false shareMode.all a773y4z7bgb50.csv a773y4z7bgb50_class_uuid,a773y4z7bgb50_student_uuid , false true false shareMode.all 3tmh3ps7nq592.csv 3tmh3ps7nq592_owner_uuid,3tmh3ps7nq592_item_uuid , false true false shareMode.all c0vchfx3ya9u6.csv c0vchfx3ya9u6_class_uuid , false true false shareMode.all ID_cs06fsb03xtw6.csv cs06fsb03xtw6_assignment_id,cs06fsb03xtw6_count , false true false shareMode.all ID_2yumq8bw91vv4.csv 2yumq8bw91vv4_class_uuid,2yumq8bw91vv4_student_uuid,2yumq8bw91vv4_count , false true false shareMode.all ID_773y4z7bgb50.csv 773y4z7bgb50_class_uuid,773y4z7bgb50_student_uuid,773y4z7bgb50_count , false true false shareMode.all ID_fjrv8kpqqktkk.csv fjrv8kpqqktkk_assignment_id,fjrv8kpqqktkk_count , false true false shareMode.all realizeDBPool Prepared Select Statement SELECT COUNT(*) JMETER_8nbv01j02u639 FROM ASA_USER_ASSIGNMENTS_EV U_A WHERE U_A.CLASS_UUID = ? AND U_A.ITEM_TYPE = 'TEST' AND U_A.IS_DELETED = 0 AND EXISTS (SELECT /*+ INDEX(U_A_D UAD_USER_ASSIGNMENT_ID_IDX) */ 1 FROM ASA_USER_ASSIGNMENT_DATA_EV U_A_D WHERE U_A_D.USER_ASSIGNMENT_ID = U_A.USER_ASSIGNMENT_ID AND U_A_D.CREATED_DATE > SYSDATE-30 AND U_A_D.CREATED_DATE < SYSDATE ) ${8nbv01j02u639_class_uuid} VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_2mrst3vrnsfwa, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID, AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? AND AUA.STUDENT_UUID = ? ORDER BY AUA.ASSIGNMENT_ID ${2mrst3vrnsfwa_class_uuid},${2mrst3vrnsfwa_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_71rt9n36fb9w6, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID , AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? ORDER BY AUA.ASSIGNMENT_ID ${71rt9n36fb9w6_class_uuid} VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT COUNT(*) AS JMETER_a5spx2rt3725d FROM (SELECT ASAUSERASSIGNMENTS.USER_ASSIGNMENT_ID, ASAHIDDENASSIGNMENTS.CLASS_UUID N_CLASS FROM EVENTS_ASA_EV EVENTSASA JOIN ASA_USER_ASSIGNMENTS_EV ASAUSERASSIGNMENTS ON EVENTSASA.ID = ASAUSERASSIGNMENTS.ASSIGNMENT_ID JOIN ASA_USER_ASSIGMT_LANGUAGES_EV ASAUSERLANGUAGE ON ASAUSERLANGUAGE.USER_ASSIGNMENT_ID = ASAUSERASSIGNMENTS.USER_ASSIGNMENT_ID AND ASAUSERLANGUAGE.ITEM_UUID = EVENTSASA.ITEM_UUID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ASAHIDDENASSIGNMENTS ON ASAHIDDENASSIGNMENTS.CLASS_UUID = ASAUSERASSIGNMENTS.CLASS_UUID AND ASAHIDDENASSIGNMENTS.ASSIGNMENT_ID = ASAUSERASSIGNMENTS.ASSIGNMENT_ID WHERE ASAUSERASSIGNMENTS.CLASS_UUID = ? AND ASAUSERASSIGNMENTS.STUDENT_UUID = ? AND ASAUSERASSIGNMENTS.MARK_COMPLETED = 1 AND ASAUSERASSIGNMENTS.LAST_OPEN_DATE IS NOT NULL AND ASAUSERASSIGNMENTS.IS_DELETED = 0 ) WHERE N_CLASS IS NULL ${a5spx2rt3725d_class_uuid},${a5spx2rt3725d_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement select assign.*, userassignmentlanguages.user_assignment_id as language_user_assignment_id, userassignmentlanguages.item_uuid as language_item_uuid, userassignmentlanguages.item_version as language_item_version, userassignmentlanguages.is_selected as language_is_selected, userassignmentlanguages.language_locale as language_language_locale from asa_user_assignments_ev assign join asa_user_assigmt_languages_ev userassignmentlanguages on assign.user_assignment_id = userassignmentlanguages.user_assignment_id where assign.student_uuid = ? and assign.is_deleted = 0 and userassignmentlanguages.item_uuid = ? and userassignmentlanguages.item_version = ? ${8x1pd8k9cmj79_student_uuid},${8x1pd8k9cmj79_item_uuid},${8x1pd8k9cmj79_item_version} VARCHAR,VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT DISTINCT EVENTS_ASA_EV.ITEM_UUID JMETER_c8rfxarjgkwws, EVENTS_ASA_EV.ITEM_VERSION, EVENTS_ASA_EV.OWNER_UUID, EVENTS_ASA_EV.TITLE, EVENTS_ASA_EV.CREATED_DATE, EVENTS_ASA_EV.START_DATE, EVENTS_ASA_EV.END_DATE, EVENTS_ASA_EV.DESCRIPTION, ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID, ASA_ASSIGNMENTS_EV.HAS_MULTIPLE_LANGUAGE, ASA_ASSIGNMENTS_EV.ALLOW_MULTIPLE_LANGUAGE, ASA_ASSIGNMENTS_EV.HAS_REMEDIATION, ASA_ASSIGNMENTS_EV.ALLOW_REMEDIATION, ASA_ASSIGNMENTS_EV.REMEDIATION_ORIGINAL_ITEM_UUID, ASA_ASSIGNMENTS_EV.ATTACHMENT_URL, ASA_ASSIGNMENTS_EV.ASSIGNMENT_TYPE, CASE WHEN ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID IS NOT NULL THEN 'INACTIVE' ELSE 'AVAILABLE' END HIDE_STATUS FROM EVENTS_ASA_EV JOIN ASA_ASSIGNMENTS_EV ON ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_EV.ID JOIN ASA_USER_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID LEFT JOIN EVENTS_ASA_ASSIGNED_TO_EV ON EVENTS_ASA_ASSIGNED_TO_EV.ID = EVENTS_ASA_EV.ID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ON ASA_HID DEN_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_ASSIGNED_TO_EV.ID AND EVENTS_ASA_ASSIGNED_TO_EV.CLASS_UUID = ASA_HIDDEN_ASSIGNMENTS_EV.CLASS_UUID WHERE EVENTS_ASA_ASSIGNED_TO_EV.CLASS_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.IS_DELETED = 0 ${c8rfxarjgkwws_class_uuid} VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT AUAD.USER_ASSIGNMENT_ID, AUAD.CREATED_DATE, AUAD.SCORE, AUAD.CORRECT_ANSWERS, AUAD.TOTAL_QUESTIONS, AUAD.COMPLETION_STATUS, AUAD.TOTAL_TIME, AUAD.SUCCESS_STATUS, AUAD.SCORE_SOURCE, AUAD.IS_SCORE_SENT FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGNMENT_DATA_EV AUAD ON AUAD.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? AND AUA.STUDENT_UUID = ? ORDER BY AUA.ASSIGNMENT_ID ${dh7rcygd7hfra_class_uuid},${dh7rcygd7hfra_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT DISTINCT EVENTS_ASA_EV.*, ASA_ASSIGNMENTS_EV.*, CASE WHEN ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID IS NOT NULL THEN 'INACTIVE' ELSE 'AVAILABLE' END HIDE_STATUS FROM EVENTS_ASA_EV JOIN ASA_ASSIGNMENTS_EV ON ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID = EVENTS_ASA_EV.ID JOIN ASA_USER_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_ASSIGNMENTS_EV.ASSIGNMENT_ID LEFT JOIN ASA_HIDDEN_ASSIGNMENTS_EV ON ASA_USER_ASSIGNMENTS_EV.ASSIGNMENT_ID = ASA_HIDDEN_ASSIGNMENTS_EV.ASSIGNMENT_ID AND ASA_USER_ASSIGNMENTS_EV.CLASS_UUID = ASA_HIDDEN_ASSIGNMENTS_EV.CLASS_UUID WHERE ASA_USER_ASSIGNMENTS_EV.CLASS_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.STUDENT_UUID = ? AND ASA_USER_ASSIGNMENTS_EV.IS_DELETED = 0 ${a773y4z7bgb50_class_uuid},${a773y4z7bgb50_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT COUNT(DISTINCT A.ASSIGNMENT_ID) JMETER_3tmh3ps7nq592 FROM EVENTS_ASA_EV EA INNER JOIN ASA_ASSIGNMENTS_EV A ON A.ASSIGNMENT_ID = EA.ID INNER JOIN ASA_USER_ASSIGNMENTS_EV UA ON UA.ASSIGNMENT_ID = A.ASSIGNMENT_ID INNER JOIN ASA_USER_ASSIGMT_LANGUAGES_EV UAL ON UAL.USER_ASSIGNMENT_ID = UA.USER_ASSIGNMENT_ID WHERE EA.OWNER_UUID = ? AND UAL.ITEM_UUID = ? AND UA.IS_DELETED = 0 ${3tmh3ps7nq592_owner_uuid},${3tmh3ps7nq592_item_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT AUAD.USER_ASSIGNMENT_ID JMETER_c0vchfx3ya9u6, AUAD.CREATED_DATE, AUAD.SCORE, AUAD.CORRECT_ANSWERS, AUAD.TOTAL_QUESTIONS, AUAD.COMPLETION_STATUS, AUAD.TOTAL_TIME, AUAD.SUCCESS_STATUS, AUAD.SCORE_SOURCE, AUAD.IS_SCORE_SENT FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGNMENT_DATA_EV AUAD ON AUAD.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.CLASS_UUID = ? ORDER BY AUA.ASSIGNMENT_ID ${c0vchfx3ya9u6_class_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT AUA.*, AUAL.USER_ASSIGNMENT_ID JMETER_cs06fsb03xtw6, AUAL.ITEM_UUID LANGUAGE_ITEM_UUID, AUAL.ITEM_VERSION LANGUAGE_ITEM_VERSION, AUAL.LANGUAGE_LOCALE LANGUAGE_LANGUAGE_LOCALE, AUAL.IS_SELECTED LANGUAGE_IS_SELECTED FROM ASA_USER_ASSIGNMENTS_EV AUA JOIN ASA_USER_ASSIGMT_LANGUAGES_EV AUAL ON AUAL.USER_ASSIGNMENT_ID = AUA.USER_ASSIGNMENT_ID WHERE AUA.IS_DELETED = 0 AND AUA.ASSIGNMENT_ID = :1 ORDER BY AUA.ASSIGNMENT_ID ${cs06fsb03xtw6_assignment_id} VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT coalesce(sum(case when r.last_open_date is null then 1 else 0 end), 0) NOT_STARTED, coalesce(sum(case when r.last_open_date is not null and r.completed = 0 then 1 else 0 end), 0) IN_PROGRESS, coalesce(sum(case when r.last_open_date is not null and r.completed = 1 then 1 else 0 end), 0) COMPLETED from ( SELECT distinct asa_assignments_ev.assignment_id assignment_id, asa_user_assignments_ev.last_open_date last_open_date, asa_user_assignments_ev.mark_completed completed FROM events_asa_ev JOIN asa_assignments_ev on asa_assignments_ev.assignment_id = events_asa_ev.id JOIN asa_user_assignments_ev ON asa_user_assignments_ev.assignment_id = asa_assignments_ev.assignment_id JOIN asa_user_assigmt_languages_ev on asa_user_assignments_ev.user_assignment_id = asa_user_assigmt_languages_ev.user_assignment_id and asa_user_assigmt_languages_ev.item_uuid = events_asa_ev.item_uuid LEFT JOIN asa_user_assignment_data_ev ON asa_user_assignments_ev.user_assignment_id = asa_user_assignment_dat a_ev.user_assignment_id LEFT JOIN asa_hidden_assignments_ev ON asa_user_assignments_ev.assignment_id = asa_hidden_assignments_ev.assignment_id AND asa_user_assignments_ev.class_uuid = asa_hidden_assignments_ev.class_uuid WHERE asa_user_assignments_ev.class_uuid = ? AND asa_user_assignments_ev.student_uuid = ? AND case when asa_hidden_assignments_ev.assignment_id is NOT NULL then 'INACTIVE' else 'AVAILABLE' end = 'AVAILABLE' AND events_asa_ev.start_date <= SYSDATE AND asa_user_assignments_ev.is_deleted = 0) r ${2yumq8bw91vv4_class_uuid},${2yumq8bw91vv4_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement select distinct events_asa_ev.*, asa_assignments_ev.*, case when asa_hidden_assignments_ev.assignment_id is NOT NULL then 'INACTIVE' else 'AVAILABLE' end hide_status from events_asa_ev join asa_assignments_ev on asa_assignments_ev.assignment_id = events_asa_ev.id join asa_user_assignments_ev on asa_user_assignments_ev.assignment_id = asa_assignments_ev.assignment_id left join asa_hidden_assignments_ev on asa_user_assignments_ev.assignment_id = asa_hidden_assignments_ev.assignment_id and asa_user_assignments_ev.class_uuid = asa_hidden_assignments_ev.class_uuid where asa_user_assignments_ev.class_uuid = ? and asa_user_assignments_ev.student_uuid = ? and asa_user_assignments_ev.is_deleted = 0 ${773y4z7bgb50_class_uuid},${773y4z7bgb50_student_uuid} VARCHAR,VARCHAR Store as String realizeDBPool Prepared Select Statement SELECT auad.user_assignment_id, auad.created_date, auad.score, auad.correct_answers, auad.total_questions, auad.completion_status, auad.total_time, auad.success_status, auad.score_source, auad.is_score_sent FROM asa_user_assignments_ev aua JOIN asa_user_assignment_data_ev auad ON auad.user_assignment_id = aua.user_assignment_id where aua.is_deleted = 0 and aua.assignment_id = ? ORDER BY aua.assignment_id ${fjrv8kpqqktkk_assignment_id} VARCHAR Store as String false saveConfig true true true true true true true true true false true true false false false false false false false false 0 true true test.jtl false saveConfig true true true true true true true true true false true true false false false false false false false false 0 true true