From oracle-l-bounce@freelists.org Wed Mar 3 10:49:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23Gn2U21253 for ; Wed, 3 Mar 2004 10:49:02 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23Gn1o21246 for ; Wed, 3 Mar 2004 10:49:01 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23FD4394BA0; Wed, 3 Mar 2004 11:48:14 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 11:47:05 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from ob1.apollogrp.edu (whirlaway.uophx.edu [204.17.16.253]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 52AFA3949F4 for ; Wed, 3 Mar 2004 11:46:56 -0500 (EST) Received: by ob1.apollogrp.edu with Internet Mail Service (5.5.2657.72) id ; Wed, 3 Mar 2004 09:49:14 -0700 Message-ID: <73BB49215339D743903095833FFE4B17DA4DBA@apophxex4.apollogrp.edu> From: Mark Moynahan To: "'oracle-l@freelists.org'" Subject: RE: Question about block dump Date: Wed, 3 Mar 2004 09:48:58 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-Type: text/plain; charset="ISO-8859-1" X-archive-position: 189 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Mark.Moynahan@apollogrp.edu Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Mark Moynahan Sent: Wednesday, March 03, 2004 9:37 AM To: 'oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Jonathan Lewis Sent: Wednesday, March 03, 2004 9:05 AM To: oracle-l@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 ----- Original Message ----- From: "Mark Moynahan" To: 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@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@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@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 -----------------------------------------------------------------