Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hi Community, by any chance can we check physical query in oracle dv in any version ?

Accepted answer
31
Views
3
Comments
User_EW1DP
User_EW1DP Rank 1 - Community Starter
edited Jun 18, 2025 7:07AM in Oracle Analytics Forum

Best Answer

Answers

  • SivaB -Oracle
    SivaB -Oracle Rank 4 - Community Specialist

    Thanks for using Oracle Community.

    To view the physical query, you need to enable "Developer Options" in your user profile and then access the "Performance Tools" section within a DV workbook. 

    Under "Performance Tools," you'll find "Execution Log (Physical Query)". This section displays the actual SQL query executed against the database

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist

    Thanks for sharing @RanaAshutosh-Oracle & @SivaB -Oracle!

    It'll be very useful formation.