Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ideas to use ora hash

Re: ideas to use ora hash

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Tue, 21 Mar 2006 12:05:43 -0400
Message-ID: <cd4305c10603210805i5dbce6ao7ddb0a8feae6ffec@mail.gmail.com>


On 3/21/06, Glenn Santa Cruz <glenn.santacruz_at_gmail.com> wrote:
> Not sure how you'd apply this to tuning, or to reduce storage space,
> but we used it to provide a pseudo-random ordering of rows for a
> particular application. The requirement was to provide a random list
> of entries from a table, but the list needed to be "page-able" (think
> of web site, displaying page 1 of 10, etc). We couldn't just order by
> dbms_random.random, since that would effectively break pagination; and
> we had to keep these in order for the particular web session.
> Solution? Concatenate the unique web session identifier with another
> unique column in the table and sort by the hashed value. Worked quite
> well.
>
> Glenn
>
> On 3/21/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:
> > Hi list
> > Does anyone has an interesting idea about how to use, specially for tuning,
> > ora_hash or DBMS_UTILITY.GET_HASH_VALUE, to get hash values.
> >
> > One is to encrypt, but I was asking about the possibility to use to
> > reduce storage space or to tune, does anyone can share some idea
> > and/or experience.
> >
> > Thank you :)
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>

--
Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 21 2006 - 10:05:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US