Re: Question about block dump

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 3 Mar 2004 16:05:28 -0000
Message-ID: <002401c40139$58f56f60$6702a8c0@Primary>

Check dbms_stats.convert_raw_value.

I don't know when this set of procedures was introduced, but they can be used to
take a raw input (e.g. your c403135456)
and decode it into a variable of the correct type.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

March 2004 Hotsos Symposium - The Burden of Proof Dynamic Sampling - an investigation
March 2004 Charlotte OUG (www.cltoug.org) CBO Tutorial April 2004 Iceland
June 2004 UK - Optimising Oracle Seminar

Original Message ----- From: "Mark Moynahan" <Mark.Moynahan_at_apollogrp.edu> To: <oracle-l_at_freelists.org> Sent: Wednesday, March 03, 2004 3:31 PM Subject: Question about block dump

> When doing a block dump is there a way to determine the rowid you're
looking
> for? What if the first column in each row a primary key and has a number
> datatype. Could that first column be used to determine the row your
looking
> for? If so, how are number datatypes stored internally in Oracle?
>
> for instance, in the trace file the first column looks like this:
> col 0: [ 5] c4 03 13 54 56
>
> How would I convert this to the actual number in the primary key column?
>
> Thanks,

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 03 2004 - 10:02:20 CST