Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL Net Tracing

user6287828
Rank 2 - Community Beginner
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
0
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