Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2005
    Posts
    40

    Unanswered: Undo Segment In Aum

    How can u tell the size of a record that you may update, insert or delete?

    We have some sessions using large amounts of undo and we are not sure how large the records.

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    well, you wrote the code so you should know how many rows you are updating, etc. before commits.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Aug 2005
    Posts
    40
    Actually, we did not write the code. Our client wrote the code and loads it into our database. I was thinking that maybe there was a specific table I could query for a current transaction.

    I apologize for bothering everyone.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How can u tell the size of a record that you may update, insert or delete?
    Size of record is NOT necessarily relevant or meaningful?

    >We have some sessions using large amounts of undo and we are not sure how large the records.
    In general total amount of undo = number of transaction * size of data changed (NOT size of record) [see below]

    Not all UNDO is created equal.
    The undo of an INSERT is only DELETE from T_TABLE where ROWID = X.
    The undo of a DELETE is an INSERT with all the VALUES in that row!
    The undo of a DELETE typically consumes MUCH more UNDO space than an UNDO of an INSERT.

    Why are you fixated on the size/amount of UNDO being used?
    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.

Posting Permissions

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