Oracle dbms_crypto.hash performance for SHA-1

Look for statistics for input sizes of at least 4-30 MB.

0


a source to share


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







All Articles