Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Duplicated selects by iBot delivering direct SQL analyses
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
Answers
-
Hi Michal,
do you have a condition on the reports to prevent them being sent when no rows returned?
0 -
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)
0 -
Any logic on the connection pool that could cause this?
0 -
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.
0 -
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?
0