You can also check this video :
https://www.youtube.com/watch?v=kxwIB5qPMNw
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
Thanks for sharing @RanaAshutosh-Oracle & @SivaB -Oracle!
It'll be very useful formation.