This is for OBIEE 11g (11.1.1.7.150120) and Oracle DB is 11.2.0.3. The query log shows the below messages. Physical query response time 323 (seconds) Physical Query Summary Stats: Number of physical queries 1, Cumulative time 323, DB-connect time 0 (seconds)

Hi Joel, Yes, as I mentioned earlier, I took the physical query from the log file and executed in DB directly. There is no performance issue with the query at all. Thanks, Vedavyas