Use Database Time instead of Host Time for top-query collection window

[sv-splunk]

Component(s)

receiver/oracledb

Describe the issue you're reporting

Currently in top-query collection, the time from host is passed into the query parameter as a reference to calculate the collection window.

This logic does not work when the clocks of collector instance and the database are in different timezones, and it leads to an inaccurate collection window.

WHERE clause in current implementation:

WHERE LAST_ACTIVE_TIME >= TO_DATE(:1, 'yyyy-mm-dd hh24:mi:ss') - NUMTODSINTERVAL(:2, 'SECOND')

Proposed fix:

WHERE LAST_ACTIVE_TIME >= SYSDATE - NUMTODSINTERVAL(:1, 'SECOND')

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners:

• receiver/oracledb: @dmitryax @crobert-1 @atoulme

See Adding Labels via Comments if you do not have permissions to add labels yourself.

[paulojmdias]

Removing needs-triage since a PR was already opened

[paulojmdias]

/label -needs-triage