Aviso: Este artigo ainda é um rascunho!

Realizar o procedimento utilizando o usuário SYS do banco de dados

create table PLAN_TABLE ( statement_id varchar2(30), timestamp date, remarks varchar2(80), operation varchar2(30), options varchar2(30), object_node varchar2(128), object_owner varchar2(30), object_name varchar2(30), object_instance numeric, object_type varchar2(30), optimizer varchar2(255), search_columns number, id numeric, parent_id numeric, position numeric, cost numeric, cardinality numeric, bytes numeric, other_tag varchar2(255), partition_start varchar2(255), partition_stop varchar2(255), partition_id numeric, other long); create index i_plan_table on plan_table(id,parent_id); drop role plustrace; create role plustrace; grant select on v_$sesstat to plustrace; grant select on v_$statname to plustrace; grant select on v_$session to plustrace; grant plustrace to dba with admin option; CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table; GRANT INSERT, UPDATE, DELETE, SELECT ON sys.plan_table TO public;