Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics & AI Challenge
- Find Partners
- For Partners
SQL Net Tracing
Hello.
I need to generate trace files to capture the query execution against database when OBIEE reports are executed from dashboards.
I have enabled SQL net tracing and when I try to connect to database from OBIEE server and execute some queries , I see that trace files are being generated.
But when I execute reports from dashboards , no trace files are being generated.
I am probably missing something. Can you please help guide how to ensure trace files are being generated for report queries executed from OBIEE dashboards.
Thanks
Answers
-
Maybe it is just going to the cache only and not hitting the DB. Try clearing/disabling the beforehand.
https://gerardnico.com/wiki/dat/obiee/obis/query_cache_purging
0