[oracle@localhost admin]$ sqlplus / as sysdba
SQL>@/home/oracle/product/10.2.0/db_1/rdbms/admin/profload.sql
SQL> desc dbms_profiler;
SQL> CREATE USER upcfj IDENTIFIED BY upcfj;
SQL> grant connect,resource to upcfj;
SQL> CREATE PUBLIC SYNONYM plsql_profiler_runs FOR upcfj.plsql_profiler_runs;
SQL> CREATE PUBLIC SYNONYM plsql_profiler_units FOR upcfj.plsql_profiler_units;
SQL> CREATE PUBLIC SYNONYM plsql_profiler_data FOR upcfj.plsql_profiler_data;
SQL> CREATE PUBLIC SYNONYM plsql_profiler_runnumber FOR upcfj.plsql_profiler_runnumber;
SQL> conn upcfj/upcfj
SQL> @/home/oracle/product/10.2.0/db_1/rdbms/admin/proftab.sql
SQL> GRANT SELECT ON plsql_profiler_runnumber TO PUBLIC;
SQL> GRANT SELECT,INSERT,UPDATE,DELETE ON plsql_profiler_data TO PUBLIC;
SQL> GRANT SELECT,INSERT,UPDATE,DELETE ON plsql_profiler_units TO PUBLIC;
SQL> GRANT SELECT,INSERT,UPDATE,DELETE ON plsql_profiler_runs TO PUBLIC;