Re: ideas to use ora hash

Comments inline:

On 3/22/06, Glenn Santa Cruz <glenn.santacruz@xxxxxxxxx> wrote:
>
> At first glance, I'd guess this is much more CPU intensive than the
> table comparison technique Tom Kyte pointed out at
> http://www.oracle.com/technology/oramag/oracle/05-jan/o15asktom.html


Undoubtedly so.  I've used that method a few times to compare table
comments.

The question was whether get_hash_value could be used to do that, so that
is what I did.  Which was much more fun than a boring, simple, fast SQL
statement.  ;)


Both techniques would full-scan the tables, but the HASH_VALUE would
> have plenty of SQL to PL/SQL context switches.  Of course, this is
> merely an opinion, and I'd certainly be interested in the results (may
> have to try this one on my own, later tonight.)
>
>
Hmmm.  Define 'context switch', as that is not occurring, at least in
the traditional sense of the term. (push registers onto stack, load
new process, reload old process when done)


Jared

Other related posts: