Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question about block dump
Answered my own question. The dbms_rowid.rowid_row_nmber procedure does
point you to the row number in the block. I should have tested this before
posting, my bad.
Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mark Moynahan
Sent: Wednesday, March 03, 2004 9:37 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Question about block dump
Thank you pointing me to the dbms_stats.convert_raw_value procedure. This works perfectly!
After the original post, I reviewed the dbms_rowid documentation and came across the rowid_row_number procedure. Would the dbms_rowid.rowid_row_number procedure return the row number in relation to the block? I suspect that is the case but not 100% sure.
Cheers!
Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jonathan Lewis
Sent: Wednesday, March 03, 2004 9:05 AM
To: oracle-l_at_freelists.org
Subject: Re: Question about block dump
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
> 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,
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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:49:02 CST