Categories
- All Categories
- Oracle Analytics Learning Hub
- 31 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 250 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 93 Oracle Analytics Trainings
- 16 Oracle Analytics and AI 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