We are using Oracle Analytics Cloud. I have admin role. But i can not see physical sql in session log. I can see logical SQL and query run stats etc.
I checked sesion log - it more or less look like below.
-------------------- SQL Request, logical request hash: cse759a5 SET VARIABLE QUERY_SRC_CD='Report'... SELECT saw_0, saw_1, saw_2, saw_3, <> ------ General Query Info: [[]] Query Status: Successful Completion Rows 47052, bytes 1163125440 retrieved from database query id: <<145>>, physical request hash dadb8a Physical query response: Total time 36.572 (seconds), Fetch time 4.417 (seconds), Execute time 32.153 (seconds), id Physical Query Summary Stats: Number of physical queries 1, Cumulative time 36.572, DB-connect time 0.000 (seconds) Rows returned to Client 47052 Logical Query Summary Stats: Elapsed time 93.484, Total time in BI Server 89.400, Execution time 88.569, Response time 109.939, Compilation time 52.191 (seconds), logical request hash 640...
- Num of Result Cache Hit:0, Num of XSA Cache Hit:0.
- Deferred init block execution time for logical request hash e6c759a5 : 0.000 (seconds)
Session log doesnt have any physical SQL which is i am interested. Target DB - Oracle DB
If you enable Developer Options in OAC, from a Workbook you can click the Workbook Menu (three-dots in right-hand corner of workbook) and select "Developer". Among other features, this will allow you to view the Logical SQL and Queries generated by your report.
If this is not sufficient, Usage Tracking in OAC can be set-up to analyze queries in greater detail (i.e. which queries may be creating performance bottlenecks).