Getting Query Profiling Results

This topic explains how to obtain query profiling results using Query Profiler.

Open a query file and click the Query Profiling Mode button on the SQL toolbar to activate the Query Profiler tool.
Execute the query by clicking the Execute button or press F5. The Profiler document view opens. See the query profiling results displayed on three tabs - Plan, Session Statistics.
After you have made changes in the query, click the Get New Results button in the Profiler document view. New profiling results appear in the tree view as a new node with time and date of query execution. You can easily distinguish and navigate to them.

Note

When you save the query file after getting the query profiling results, the latter will be automatically stored in the .Design file.

Want to Find out More?

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.

If you consider employing the Studio for your business, request a demo to see it in action.

Ready to start using dbForge Studio for Oracle?