Explain Plan

Oracle Explain Plan – Performance Tuning 1. Creating a Plan Table The first thing you will need to do is make sure you have a table called PLAN_TABLE available in your schema. The following script will create it for you if you don’t already have it: export ORACLE_SID=PrimeDG sqlplus / as sysdba @?/rdbms/admin/utlxplan.sql   2. […]