Duplicated selects by iBot delivering direct SQL analyses

3568844

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

Hi Michal,

do you have a condition on the reports to prevent them being sent when no rows returned?

3568844

Hi Robert, that is a good point. All those agents are scheduled to be run once a day without any condition.

Do not use a condition (always deliver content and run actions)

Robert Angel

Any logic on the connection pool that could cause this?

3568844

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

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?