AnsweredAssumed Answered

Oracle Index not working with CA SDM 12.9 AA

Question asked by arcanjo on Aug 30, 2017
Latest reply on Aug 31, 2017 by arcanjo

Hi guys,

I have a problem with my CA SDM 12.9 AA with Oracle 11g. It seems that SDM doesn't use the Oracle Indexes.

Eg.: 

STDLOG sample:

08/22 19:09:03.50 AS12K38BR sqlagt:select1415 12460 SIGNIFICANT orclclass.c 2169 A FETCH for the following statement took 77784 milliseconds: SELECT not_log.nlh_start, not_log.nlh_status, not_log.id FROM not_log WHERE not_log.cntxt_obj = N'cr:1689088' ORDER BY not_log.nlh_start DESC NULLS LAST

 

From Oracle developer, the same query return 0,016 seconds:

 

Can anyone saw that behavior?

 

Thanks,

 

Jorge Arcanjo de Souza

Outcomes