From oracle-l-bounce@freelists.org Wed Mar 3 10:02:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23G2KN10039 for ; Wed, 3 Mar 2004 10:02:20 -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 i23G2Jo10033 for ; Wed, 3 Mar 2004 10:02:19 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1A49139509C; Wed, 3 Mar 2004 11:02:44 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 11:01:39 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from carbon.btinternet.com (carbon.btinternet.com [194.73.73.92]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EBB83394F8B for ; Wed, 3 Mar 2004 11:01:34 -0500 (EST) Received: from [81.133.96.209] (helo=Primary) by carbon.btinternet.com with smtp (Exim 3.22 #23) id 1AyYsA-000733-00 for oracle-l@freelists.org; Wed, 03 Mar 2004 16:05:26 +0000 Message-ID: <002401c40139$58f56f60$6702a8c0@Primary> From: "Jonathan Lewis" To: References: <73BB49215339D743903095833FFE4B17DA4DB8@apophxex4.apollogrp.edu> Subject: Re: Question about block dump Date: Wed, 3 Mar 2004 16:05:28 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-archive-position: 174 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jonathan@jlcomp.demon.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l 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 -----------------------------------------------------------------