Oracle dbms_crypto.hash performance for SHA-1
1 answer
There are no statistics as far as I know, but as Gandalf suggested in a comment to your question, you can check it yourself. To get statistics, I would recommend using the DBMS_PROFILER package, which multiplies PLSQL rows by a nanosecond.
A quick primer on DBMS_PROFILER, cut from Steven Feuerstein's Oracle PL / SQL programming (posted by O'Reilly):
Install scripts (for your DBA): $ ORACLE_HOME / rdbms / admin / profload.sql
Install scripts (for your schema to capture statistics): $ ORACLE_HOME / rdmbs / admin / proftab.sql
reporting scripts (for your schema): $ ORACLE_HOME / plsql / demo / profrep.sql $ ORACLE_HOME / PLSQL / demo / profsum.sql
in profile:
Begin
DBMS_OUTPUT.PUT_LINE(DBMS_PROFILER.START_PROFILER('tag value for your run'));
your_procedure_to_test();
DBMS_OUTPUT.PUT_LINE(DBMS_PROFILER.STOP_PROFILER());
END;
to get reports, run one of the queries in the report scripts.
+2
a source to share