Duplicated selects by iBot delivering direct SQL analyses

Question

Hello guys,

our client is using iBot delivery to export db tables (we know it is wrong idea, but client demands it).

The iBots are delivering analyses and dashboards based on direct SQL. When we check V$sql_monitor, we see that session is opened, executing select. After some random time, the SQL statement is done with  status DONE (FIRST N ROWS). At the same moment, another select is executed, with the same SQL_ID, same SQL hash and is being executed until result DONE(ALL_ROWS). At this moment iBot had finished.

Any idea, why the select is being always terminated and executed once more time?

thanks for help

Michal

Robert Angel · Answer

And you have nothing like row level security on these tables?

Does looking at 'complex_view_on_db' give you any clue as to its purpose?

3568844 · Answer

Nope, in connection pool's 'Connection Scripts' tab is nothing enabled. It is strange that the SQLs in those 2 sessions are exactly same.

The query always looks like "select * from complex_view_on_db". Database is huge, but optimized by partitions. Queries are running for tens of minutes.

Robert Angel · Answer

Any logic on the connection pool that could cause this?