Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
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.
-
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)