Home » SQL Developer
Category Archives: SQL Developer
Autotrace in SQL Developer
This is a step up over the SQL*Plus version. It displays the stats for every step of the plan. So for each operation you can see metrics such as:
- How many buffer gets it used
- How long it took to run
- How many disk reads and writes it did
For more information, please check the below.
Thanks to Oracle – https://blogs.oracle.com/sql/entry/how_to_create_an_execution
The below url is very useful if you want to migrate/move the schema/object to another database.
Thanks to Oracle Magazine