BPM TaskQueryService is taking more than 1 minute
Hello Team,
I am using Oracle BPM 12.2.1.4 Version.
BPM TaskQueryService is taking more than 1 minute to execute . Below is the execution TRACE:32 logs
[2022-03-15T12:57:55.494-06:00] [bpm_server1] [TRACE] [] [oracle.soa.services.workflow.performance] [tid: [ACTIVE].ExecuteThread: '31' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <anonymous>] [ecid: 0000NyEvx8yFw000jzwkno1Y48dI0001wx,0:1:4] [APP: soa-infra] [partition-name: DOMAIN] [tenant-name: GLOBAL] [J2EE_APP.name: soa-infra] [J2EE_MODULE.name: integration/services/TaskQueryService] [WEBSERVICE.name: TaskQueryService] [WEBSERVICE_PORT.name: TaskQueryServicePort] [oracle.soa.tracking.FlowId: 10790428] [oracle.soa.tracking.InstanceId: 90220765] [oracle.soa.tracking.SCAEntityId: 190013] [FlowId: 0000NyEvx4Y6yGm5or1FiY1Y1l3D0006Gc] [SRC_CLASS: oracle.bpel.services.common.ServicesLogger] [SRC_METHOD: __log] <.> WFPERF: TaskQueryService.queryAggregatedTasks - 116232 ms[12:55:59:262-12:57:55:494] - bbb9ade4-e73f-414f-aaeb-ae9f4ad2f4f5 - [[