oracle 存储过程优化

[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;