Home » RDBMS Server » Server Administration » rowid issue of dumptree (10.2.0.1)
rowid issue of dumptree [message #557888] Sun, 17 June 2012 02:24 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
I dump a index tree and get the flowing infomation,and i want to transform the rowid to the ROWID of a row,how can i do?

alter session set events 'immediate trace name treedump level 70339';--index object
alter system dump datafile 4 block 251; -- index tree block

row#0[8010] flag: ------, lock: 2, len=13
col 0; len 2; (2): c1 03
col 1; NULL
col 2; len 6; (6): 01 00 00 f7 00 01 --rowid
row#1[8023] flag: ------, lock: 2, len=13
col 0; NULL
col 1; len 2; (2): c1 02
col 2; len 6; (6): 01 00 00 f7 00 00 -- rowid
----- end of leaf block dump -----
Re: rowid issue of dumptree [message #557890 is a reply to message #557888] Sun, 17 June 2012 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the purpose of this?
Why don't you investigate the MOST important things in Oracle, the concepts?
Don't you know that Tom Kyte has NEVER used dump or oradebug?
You are wasting your time with such stuff when you don't know the basics.

Regards
Michel
Re: rowid issue of dumptree [message #557892 is a reply to message #557890] Sun, 17 June 2012 03:07 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Michel, the issue has solved, Thank you! i want to learn the kernel of index store.
Re: rowid issue of dumptree [message #557908 is a reply to message #557892] Sun, 17 June 2012 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which issue? Please post the solution, don't just say it is solved, you found help, help others.
If you want to know about kernel, first read and read again and again Database Concepts.
Once you'll master what is inside this book then you can dump the blocks, before it is strictly and completly useless (but I bet once you'll master this book you'll know it is useless to dump the blocks).

Regards
Michel
Re: rowid issue of dumptree [message #557929 is a reply to message #557908] Mon, 18 June 2012 00:43 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
Michel,the issue is that i want to get the rowid of the row by the treedump, just as col 2; len 6; (6): 01 00 00 f7 00 01? what is the best way?
Re: rowid issue of dumptree [message #557931 is a reply to message #557929] Mon, 18 June 2012 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You said your issue is solved, so post the solution.

Regards
Michel
Re: rowid issue of dumptree [message #557938 is a reply to message #557931] Mon, 18 June 2012 02:09 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Michel,01 00 00 f7 00 01 transform to binary is 00000001 00000000 00000000 11110111 00000000 00000001
the file# is 00000001 00,decimal is 4
block# is 000000 00000000 11110111,decimal is 247
row# is 0000001,decimal is 1

but there is no object# of rowid,so we need to get the object_id of the table.
SQL> select object_id from dba_objects t
  2  where owner='HXL'
  3    and object_name='TB_INDEX_TEST';
 OBJECT_ID
----------
     70338


now get the rowid of the row
SQL> select
  2  dbms_rowid.rowid_create(rowid_type => 1,
  3                          object_number => 70338,
  4                          relative_fno => 4,
  5                          block_number => 247,
  6                          row_number => 1
  7                          ) rid
  8  from dual;
RID
------------------
AAARLCAAEAAAAD3AAB

SQL> select c1, c2 from hxl.TB_INDEX_TEST
  2  where rowid='AAARLCAAEAAAAD3AAB';
        C1         C2
---------- ----------
         2
Re: rowid issue of dumptree [message #558157 is a reply to message #557938] Tue, 19 June 2012 19:12 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
Michel, how about my test?
Re: rowid issue of dumptree [message #558164 is a reply to message #558157] Tue, 19 June 2012 23:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't care about your test, I'm not intersted in investigating useless stuff and wasting my time.
The first step is to know the concepts, you did not pass this step, knowing each bit Oracle stores is silly, do you think you are better than T. Kyte and know more than him?
Once you will have studied and mastered the concepts then maybe it will be of some interest to know more of the inside, before... but wait I already told this and you, you didn't answer the question "why do you want to know this?".

Regards
Michel
Previous Topic: changing time zone on solaris
Next Topic: database installation
Goto Forum:
  


Current Time: Thu Mar 28 18:24:23 CDT 2024