When setting the archive.log.hours to a value greater than 0, an additional predicate is appended to the query, leading to a poorly formatted SQL query.

While this does not cause a SQL failure, the poorly formatted SQL could eventually lead to a SQL failure if Oracle imposes a stricter parser implementation.

Poorly formatted:

AND STATUS='A'AND FIRST_TIME >= SYSDATE - (1/24)

Correctly formatted:

AND STATUS='A' AND FIRST_TIME >= SYSDATE - (1/24)