| SQL ID | Planhash | Sampled # of Executions | % Activity | Event | % Event | Top Row Source | % RwSrc | SQL Text |
| ffb720ahf723v | | 584 | 23.88 |
gc buffer busy acquire | 9.46 | ** Row Source Not Available ** | 9.46 |
insert into AUDIT_FILTER_LOG (... |
| | | 584 | 23.88 |
gc current block busy | 7.07 | ** Row Source Not Available ** | 7.07 |
insert into AUDIT_FILTER_LOG (... |
| | | 584 | 23.88 |
enq: TX - index contention | 2.50 | ** Row Source Not Available ** | 2.50 |
insert into AUDIT_FILTER_LOG (... |
| 7frqszzdu8sgg | 4109302118 | 36 | 1.56 |
control file sequential read | 0.87 | FIXED TABLE - FULL | 0.55 |
select DECODE(UPPER(d.OPEN_MOD... |
| fzkvszqchfpc1 | 2274523690 | 41 | 1.42 |
CPU + Wait for CPU | 1.42 | SORT - ORDER BY | 1.32 |
Select PATIENT_INSURANCE_ID, ... |
| fzdsykgx23nxx | 3164524713 | 23 | 1.25 |
CPU + Wait for CPU | 0.52 | TABLE ACCESS - FULL | 0.42 |
select this_.User_ID as User1_... |
| 59nf178vrwr1k | 1341607311 | 25 | 1.07 |
CPU + Wait for CPU | 0.62 | TABLE ACCESS - FULL | 0.45 |
select this_.SESSION_LOG_ID as... |
| SQL Id | SQL Text |
| 070uxapgbuyzj | select user_id from user_profile where (lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210')) = 'prescription1@loadtest.com' or lower(encryption.decrypt_char(user_name, '0123456789ABCDEFFEDCBA9876543210')) = 'prescription1@loadtest.com') and password = '7cbfa25a0ba328ee7c8058e62dcdbedf8544f293' and is_active = 1 |
| 174u0fggcjyyq | Select user_id from user_profile where lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210'))='load08test@tuscan.com' |
| 59nf178vrwr1k | select this_.SESSION_LOG_ID as SESSION1_48_0_, this_.USER_ID as USER2_48_0_, this_.LOGIN_TIME as LOGIN3_48_0_, this_.LOGOUT_TIME as LOGOUT4_48_0_, this_.SESSION_TOKEN as SESSION5_48_0_, this_.IP_ADD as IP6_48_0_, this_.AGENT as AGENT48_0_, this_.DESCRIPTION as DESCRIPT8_48_0_, this_.IS_AUTO_LOGGED_OUT as IS9_48_0_ from SESSION_LOG this_ where (this_.USER_ID=:1 and this_.SESSION_TOKEN=:2 ) |
| 7frqszzdu8sgg | select DECODE(UPPER(d.OPEN_MODE), 'READ WRITE', 'R', 'N') , DECODE(UPPER(i.STATUS), 'OPEN', 'O', 'N') into :b0, :b1 from v$database d , gv$instance i where i.INSTANCE_NAME=:b2 |
| ffb720ahf723v | insert into AUDIT_FILTER_LOG (SESSION_LOG_ID, USER_ID, AUDIT_TIME, URI, MODULE_NAME, HTTP_METHOD, OPERATION_NAME, QUERY_STRING, DATA, AUDIT_LOG_ID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 ) |
| fzdsykgx23nxx | select this_.User_ID as User1_47_0_, this_.Session_Token as Session2_47_0_, this_.Last_Action as Last3_47_0_, this_.Is_Logged_in as Is4_47_0_ from User_Profile_Login this_ where (this_.Is_Logged_in=:1 and this_.Session_Token=:2 ) and this_.User_ID=:3 |
| fzkvszqchfpc1 |
Select PATIENT_INSURANCE_ID, PATIENT_ID, encryption.decrypt_char(PATIENT_NAME, '0123456789ABCDEFFEDCBA9876543210') as PATIENT_NAME, encryption.decrypt_char(PLAN_ID, '0123456789ABCDEFFEDCBA9876543210') as PLAN_ID, encryption.decrypt_char(PLAN_NAME, '0123456789ABCDEFFEDCBA9876543210') as PLAN_NAME, encryption.decrypt_char(INSURANCE_NAME, '0123456789ABCDEFFEDCBA9876543210') as INSURANCE_NAME, encryption.decrypt_char(GROUP_NUMBER, '0123456789ABCDEFFEDCBA9876543210') as GROUP_NUMBER, encryption.decrypt_char(NOTES, '0123456789ABCDEFFEDCBA9876543210') as NOTES, encryption.decrypt_char(CONTACT_NUMBER, '0123456789ABCDEFFEDCBA9876543210') as CONTACT_NUMBER, encryption.decrypt_char(PRIMARY_INSURANCE_HOLDER, '0123456789ABCDEFFEDCBA9876543210') as PRIMARY_INSURANCE_HOLDER, encryption.decrypt_char(PENSION_NUMBER, '0123456789ABCDEFFEDCBA9876543210') as PENSION_NUMBER, encryption.decrypt_char(DEDUCTIBLE, '0123456789ABCDEFFEDCBA9876543210') as DEDUCTIBLE, encryption.decrypt_char(MEDICAL_NUMBER, '0123456789ABCDEFFEDCBA9876543210') as MEDICAL_NUMBER, encryption.decrypt_char(EMPLOYER, '0123456789ABCDEFFEDCBA9876543210') as EMPLOYER, encryption.decrypt_char(STATUS, '0123456789ABCDEFFEDCBA9876543210') as STATUS, encryption.decrypt_char(POLICY_NUMBER, '0123456789ABCDEFFEDCBA9876543210') as POLICY_NUMBER, INSURANCE_TYPE_LKP_ID, INSURANCE_TYPE as INSURANCETYPE from vw_insurance_lkp where patient_id = 1857 order by INSURANCE_TYPE asc
|
| g1n67hrm8zqk0 | Select user_id from user_profile where lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210'))='loadtest454_tuscan1@its.jnj.com' |
| g86u27w2866qz | select user_id from user_profile where (lower(encryption.decrypt_char(user_email, '0123456789ABCDEFFEDCBA9876543210')) = 'loadtest1@tuscan.com' or lower(encryption.decrypt_char(user_name, '0123456789ABCDEFFEDCBA9876543210')) = 'loadtest1@tuscan.com') and password = '7cbfa25a0ba328ee7c8058e62dcdbedf8544f293' and is_active = 1 |