SQL Navigator provides useful tools for tuning and database management. These tools are intended to be used in conjunction with each other.
|Analyze Tool||View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes.|
|Explain Plan Tool||Analyze the execution of a single SQL statement. By examining the execution plan, you can see exactly how Oracle executes your SQL statement, and how it can be improved.|
|ER Diagram||Model a table and graphically see the dependencies and joins to other tables.|
|Code Road Map||Display the complex PL/SQL inter-dependencies within a database.|
|Integration with Benchmark Factory||Benchmark Factory® is a highly scalable load testing, capacity planning and performance tuning tool capable of simulating thousands of users accessing your database, file, Internet and messaging servers.|