DIS Import Performance

Description

Categories: Enginatics
Repository: Github

Query to review Discoverer to Blitz Report import performance, after running the 'Blitz Report Discoverer Import' concurrent program or mass migration script.
https://www.enginatics.com/user-guide/#Discoverer_Worksheet

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

select
x.*,
xxen_util.time(x.seconds) time
from
(
select
xrv.report_name,
regexp_substr(xrv.description,'Object IDs: (.+)',1,1,null,1) object_use_key,
xrv.category,
xxen_util.user_name(xrv.created_by) created_by,
xxen_util.client_time(xrv.creation_date) creation_date,
(xrv.creation_date-lag(xrv.creation_date) over (order by xrv.report_id))*86400 seconds
from
xxen_reports_v xrv
where
1=1
order by
xrv.report_id desc
) x

Parameter Name

SQL text

Validation

Report Creation Time From

xrv.creation_date>=:date_from

DateTime

Report Creation Time To

xrv.creation_date<=:date_to

DateTime

Category

xrv.report_id in (
select
xrca.report_id
from  
xxen_report_categories_v xrcv,
xxen_report_category_assigns xrca
where
xrcv.category=:category_name and
xrcv.category_id=xrca.category_id
)