| SQL Id | SQL Text |
|---|
| 05uqdabhzncdc | select role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3 |
| 0bxvwun87p4gj | SELECT OC.*, OD.COD_STATUS FROM COM_ORDER_ORCHESTRATION@ORCHESTRATIO OC, COM_ORDER_DETAILS@ORCHESTRATIO OD WHERE OC.OOC_COD_ID=OD.COD_ID AND OC.OOC_STATUS NOT IN (6, 7, 0, 1) AND OD.COD_STATUS!=6 AND OC.OOC_GAIA_UPDATED=0 AND OC.OOC_ORDER_ID NOT LIKE 'DELP%' AND OC.OOC_ORDER_ID NOT LIKE 'VC%' AND OC.OOC_ORDER_ID NOT LIKE 'HDSS%' AND OC.OOC_ORDER_ID NOT LIKE 'PORT%' AND OC.OOC_ORDER_ID NOT LIKE 'MIGV%' AND OC.OOC_ORDER_ID NOT LIKE 'OLT%' AND TRUNC(OC.OOC_MDATE) >TRUNC(TO_DATE('30.03.2017', 'DD.MM.YYYY')) AND ROWNUM<101 |
| 0cjngzmtm4yv1 | select reason_id, object_id, subobject_id, internal_instance_number, time_suggested, context, reason_argument_1, reason_argument_2, reason_argument_3, reason_argument_4, reason_argument_5, action_argument_1, action_argument_2, action_argument_3, action_argument_4, action_argument_5, sequence_id, metric_value, instance_name from wri$_alert_outstanding where internal_instance_number > -2 |
| 0fhtrsj58ucy3 | select * from (select ccat from client@GAIA.MAURITIUSTELECOM.COM c, doslig0@GAIA.MAURITIUSTELECOM.COM d where C.NCLI=D.NCLI and D.DATFIN_LD is null and D.ND=:dnnumber), (select mdf, ocab, FDP_1 , nd from mt_ftth_pcust@GAIA.MAURITIUSTELECOM.COM where nd=:dnnumber and end_date is null) |
| 0p4bmfh3nsqf4 | SELECT SCI_ADR_TOWN FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 19cmvrxqq51z6 | SELECT COD_ID FROM COM_ORDER_DETAILS@ORCHESTRATIO WHERE COD_ORDER_ID=:B1 AND COD_STATUS!=6 AND ROWNUM=1 |
| 1avaf8pd3vbvp | SELECT SCI_ADR_LINE2 FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 1rac8z6n21f14 | SELECT MAX(END_INTERVAL_TIME), COUNT(*) FROM WRM$_SNAPSHOT WHERE SNAP_ID = :B2 AND DBID = :B1 |
| 214uhw2336bqs | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) ) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) ) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) )) ) ORDER BY APT_DATE, APT_TIMEFROM |
| 24270097c1tsb | BEGIN SP_UP_ORDER_FAIL_STATUS(); END; |
| 24nj1juxym7v9 | select cin.*, eml.*, ctc.*, sci.*, (sysdate - cin_mdate)*24*60*60 CIN_SEC_LAST_MOD from gci_customer_info cin left outer join gci_email_info eml on cin.cin_id = eml.eml_cust_info_id and eml.eml_mdate is null left outer join gci_contact_info ctc on ctc.ctc_cust_info_id = cin.cin_id and ctc.ctc_mdate is null left outer join gci_source_customer_info sci on sci.sci_cust_info_id = cin.cin_id and sci.sci_mdate is null where cin.cin_telnum = :telnum |
| 2wvjcdckpfjqw | select * from (select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, dem_etape@GAIA.MAURITIUSTELECOM.COM e where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and e.ndem=p.pro_order_id and (e.cmotif_if='OCOM' or (does_nd_ftth@gaia.mauritiustelecom.com(tmv_telnum)>0 and pro_cmot='TECH')) union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, dem_etape@GAIA.MAURITIUSTELECOM.COM e where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and e.ndem=p.pro_order_id and e.cmotif_if='CONVW' union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, h_dem_etape@GAIA.MAURITIUSTELECOM.COM e, demande@GAIA.MAURITIUSTELECOM.COM d where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and d.ndem=p.pro_order_id and d.etat_de=5 and e.ndem=p.pro_order_id and e.cmotif_if='OCOM' union select v.*, p.pro_custcat from gci_techmig_voice v, gci_preorder p, h_dem_etape@GAIA.MAURITIUSTELECOM.COM e, demande@GAIA.MAURITIUSTELECOM.COM d where p.pro_order_id=v.tmv_order_id and p.pro_active=1 and tmv_processed=0 and d.ndem=p.pro_order_id and d.etat_de=5 and e.ndem=p.pro_order_id and e.cmotif_if='CONVW' ) where rownum<20 |
| 2xn8yx0uz75fm | SELECT S.SNAP_ID, S.BEGIN_INTERVAL, S.END_INTERVAL FROM (SELECT SS.SNAP_ID, CAST(SS.BEGIN_INTERVAL_TIME AS DATE) AS BEGIN_INTERVAL, CAST(SS.END_INTERVAL_TIME AS DATE) AS END_INTERVAL FROM WRM$_SNAPSHOT SS WHERE SS.DBID = :B3 AND SS.INSTANCE_NUMBER = :B2 AND SS.SNAP_ID <= :B1 ORDER BY SS.DBID, SS.INSTANCE_NUMBER, SS.SNAP_ID DESC) S WHERE ROWNUM <= 2 |
| 303xg5csutz8s | select tdate, TTD_FROM, TTD_TO, case (tdate) when to_date('08-04-2016', 'DD-MM-YYYY') then 4 else sum( S.TTD_MAXRDV) end totalslots from gci_ref_contractor r, gci_team t, gci_wktemplate_slot w, gci_ref_slot s, ( select rownum-1+ to_date(:date1, 'DD-MM-YYYY') as tdate from all_objects where rownum < to_date(:date2, 'DD-MM-YYYY') - to_date(:date3, 'DD-MM-YYYY') + 2) f where r.cot_id=t.tem_cot_id and r.cot_active=1 and T.TEM_COT_ID in (select cam_cot_id from gci_contractor_appt_map m, gci_ref_exchange_area a where M.CAM_AREA=A.EXA_AREA and M.CAM_REQUEST_TYPE=:requesttype and A.EXA_EXCHANGE=substr(:exch, 1, 2) ) and W.WKI_WKT_ID=T.TEM_WKT_ID and f.tdate not in (select cof_date from gci_contractor_off where cof_cot_id=tem_cot_id) and W.WKI_TTD_ID=S.TTD_ID and t.tem_active=1 and S.TTD_CANSELECT=1 and S.TTD_DAY= to_number(to_char(f.tdate, 'D'))-1 group by f.tdate, S.TTD_FROM, S.TTD_TO order by f.tdate, ttd_from |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 59nhx3wwzvp35 | select a.apt_id, a.apt_tem_id, a.apt_date, a.apt_timefrom, a.apt_timeto, a.apt_order_id, a.apt_comments, P.PRO_OEXCHANGE, P.PRO_OCAB, P.PRO_ODP, a.apt_type, a.apt_status, nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)) PRO_TELNUM , P.PRO_CONTACT, (FN_GET_LNAME(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' ' || FN_GET_FNAME(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) CUSTNAME, (FN_GET_ADR_LINE2(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' '||FN_GET_TOWN(nvl(P.PRO_TELNUM, (select nd_ref from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) as ADDRESS from gci_appointment a left outer join gci_preorder p on a.apt_order_id=p.pro_order_id, gci_team t where t.tem_id=a.apt_tem_id and t.tem_cot_id=:contractor and a.apt_date = to_date(:date1, 'DD-MM-YYYY') and ( (select count(1) from gci_user_contractor_view where ucv_user=:user1)=0 or (apt_contractto in (select ucv_cot_id from gci_user_contractor_view where ucv_user=:user1))) and apt_active=1 and (select count(1) from demande@gaia.mauritiustelecom.com where ndem = apt_order_id)>0 union select distinct a.apt_id, a.apt_tem_id, a.apt_date, a.apt_timefrom, a.apt_timeto, a.apt_order_id, a.apt_comments, P.PRO_OEXCHANGE, P.PRO_OCAB, P.PRO_ODP, a.apt_type, a.apt_status, nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)) PRO_TELNUM , P.PRO_CONTACT, (FN_GET_LNAME(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' ' || FN_GET_FNAME(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) CUSTNAME, (FN_GET_ADR_LINE2(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id))) || ' '||FN_GET_TOWN(nvl(P.PRO_TELNUM, (select nd_ref from h_demande@gaia.mauritiustelecom.com where ndem = apt_order_id)))) as ADDRESS from gci_appointment a inner join gci_preorder p on a.apt_order_id=p.pro_order_id inner join h_demande@gaia.mauritiustelecom.com on ndem=p.pro_order_id, gci_team t where t.tem_id=a.apt_tem_id and t.tem_cot_id=:contractor and a.apt_date = to_date(:date1, 'DD-MM-YYYY') and ( (select count(1) from gci_user_contractor_view where ucv_user=:user1)=0 or (apt_contractto in (select ucv_cot_id from gci_user_contractor_view where ucv_user=:user1))) and apt_active=1 |
| 5ms1dhxbadq64 | update wrm$_snapshot set status = 0, flush_elapsed = greatest((cast(SYSDATE as TIMESTAMP) - end_interval_time), interval '00.10' second) where snap_id = :snap_id and dbid = :dbid and instance_number = :instance_number |
| 5rygsj4dbw6jt | insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7) |
| 5tg3np52g8wym | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) and APT_ORDER_ID=:orderid)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| 5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
| 5uy533jsc8hyh | DELETE MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP < :B2 AND ROWNUM <= :B1 |
| 6c4zzpnd5y0p4 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, D.PRO_TELNUM telnum, A1.APT_DATE, A1.APT_TIMEFROM, A1.APT_TIMETO, FN_APPT_MISSED_RESCH(A1.APT_ORDER_ID) as APT_STATUS, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(pro_telnum) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) as CONTACTS, FN_GET_LNAME(pro_telnum) as LNAME, FN_GET_ADR_LINE1(pro_telnum) as ADDRESSNO, FN_GET_ADR_LINE2(pro_telnum) as ADDRESS, FN_GET_TOWN(pro_telnum) as TOWN, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID ) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID ) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 )) ) ORDER BY APT_DATE, APT_TIMEFROM |
| 6d9gv6u9vn1mf | INSERT INTO MGMT_METRICS_1HOUR ( TARGET_GUID, METRIC_GUID, ROLLUP_TIMESTAMP, KEY_VALUE, SAMPLE_COUNT, VALUE_AVERAGE, VALUE_MINIMUM, VALUE_MAXIMUM, VALUE_SDEV ) VALUES ( :B9 , :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 ) |
| 6f76vp10jw09c | INSERT INTO GCI_CUSTOMER_ORDER_PHOTO ( COP_ORDER_ID, COP_IMAGE_NAME, COP_IMAGE_TYPE, COP_CDATE, COP_CREATED_BY) VALUES (:orderid, :imagename, :imagetype, sysdate, :agent) |
| 75n0zz4t6a3wu | select s.*, (select pro_iptv_codes from gci_preorder where pro_order_id=s.ssi_order_id) iptvcodes, (select pro_old_iptvcodes from gci_preorder where pro_order_id=s.ssi_order_id) oldiptvcodes from gci_sms_info s where ssi_sent=0 and (has_order_ocom@GAIA.MAURITIUSTELECOM.COM(ssi_order_id) in (1, 3) or FN_HAS_TV_PROVISION(ssi_order_id)>0) |
| 76cckj4yysvua | select time_mp, scn, num_mappings, tim_scn_map from smon_scn_time where scn = (select max(scn) from smon_scn_time where scn <= :1) |
| 7zsc0j9jsfm0h | select last_sample_date_num, last_sample_date, total_samples from WRI$_DBU_CPU_USAGE_SAMPLE where dbid = :dbid and version = :version |
| 8adtzvrzw9ncn | BEGIN SP_MIGRATE_TELNUM_FTTH ( :I_TELNUM, :I_FILEID, :O_RESPONSE, :O_MESSAGE ); END; |
| 8n9b3uw6s8upk | SELECT * FROM ( select pro_oexchange as exch from gci_preorder where pro_order_id = :orderid), ( SELECT ftw_ocab AS ocab FROM gci_ftth_wo WHERE ftw_order_id = :orderid AND ROWNUM = 1 ORDER BY ftw_id DESC), ( SELECT ftw_fdp1 AS fdp FROM gci_ftth_wo WHERE ftw_order_id = :orderid AND ROWNUM = 1 ORDER BY ftw_id DESC), ( SELECT FTW_PRODUCT AS servicetype FROM gci_ftth_wo WHERE ftw_order_id = :orderid AND ROWNUM = 1 ORDER BY ftw_id DESC) |
| 8p9z2ztb272bm | SELECT sx.instance_number, sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.instance_number, s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst AND s.snap_id >= :bid AND s.snap_id <= :eid AND s.status = 0 AND x.ver_type = :existence ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = sx.instance_number AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.instance_number, sx.id ORDER BY sx.instance_number |
| 9fagk3bp50rfm | SELECT SCI_LNAME FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TELNUM=:B1 AND CIN_TEL_TYPE=0 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 9fuuktgp1gjcz | SELECT SCI_FNAME FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TEL_TYPE=0 AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| 9h6gruxdt21y7 | select pr.pro_id, pr.pro_order_id, pr.pro_telnum, FN_GET_FNAME(pro_telnum) firstname, FN_GET_LNAME(pro_telnum) lastname, FN_GET_CLIENTID@GAIA.MAURITIUSTELECOM.COM(pro_telnum) CLIENTID, FN_GET_ADR_LINE1(pro_telnum)||' '|| FN_GET_ADR_LINE2(pro_telnum) address, get_nd_ftth_const@GAIA.MAURITIUSTELECOM.COM(pro_telnum) ftthconst, FN_GET_CONTACT(pro_telnum) contactnum, nvl(pro_rbs_id, 'rbs_us') pro_rbs_id, nvl(pro_rbs_password, 'rbs_pw') pro_rbs_pwd, pro_product, (select rbc_value from gci_ref_bandwidth_cap, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbc_id=rbo_cap_bw) volcap, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_up_bw) uploadbw, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_down_bw) downloadbw, '.' salutation, get_dn_switch@GAIA.MAURITIUSTELECOM.COM(pr.pro_telnum) switchinfo, pro_voip, pro_custcat from gci_preorder pr inner join demande@gaia.mauritiustelecom.com on ndem=pro_order_id where pro_cmot = 'TECH' and pro_Sdate is null -- and pro_bboffer is not null and pro_active = 1 and (pro_failure_code != 'CCF' or pro_failure_code is null or pro_failure_code = '0') and pro_order_id is not null -- and pro_order_id in ('9407247') and (select count(1) from doslig0@gaia.mauritiustelecom.com d0, client@gaia.mauritiustelecom.com c where d0.ncli=c.ncli and nd=pr.pro_telnum and datfin_ld is null)=1 and (select count(1) from mt_ftth_pcust@gaia.mauritiustelecom.com where nd=pr.pro_telnum and end_date is null and FDP_1 is not null)>0 and rownum <11 and pro_custcat=0 |
| 9k3b77d55fjwa | select distinct PRO_FAILURE_CODE from gci_preorder where pro_failure_code is not null and pro_failure_code!='0' order by PRO_FAILURE_CODE |
| 9wncfacx0nj9h | insert into smon_scn_time (thread, time_mp, time_dp, scn, scn_wrp, scn_bas, num_mappings, tim_scn_map) values (0, :1, :2, :3, :4, :5, :6, :7) |
| 9yppwa0sj1ssr | select tdate, TTD_FROM, TTD_TO, sum( S.TTD_MAXRDV) totalslots from gci_team t, gci_wktemplate_slot w, gci_ref_slot s, ( select rownum-1+ to_date(:date1, 'DD-MM-YYYY') as tdate from all_objects where rownum < to_date(:date2, 'DD-MM-YYYY') - to_date(:date3, 'DD-MM-YYYY') + 2) f where T.TEM_COT_ID=:contractorid and W.WKI_WKT_ID=T.TEM_WKT_ID and s.ttd_canselect=1 and f.tdate not in (select cof_date from gci_contractor_off where cof_cot_id=:contractorid) and W.WKI_TTD_ID=S.TTD_ID and t.tem_active=1 and S.TTD_DAY= to_number(to_char(f.tdate, 'D'))-1 group by f.tdate, S.TTD_FROM, S.TTD_TO order by f.tdate, ttd_from |
| a6c3pbk2hu72w | SELECT COUNT(1) FROM COM_ORDER_ORCHESTRATION@ORCHESTRATIO WHERE OOC_COD_ID=:B1 AND OOC_INT_ID=13 AND OOC_STATUS=9 |
| ayhsygk061114 | SELECT METRIC_GUID, TRUNC(ROLLUP_TIMESTAMP, 'DD'), KEY_VALUE, SUM(SAMPLE_COUNT), MIN(VALUE_MINIMUM), MAX(VALUE_MAXIMUM), SUM(SAMPLE_COUNT * VALUE_AVERAGE), SUM((POWER(VALUE_SDEV, 2) * (SAMPLE_COUNT-1)) + (SAMPLE_COUNT * POWER(VALUE_AVERAGE, 2))) FROM MGMT_METRICS_1HOUR WHERE TARGET_GUID = :B3 AND ROLLUP_TIMESTAMP >= (:B2 +1) AND ROLLUP_TIMESTAMP < (:B1 +1) GROUP BY TARGET_GUID, METRIC_GUID, KEY_VALUE, TRUNC(ROLLUP_TIMESTAMP, 'DD') |
| b3z033yhdff5u | SELECT "PRO_ID", "PRO_TELNUM", "PRO_EXCHANGE", "PRO_CABINET", "PRO_DP", "PRO_BBOFFER", "PRO_ORDER_ID", "PRO_CDATE", "PRO_CREATED_BY", "PRO_MDATE", "PRO_MOD_BY", "PRO_TECHNO", "PRO_ORDER_TYPE", "PRO_PRODUCT", "PRO_RBS_ID", "PRO_RBS_PASSWORD", "PRO_IPTV_PACK", "PRO_IPTV_PARENT_UID", "PRO_DEEZER_ID", "PRO_DEEZER_ACTION", "PRO_FEASIBLE_BBOFFERS", "PRO_RDATE", "PRO_SDATE", "PRO_OEXCHANGE", "PRO_OCAB", "PRO_ODP", "PRO_CONTACT", "PRO_COMMENTS", "PRO_CEASEDATE", "PRO_RESUMEDATE", "PRO_LIVEBOX", "PRO_SETUPBOX", "PRO_REMOTECONTROL", "PRO_ACCESSORIES", "PRO_WITHLINE", "PRO_FAILURE_CODE", "PRO_WITHINSTALLATION", "PRO_SERIALNO", "PRO_INSTAL_FEE", "PRO_BW_ACTION", "PRO_REINST", "PRO_CHANNELACTION", "PRO_CUSTCAT", "PRO_CMOT", "PRO_RESUMED_DATE", "PRO_OWNMODEM", "PRO_IPADDR", "PRO_IPTV_PARENT_PWD", "PRO_GAIA_COMMENT", "PRO_MULTIDEVICE", "PRO_APPT", "PRO_ACTIVE", "PRO_GAIA_STATUS", "PRO_OLDRBS_ID", "PRO_OLDPACKAGE", "PRO_PENALTY", "PRO_EMAIL", "PRO_DUAL", "PRO_DUALINSFEE", "PRO_IMSPWD", "PRO_OFFERTYPE", "PRO_BILLINGCOMMENTS", "PRO_POWERLINE", "PRO_IPTV_CODES", "PRO_WE", "PRO_LB", "PRO_UG", "PRO_IW", "PRO_OLD_IPTVCODES", "PRO_NEWLINE", "PRO_APPL_NAME", "PRO_APPL_FNAME", "PRO_APPL_NREGNO", "PRO_ISP", "PRO_SECONDLINE", "PRO_TRANSFER", "PRO_VOIP" FROM "GCI_PREORDER" "GCI_PREORDER" WHERE "PRO_CDATE">TO_DATE('2015-02-06 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND "PRO_GAIA_STATUS" IS NULL |
| b8j6sjgx4frbm | SELECT SCI_ADR_LINE1 FROM GCI_SOURCE_CUSTOMER_INFO, GCI_CUSTOMER_INFO WHERE SCI_CUST_INFO_ID=CIN_ID AND CIN_TELNUM=:B1 AND ROWNUM=1 ORDER BY SCI_CDATE DESC |
| bsagk16mvmcxg | SELECT COUNT(1) FROM GCI_TECHMIG_VOICE WHERE TMV_ORDER_ID= :B1 |
| budukp19s6663 | select distinct PRO_CREATED_BY from gci_preorder order by PRO_CREATED_BY |
| c14yg17bhzqnr | SELECT COUNT(1) FROM GCI_FTTH_WO WHERE FTW_COT_ID=:B2 AND FTW_APTDATE=TRUNC(:B1 ) AND FTW_APT_ID NOT IN ( SELECT APT_ID FROM GCI_APPOINTMENT WHERE APT_DATE=TRUNC(:B1 ) AND APT_DEPLOYTO IN (SELECT TEM_ID FROM GCI_TEAM WHERE TEM_COT_ID=:B2 ) AND APT_ACTIVE=1 AND APT_TYPE=:B3 ) |
| cfk4qsrg681sz | SELECT MIN(END_INTERVAL_TIME), COUNT(*) FROM WRM$_SNAPSHOT WHERE SNAP_ID = :B2 AND DBID = :B1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cw4zts3yydvgs | SELECT APT_DATE AS APTDATE, APT_TYPE AS APTTYPE, (SELECT COT_NAME FROM GCI_REF_CONTRACTOR WHERE COT_ID=A.APT_CONTRACTTO) AS CONTRACTOR, A.APT_CONTRACTTO TEM_COT_ID, APT_ID, TEM_ID, TEM_NAME AS TEAM, APT_TIMEFROM||'-'||APT_TIMETO AS APPOINTMENT, NVL(PRO_TELNUM, '') AS ND, FN_GET_FNAME(PRO_TELNUM) AS FNAME, (NVL(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) AS CONTACTS, FN_GET_LNAME(PRO_TELNUM) AS LNAME, FN_GET_ADR_LINE1(PRO_TELNUM) AS ADDRESSNO, FN_GET_ADR_LINE2(PRO_TELNUM) AS ADDRESS, FN_GET_TOWN(PRO_TELNUM) AS TOWN, FN_GET_EMAIL_WO(PRO_TELNUM, PRO_ORDER_ID) AS EMAIL, '' OLT, NVL(PRO_OCAB, '') OCAB, NVL(PRO_ODP, '') FDP, NVL(PRO_OEXCHANGE, '') EXCHANGE, '' FDP_PORT_ID, '' ONT_ID, '' ONT_TYPE, '' ONU_ID, '' SHELF, '' CARD, '' PORTONMMS, '' INTERNETVLAN, '' IPTVVLAN, APT_ORDER_ID AS ORDER_ID, (SELECT GIP_USERNAME FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1) AS ITPV_PARENT_ID, (SELECT GIP_PASSWORD FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1) AS IPTV_PARENT_PWD, FN_GET_STB_ACC(PRO_TELNUM) AS ITPV_CHILD_ID, NVL((SELECT GIP_PASSWORD FROM GCI_IPTV_ZTE WHERE GIP_TELNUM=PRO_TELNUM AND GIP_PARENT_ID IS NULL AND GIP_DATE_EXP IS NULL AND ROWNUM=1), PRO_IPTV_PARENT_PWD) AS ITPV_CHILD_PWD, '1234' AS PARENTLOCK, PRO_RBS_ID AS RBS_USERNAME, PRO_RBS_PASSWORD AS RBS_PWD, PRO_PRODUCT AS PRODUCT, PRO_CUSTCAT, (CASE PRO_CUSTCAT WHEN 0 THEN 'RESIDENTIAL' WHEN 1 THEN 'BUSINESS' END) CUSTCATEGORY, (SELECT C.CRQ_NAME || ' ' || C.CRQ_ONAME FROM GCI_CUSTOMER_REQUEST C WHERE C.CRQ_ORDER_ID=PRO_ORDER_ID) APPLICANT, PRO_LB, PRO_UG, PRO_IW, (CASE WHEN PRO_BBOFFER >50 THEN FN_GET_BIZ_BOOST_REMARKS(PRO_BBOFFER) ELSE '' END) REMARKS, PRO_NEWLINE FROM GCI_APPOINTMENT A LEFT OUTER JOIN GCI_PREORDER ON A.APT_ORDER_ID=PRO_ORDER_ID, GCI_TEAM T WHERE TRUNC(A.APT_DATE) = TRUNC(:B3 ) AND APT_TYPE=:B2 AND APT_ACTIVE=1 AND T.TEM_ID=A.APT_DEPLOYTO AND A.APT_CONTRACTTO=:B1 AND APT_ORDER_ID IS NOT NULL ORDER BY APT_TIMEFROM, TEM_ID |
| d8ubrz9puj1g8 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, '')) as telnum, A1.APT_DATE, A1.APT_CDATE, A1.APT_TIMEFROM, A1.APT_TIMETO, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))))) as CONTACTS, FN_GET_LNAME(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as LNAME, FN_GET_ADR_LINE1(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESSNO, FN_GET_ADR_LINE2(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as ADDRESS, FN_GET_TOWN(nvl((select nd_ref from demande@gaia.mauritiustelecom.com where ndem=A1.APT_ORDER_ID), nvl(D.PRO_TELNUM, ''))) as TOWN, (select ftw_fdp1 from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as fdp, (select ftw_ocab from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as ocab, (select substr(ftw_olt, 10, 2) from gci_ftth_wo where ftw_order_id=A1.APT_ORDER_ID and rownum=1) as mdf, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID = C.COT_ID and C.COT_ID=:contractor) and APT_ACTIVE=:active) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (B.TEM_COT_ID=C.COT_ID and C.COT_ID in (select cot_id from gci_ref_contractor where cot_group_id=:contractor)) and APT_ACTIVE=:active) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and (A.APT_CONTRACTTO=:contractor and a.apt_contractto=c.cot_id and c.cot_id=b.tem_cot_id) and APT_ACTIVE=:active)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
| dma0vxbwh325p | update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4, scn_bas=:5, num_mappings=:6, tim_scn_map=:7 where scn = (select min(scn) from smon_scn_time) |
| f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
| fvn3hc67hfy9q | SELECT CTC_CONTACT_NO FROM GCI_CONTACT_INFO, GCI_CUSTOMER_INFO WHERE CTC_CUST_INFO_ID= CIN_ID AND CIN_TELNUM=:B1 AND CTC_MDATE IS NULL |
| g0wc1rhrab1pf | BEGIN SP_GENERATE_WO2(to_date(:apt_date, 'DD-MM-YYYY'), :cot_id, :apt_type); END; |
| g1bcfg698634h | select nvl((select cot_name from gci_ref_contractor where cot_id=ftw_cot_id), 'CMC') Contractor, (select tem_name from gci_team where tem_id=ftw_tem_id) Team, (select apt_date||' '|| apt_timefrom||':'||apt_timeto from gci_appointment where apt_id=ftw_apt_id) appointment, ftw_lname as Name, ftw_fname as Firstname, ftw_contactno as Contactno, ftw_addressno as AddressNo, ftw_streetname as Streetname, ftw_locality as Locality, ftw_olt as OLT, ftw_ocab as OCAB, ftw_fdp1 as FDP_1, ftw_fdpport_id as FDPPort_id, ftw_ont_id as ONT_ID, ftw_ont_type as ONT_TYPE, ftw_onu_id as ONU_ID, ftw_shelf as SHELF, ftw_card as Card, ftw_port as Port, ftw_internet_vlan as Internet_vlan, ftw_iptv_vlan as IPTV_VLAN, ftw_order_id as Order_id, ftw_IPTV_PARENTID as IPTV_PARENT_ID, ftw_IPTV_PARENTPWD as IPTV_PARENT_PWD, ftw_stbaccounts as STBACCOUNTS, ftw_IPTV_PASSWORD as STB_PASSWORD, ftw_parentlock as parentlock, ftw_bboffername as offer, ftw_rbsusername as RBSusername, ftw_rbspassword as RBSPassowrd, (case ftw_custcat when 0 then 'Residential' when 1 then 'Business' end) as Category, ftw_ordercdate, to_char(ftw_ordercdate, 'hh24:mi:ss') as orderTime, (select pro_iptv_codes from gci_preorder where pro_order_id = ftw_order_id) as IPTV_CODES, ftw_refno, ftw_tvbouquetname, ftw_iptvaddonsname, ftw_we as WirelessExtender, ftw_powerline as PowerLine, ftw_dualroom as DualRoom, (case ftw_lb when 0 then 'No' when 1 then 'Yes' end) as large_building, (case ftw_ug when 0 then 'No' when 1 then 'Yes' end) as underground_cabling, (case ftw_iw when 0 then 'No' when 1 then 'Yes' end) as internal_wiring, ftw_telnum as telnum, (select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual) as current_service, (select LART from p_cathors@gaia.mauritiustelecom.com where abrv_art =((select GET_ND_BB_SERV_PROMOS@gaia.mauritiustelecom.com(ftw_telnum) from dual)) and rownum=1) as current_service_label, (select count(ndem) from demande@gaia.mauritiustelecom.com where ndem = ftw_order_id) as ndemNotPS, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WWIP') as workSTART, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WCOM') as workCOM, (select count(cws_order_id) from gci_contractor_work_status where cws_order_id = ftw_order_id and cws_status = 'WAPRE') as workNOTCOM, (select nvl(apt_comments, '--') from gci_appointment where apt_order_id = ftw_order_id and apt_date=to_date(:i_aptdate, 'DD-MM-YYYY') and rownum=1) as aptComments, ftw_offer as offer_comments from gci_ftth_wo where ftw_tem_id=:i_tem_id and ftw_aptdate=to_date(:i_aptdate, 'DD-MM-YYYY') and ftw_survey=0 order by appointment, firstname |
| g3bjqa5xz1hg7 | select pr.pro_id, pr.pro_order_id, pr.pro_telnum, FN_GET_FNAME(pro_telnum) firstname, FN_GET_LNAME(pro_telnum) lastname, FN_GET_CLIENTID@GAIA.MAURITIUSTELECOM.COM(pro_telnum) CLIENTID, FN_GET_ADR_LINE1(pro_telnum)||' '|| FN_GET_ADR_LINE2(pro_telnum) address, get_nd_ftth_const@GAIA.MAURITIUSTELECOM.COM(pro_telnum) ftthconst, FN_GET_CONTACT(pro_telnum) contactnum, nvl(pro_rbs_id, 'rbs_us') pro_rbs_id, nvl(pro_rbs_password, 'rbs_pw') pro_rbs_pwd, pro_product, (select rbc_value from gci_ref_bandwidth_cap, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbc_id=rbo_cap_bw) volcap, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_up_bw) uploadbw, (select rbw_value from gci_ref_bandwidth, gci_ref_bb_offer bo where bo.rbo_id=pro_bboffer and rbw_id=rbo_down_bw) downloadbw, '.' salutation, get_dn_switch@GAIA.MAURITIUSTELECOM.COM(pr.pro_telnum) switchinfo, pro_voip, pro_custcat from gci_preorder pr inner join demande@gaia.mauritiustelecom.com on ndem=pro_order_id where pro_cmot = 'TECH' and pro_Sdate is null -- and pro_bboffer is not null and pro_active = 1 and (pro_failure_code != 'CCF' or pro_failure_code is null or pro_failure_code = '0') and pro_order_id is not null -- and pro_order_id in ('9407247') and (select count(1) from doslig0@gaia.mauritiustelecom.com d0, client@gaia.mauritiustelecom.com c where d0.ncli=c.ncli and nd=pr.pro_telnum and datfin_ld is null)=1 and (select count(1) from mt_ftth_pcust@gaia.mauritiustelecom.com where nd=pr.pro_telnum and end_date is null and FDP_1 is not null)>0 and rownum <11 and pro_custcat=1 |
| gf3sppxmsmarf | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, D.PRO_TELNUM telnum, A1.APT_DATE, A1.APT_TIMEFROM, A1.APT_TIMETO, FN_APPT_MISSED_RESCH(A1.APT_ORDER_ID) as APT_STATUS, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(pro_telnum) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) as CONTACTS, FN_GET_LNAME(pro_telnum) as LNAME, FN_GET_ADR_LINE1(pro_telnum) as ADDRESSNO, FN_GET_ADR_LINE2(pro_telnum) as ADDRESS, FN_GET_TOWN(pro_telnum) as TOWN, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and APT_ORDER_ID=:orderid) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate and APT_ORDER_ID=:orderid)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| gm9t6ycmb1yu6 | delete from smon_scn_time where scn = (select min(scn) from smon_scn_time) |
| gsdu2p1wkasu9 | SELECT distinct A1.APT_ID, A1.APT_ORDER_ID, D.PRO_TELNUM telnum, A1.APT_DATE, A1.APT_TIMEFROM, A1.APT_TIMETO, FN_APPT_MISSED_RESCH(A1.APT_ORDER_ID) as APT_STATUS, CASE A1.APT_TYPE WHEN 1 THEN 'NORMAL' WHEN 2 THEN 'MISC' END APT_TYPE, CASE A1.APT_ACTIVE WHEN 1 THEN 'ACTIVE' WHEN 2 THEN 'CANCEL' END APT_ACTIVE, (select tem_name from gci_team where tem_id=apt_tem_id) TEAM, (select COT_NAME from gci_ref_contractor, gci_team where tem_cot_id=cot_id and tem_id=apt_tem_id) CONTRACTOR, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_login=A1.APT_CREATEDBY), A1.APT_CREATEDBY) REGISTERED_BY, A1.APT_MODBY MODIFIED_BY, FN_GET_FNAME(pro_telnum) as FNAME, (nvl(PRO_CONTACT, FN_GET_CONTACT_1(PRO_TELNUM))) as CONTACTS, FN_GET_LNAME(pro_telnum) as LNAME, FN_GET_ADR_LINE1(pro_telnum) as ADDRESSNO, FN_GET_ADR_LINE2(pro_telnum) as ADDRESS, FN_GET_TOWN(pro_telnum) as TOWN, get_last_orderstatus@GAIA.MAURITIUSTELECOM.COM(apt_order_id) orderstatus, nvl((select usr_lastname ||' '||usr_firstname from gci_user_tech where usr_team=A1.APT_DEPLOYTO and rownum=1), 'NOT DEPLOYED') deploy_to, nvl((select cot_name from gci_ref_contractor where cot_id=A1.APT_CONTRACTTO and rownum=1), 'NOT CONTRACTED' ) contract_to, (select count(1) from gci_customer_order_photo where cop_order_id=pro_order_id) numphoto FROM gci_appointment A1 left join gci_preorder D on a1.apt_order_id=d.pro_order_id WHERE A1.APT_ID in( select distinct apt_id from ( (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate) union (select apt_id from gci_appointment A , gci_team B, gci_ref_contractor C WHERE A.APT_TEM_ID = B.TEM_ID and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate) union (select apt_id from gci_appointment a, gci_ref_contractor c, gci_team b where b.tem_active=1 and to_char(A.APT_DATE, 'DD-MM-YYYY') = :aptdate)) ) ORDER BY APT_DATE, APT_TIMEFROM |
| Statistic | Total | per Second | per Trans |
|---|
| Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
| Batched IO (full) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 0 | 0.00 | 0.00 |
| Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
| Batched IO double miss count | 0 | 0.00 | 0.00 |
| Batched IO same unit count | 0 | 0.00 | 0.00 |
| Batched IO single block count | 0 | 0.00 | 0.00 |
| Batched IO slow jump count | 0 | 0.00 | 0.00 |
| Batched IO vector block count | 0 | 0.00 | 0.00 |
| Batched IO vector read count | 0 | 0.00 | 0.00 |
| Block Cleanout Optim referenced | 94 | 0.03 | 0.02 |
| CCursor + sql area evicted | 0 | 0.00 | 0.00 |
| CPU used by this session | 452,286 | 124.95 | 72.32 |
| CPU used when call started | 132,049 | 36.48 | 21.11 |
| CR blocks created | 190 | 0.05 | 0.03 |
| Cached Commit SCN referenced | 3,290 | 0.91 | 0.53 |
| Commit SCN cached | 14 | 0.00 | 0.00 |
| DB time | 1,026,412 | 283.55 | 164.12 |
| DBWR checkpoint buffers written | 7,272 | 2.01 | 1.16 |
| DBWR checkpoints | 14 | 0.00 | 0.00 |
| DBWR object drop buffers written | 0 | 0.00 | 0.00 |
| DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
| DBWR tablespace checkpoint buffers written | 51 | 0.01 | 0.01 |
| DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
| DBWR transaction table writes | 207 | 0.06 | 0.03 |
| DBWR undo block writes | 3,475 | 0.96 | 0.56 |
| Effective IO time | 0 | 0.00 | 0.00 |
| HSC Heap Segment Block Changes | 32,758 | 9.05 | 5.24 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 145 | 0.04 | 0.02 |
| Heap Segment Array Updates | 188 | 0.05 | 0.03 |
| IMU CR rollbacks | 2 | 0.00 | 0.00 |
| IMU Flushes | 638 | 0.18 | 0.10 |
| IMU Redo allocation size | 629,928 | 174.02 | 100.72 |
| IMU commits | 2,804 | 0.77 | 0.45 |
| IMU contention | 2 | 0.00 | 0.00 |
| IMU ktichg flush | 0 | 0.00 | 0.00 |
| IMU pool not allocated | 1 | 0.00 | 0.00 |
| IMU recursive-transaction flush | 0 | 0.00 | 0.00 |
| IMU undo allocation size | 6,068,504 | 1,676.44 | 970.34 |
| IMU- failed to get a private strand | 1 | 0.00 | 0.00 |
| LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
| Misses for writing mapping | 0 | 0.00 | 0.00 |
| Number of read IOs issued | 4,656 | 1.29 | 0.74 |
| Requests to/from client | 67,637 | 18.68 | 10.81 |
| RowCR - row contention | 1 | 0.00 | 0.00 |
| RowCR attempts | 336 | 0.09 | 0.05 |
| RowCR hits | 335 | 0.09 | 0.05 |
| SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
| SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
| SQL*Net roundtrips to/from client | 67,654 | 18.69 | 10.82 |
| SQL*Net roundtrips to/from dblink | 462,413 | 127.74 | 73.94 |
| TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
| TBS Extension: files extended | 0 | 0.00 | 0.00 |
| TBS Extension: tasks created | 0 | 0.00 | 0.00 |
| TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
| active txn count during cleanout | 163 | 0.05 | 0.03 |
| application wait time | 210 | 0.06 | 0.03 |
| background checkpoints completed | 1 | 0.00 | 0.00 |
| background checkpoints started | 2 | 0.00 | 0.00 |
| background timeouts | 21,861 | 6.04 | 3.50 |
| branch node splits | 1 | 0.00 | 0.00 |
| buffer is not pinned count | 6,157,769 | 1,701.10 | 984.61 |
| buffer is pinned count | 140,406,086 | 38,787.56 | 22,450.61 |
| bytes received via SQL*Net from client | 25,594,326 | 7,070.50 | 4,092.47 |
| bytes received via SQL*Net from dblink | 312,088,721 | 86,215.35 | 49,902.26 |
| bytes sent via SQL*Net to client | 3,230,303,281 | 892,380.03 | 516,517.95 |
| bytes sent via SQL*Net to dblink | 91,214,523 | 25,198.26 | 14,584.99 |
| calls to get snapshot scn: kcmgss | 1,417,954 | 391.71 | 226.73 |
| calls to kcmgas | 41,540 | 11.48 | 6.64 |
| calls to kcmgcs | 1,352,472 | 373.62 | 216.26 |
| cell physical IO interconnect bytes | 5,563,497,984 | 1,536,931.39 | 889,590.34 |
| change write time | 465 | 0.13 | 0.07 |
| cleanout - number of ktugct calls | 350 | 0.10 | 0.06 |
| cleanouts and rollbacks - consistent read gets | 26 | 0.01 | 0.00 |
| cleanouts only - consistent read gets | 31 | 0.01 | 0.00 |
| cluster key scan block gets | 206,801 | 57.13 | 33.07 |
| cluster key scans | 206,557 | 57.06 | 33.03 |
| commit batch performed | 2,778 | 0.77 | 0.44 |
| commit batch requested | 2,778 | 0.77 | 0.44 |
| commit batch/immediate performed | 2,841 | 0.78 | 0.45 |
| commit batch/immediate requested | 2,841 | 0.78 | 0.45 |
| commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 67 | 0.02 | 0.01 |
| commit cleanout failures: cannot pin | 111 | 0.03 | 0.02 |
| commit cleanouts | 37,252 | 10.29 | 5.96 |
| commit cleanouts successfully completed | 37,074 | 10.24 | 5.93 |
| commit immediate performed | 63 | 0.02 | 0.01 |
| commit immediate requested | 63 | 0.02 | 0.01 |
| commit txn count during cleanout | 780 | 0.22 | 0.12 |
| concurrency wait time | 11,942 | 3.30 | 1.91 |
| consistent changes | 821 | 0.23 | 0.13 |
| consistent gets | 105,386,257 | 29,113.24 | 16,851.02 |
| consistent gets - examination | 4,177,694 | 1,154.10 | 668.00 |
| consistent gets direct | 574,176 | 158.62 | 91.81 |
| consistent gets from cache | 104,812,085 | 28,954.62 | 16,759.21 |
| consistent gets from cache (fastpath) | 99,848,580 | 27,583.44 | 15,965.55 |
| cursor authentications | 17 | 0.00 | 0.00 |
| data blocks consistent reads - undo records applied | 809 | 0.22 | 0.13 |
| db block changes | 174,597 | 48.23 | 27.92 |
| db block gets | 192,906 | 53.29 | 30.85 |
| db block gets direct | 45 | 0.01 | 0.01 |
| db block gets from cache | 192,861 | 53.28 | 30.84 |
| db block gets from cache (fastpath) | 24,257 | 6.70 | 3.88 |
| deferred (CURRENT) block cleanout applications | 19,445 | 5.37 | 3.11 |
| dirty buffers inspected | 1 | 0.00 | 0.00 |
| enqueue conversions | 1,334,314 | 368.61 | 213.35 |
| enqueue releases | 323,310 | 89.32 | 51.70 |
| enqueue requests | 323,319 | 89.32 | 51.70 |
| enqueue timeouts | 0 | 0.00 | 0.00 |
| enqueue waits | 17 | 0.00 | 0.00 |
| exchange deadlocks | 0 | 0.00 | 0.00 |
| execute count | 1,415,456 | 391.02 | 226.33 |
| failed probes on index block reclamation | 0 | 0.00 | 0.00 |
| file io service time | 2,718 | 0.75 | 0.43 |
| file io wait time | 208,949,144 | 57,722.77 | 33,410.48 |
| free buffer inspected | 8,050 | 2.22 | 1.29 |
| free buffer requested | 9,690 | 2.68 | 1.55 |
| heap block compress | 311 | 0.09 | 0.05 |
| hot buffers moved to head of LRU | 27,888 | 7.70 | 4.46 |
| immediate (CR) block cleanout applications | 57 | 0.02 | 0.01 |
| immediate (CURRENT) block cleanout applications | 1,007 | 0.28 | 0.16 |
| in call idle wait time | 19,866,967 | 5,488.30 | 3,176.68 |
| index crx upgrade (positioned) | 0 | 0.00 | 0.00 |
| index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 284,753 | 78.66 | 45.53 |
| index fetch by key | 1,066,664 | 294.67 | 170.56 |
| index scans kdiixs1 | 1,436,985 | 396.97 | 229.77 |
| leaf node 90-10 splits | 40 | 0.01 | 0.01 |
| leaf node splits | 53 | 0.01 | 0.01 |
| lob reads | 0 | 0.00 | 0.00 |
| lob writes | 67 | 0.02 | 0.01 |
| lob writes unaligned | 67 | 0.02 | 0.01 |
| logical read bytes from cache | 860,200,656,896 | 237,632,762.05 | 137,544,076.89 |
| logons cumulative | 12,835 | 3.55 | 2.05 |
| max cf enq hold time | 0 | 0.00 | 0.00 |
| messages received | 33,718 | 9.31 | 5.39 |
| messages sent | 33,718 | 9.31 | 5.39 |
| min active SCN optimization applied on CR | 1,929 | 0.53 | 0.31 |
| no buffer to keep pinned count | 657,498 | 181.64 | 105.13 |
| no work - consistent read gets | 99,830,389 | 27,578.42 | 15,962.65 |
| non-idle wait count | 2,904,745 | 802.44 | 464.46 |
| non-idle wait time | 567,806 | 156.86 | 90.79 |
| opened cursors cumulative | 1,416,320 | 391.26 | 226.47 |
| parse count (describe) | 0 | 0.00 | 0.00 |
| parse count (failures) | 0 | 0.00 | 0.00 |
| parse count (hard) | 157 | 0.04 | 0.03 |
| parse count (total) | 124,449 | 34.38 | 19.90 |
| parse time cpu | 3,323 | 0.92 | 0.53 |
| parse time elapsed | 28,551 | 7.89 | 4.57 |
| physical read IO requests | 9,041 | 2.50 | 1.45 |
| physical read bytes | 4,738,490,368 | 1,309,020.80 | 757,673.55 |
| physical read total IO requests | 39,784 | 10.99 | 6.36 |
| physical read total bytes | 5,286,029,312 | 1,460,279.92 | 845,223.75 |
| physical read total multi block requests | 4,560 | 1.26 | 0.73 |
| physical reads | 578,429 | 159.79 | 92.49 |
| physical reads cache | 4,385 | 1.21 | 0.70 |
| physical reads cache prefetch | 0 | 0.00 | 0.00 |
| physical reads direct | 574,044 | 158.58 | 91.79 |
| physical reads direct (lob) | 0 | 0.00 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 3,177 | 0.88 | 0.51 |
| physical write bytes | 59,949,056 | 16,561.09 | 9,585.71 |
| physical write total IO requests | 42,684 | 11.79 | 6.83 |
| physical write total bytes | 277,468,672 | 76,651.47 | 44,366.59 |
| physical write total multi block requests | 234 | 0.06 | 0.04 |
| physical writes | 7,318 | 2.02 | 1.17 |
| physical writes direct | 45 | 0.01 | 0.01 |
| physical writes direct (lob) | 0 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes from cache | 7,273 | 2.01 | 1.16 |
| physical writes non checkpoint | 4,254 | 1.18 | 0.68 |
| pinned buffers inspected | 2 | 0.00 | 0.00 |
| pinned cursors current | 1 | 0.00 | 0.00 |
| prefetch clients - default | 414 | 0.11 | 0.07 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 19 | 0.01 | 0.00 |
| process last non-idle time | 3,717 | 1.03 | 0.59 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 8,464,697 | 2,338.40 | 1,353.49 |
| recursive cpu usage | 37,563 | 10.38 | 6.01 |
| redo KB read | 92,508 | 25.56 | 14.79 |
| redo KB read (memory) | 36,572 | 10.10 | 5.85 |
| redo KB read (memory) for transport | 36,572 | 10.10 | 5.85 |
| redo KB read for transport | 36,574 | 10.10 | 5.85 |
| redo blocks checksummed by FG (exclusive) | 8,980 | 2.48 | 1.44 |
| redo blocks written | 79,762 | 22.03 | 12.75 |
| redo buffer allocation retries | 3 | 0.00 | 0.00 |
| redo entries | 85,982 | 23.75 | 13.75 |
| redo log space requests | 3 | 0.00 | 0.00 |
| redo log space wait time | 25 | 0.01 | 0.00 |
| redo ordering marks | 3,161 | 0.87 | 0.51 |
| redo size | 32,568,072 | 8,997.02 | 5,207.56 |
| redo size for direct writes | 370,260 | 102.29 | 59.20 |
| redo subscn max counts | 4,318 | 1.19 | 0.69 |
| redo synch long waits | 142 | 0.04 | 0.02 |
| redo synch poll writes | 0 | 0.00 | 0.00 |
| redo synch polls | 0 | 0.00 | 0.00 |
| redo synch time | 65,357 | 18.06 | 10.45 |
| redo synch time (usec) | 656,271,315 | 181,296.73 | 104,936.25 |
| redo synch writes | 29,117 | 8.04 | 4.66 |
| redo wastage | 7,297,104 | 2,015.84 | 1,166.79 |
| redo write time | 35,545 | 9.82 | 5.68 |
| redo writes | 32,171 | 8.89 | 5.14 |
| remote Oradebug requests | 0 | 0.00 | 0.00 |
| rollback changes - undo records applied | 66 | 0.02 | 0.01 |
| rollbacks only - consistent read gets | 181 | 0.05 | 0.03 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 604,611 | 167.03 | 96.68 |
| scheduler wait time | 0 | 0.00 | 0.00 |
| securefile direct read bytes | 0 | 0.00 | 0.00 |
| securefile direct read ops | 0 | 0.00 | 0.00 |
| session connect time | 1,837 | 0.51 | 0.29 |
| session cursor cache hits | 702,033 | 193.94 | 112.25 |
| session logical reads | 105,579,018 | 29,166.49 | 16,881.84 |
| shared hash latch upgrades - no wait | 43,645 | 12.06 | 6.98 |
| shared hash latch upgrades - wait | 6 | 0.00 | 0.00 |
| shared io pool buffer get success | 0 | 0.00 | 0.00 |
| sorts (memory) | 1,967,652 | 543.57 | 314.62 |
| sorts (rows) | 17,223,106,658 | 4,757,929.88 | 2,753,934.55 |
| sql area evicted | 151 | 0.04 | 0.02 |
| sql area purged | 0 | 0.00 | 0.00 |
| summed dirty queue length | 1 | 0.00 | 0.00 |
| switch current to new buffer | 1,017 | 0.28 | 0.16 |
| table fetch by rowid | 5,596,823 | 1,546.14 | 894.92 |
| table fetch continued row | 128,635 | 35.54 | 20.57 |
| table scan blocks gotten | 93,814,067 | 25,916.39 | 15,000.65 |
| table scan rows gotten | 3,134,939,974 | 866,035.66 | 501,269.58 |
| table scans (direct read) | 12 | 0.00 | 0.00 |
| table scans (long tables) | 12 | 0.00 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 211,250 | 58.36 | 33.78 |
| temp space allocated (bytes) | 0 | 0.00 | 0.00 |
| total cf enq hold time | 23,170 | 6.40 | 3.70 |
| total number of cf enq holders | 119 | 0.03 | 0.02 |
| total number of times SMON posted | 6 | 0.00 | 0.00 |
| transaction rollbacks | 2,840 | 0.78 | 0.45 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| undo change vector size | 7,857,192 | 2,170.57 | 1,256.35 |
| user I/O wait time | 7,460 | 2.06 | 1.19 |
| user calls | 110,976 | 30.66 | 17.74 |
| user commits | 4,586 | 1.27 | 0.73 |
| user rollbacks | 1,668 | 0.46 | 0.27 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 1,311,451 | 362.29 | 209.70 |
| write clones created in background | 0 | 0.00 | 0.00 |
| write clones created in foreground | 24 | 0.01 | 0.00 |