Re: Question about block dump
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 16:05:28 -0000
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
