Re: Unique index access path seems very slow

Understood the hex and raw thing now. Thank you so much.

On Fri, 27 Jan, 2023, 7:02 pm Jonathan Lewis, <jlewisoracle_at_gmail.com> wrote:

>
> Just one quick answer, I'll get back to the rest of the posting later
> today (I hope).
> For the storage of the raw vs. hex, the length() and lengthb() will
> implicitly convert to hex before calculating the length.
> For internal storage size try:
>
> SQL> select sys_op_opnsize(c1), sys_op_opnsize(c2) from t1_encrypt;
> SQL> select vsize(c1), vsize(c2) from t1_encrypt;
> SQL> select dump(c1,16), dump(c2,16) from t1_encrypt;
>
> The first two are the newer and older (respectively) calls used in
> gather_table_stats() to get internal column lengths
> The last is a way to dump the actual bytes store, in this case in base 16,
> reportung the column type and length at the start
>
> You'll see the 64 vs. 128 in all three.
>
> Regards
> Jonathan Lewis
>
>

--
http://www.freelists.org/webpage/oracle-l