I am doing IDM for a year. I am using the Triggered JDBC driver and it
is really slow now processing events from the event log. A DBA said the
JDBC query is not very good, even though it is indexed. We have about
10million records in the event log they wish to keep for auditing as
well.

The JDBC query is this:
PT:SELECT * FROM ( SELECT * FROM xxxx.ID_EVENTLOG WHERE STATUS = 'N'
ORDER BY PK_RECORD_ID ASC) WHERE ROWNUM <= 10000 ORDER BY PK_RECORD_ID
ASC

the DBA said it would be much faster is changed to this:
select * from xxx.ID_EVENTLOG where status=N and rownum<=10000 order
by 1 asc;

There does not appear to be anyway to change it? Is the solution just to
keep the event log cleaned out? Right now I have about 2 million "N"
waiting to process, and about 18 million "S" sitting around. We just did
a huge dump of info about 4 days ago. The event trace on JDBC I see the
query waiting for about 8 minutes, then it processes the 10,000 changes
very quickly, but than has to query again.


--
ritap2015
------------------------------------------------------------------------
ritap2015's Profile: https://forums.netiq.com/member.php?userid=10296
View this thread: https://forums.netiq.com/showthread.php?t=54111