Create PLAN_TABLE for Query Plans

Setting up PLAN_TABLE involves logging in to SQL*Plus as SYSTEM and running the following script:
$ORACLE_HOME/rdbms/admin/utlxplan.sql.

This can optionally be followed by two more steps to make the plan table available to all (figure 1.0):

  CREATE PUBLIC SYNONYM plan_table FOR plan_table;
  GRANT ALL ON plan_table TO PUBLIC;

This approach creates a single plan table and gives everyone access to it. An alternative approach is to create individual plan tables for each candidate user account. The choice is open.