Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    45

    Unanswered: Figuring out the new row id

    Hi,folks, I'm currently using Oracle 11g at Linux, and I want to monitor the blocks used when row migration happens. WHen row migration happens, the old block will store a pointer that leads to the new block that stored the updated data,right ?

    I want to know how to show the address pointed by the pointer. I just want to know which block contains what data. Is it possible ??? Oh yeah, also, the extent number if possible, since when I perform a test, the used blocks doubles from 6 to 12 and the extents used changed from 1 to 2.

    Cause I've been using dbms_rowid package and it only showed me the old address only.

    Is there any query that could show such data ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Are you afflicted with Compulsive Tuning Disorder?

    http://asktom.oracle.com & do keyword search on "chained rows"
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2008
    Posts
    45
    Lol, you could probably say that, but finally I decided to go and read the new row id at the dump file, since I couldn't find any table that could show it T_T

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •