• Oracle 서버는 Commit 되지 않은 트랜잭션을 Rollback 시키기 위해, 데이터베이스의 복구 과정을 위해, 그리고 동시 사용자 환경에 필요한 읽기 일관성의 보장을 위해 롤백 정보 또는 Undo 정보를 관리합니다. 이러한 Undo 정보의 관리는 전통적으로 롤백 세그먼트에 의하여 이루어져 왔습니다. Oracle database는 자동화된 Undo 관리 기능을 제공함으로써 보다 향상된 Undo 관리를 가능하게 합니다.
  • Oracle Database 11g는 데이터베이스 스스로 UNDO SEGMENT를 관리합니다. 즉, DBA는 이 세그먼트에 대한 크기 산정과 튜닝을 수행할 필요가 없습니다. 단지, undo 테이블스페이스만을 생성하여 할당하면 데이터베이스는 UNDO 경합 현상, 일관성 문제해결 그리고 공간 활용도를 극대화 합니다.
  • 이 기능을 사용하면, UNDO_RETENTION PARAMETER를 설정하여 COMMIT 된 UNDO 정보를 데이터베이스에 일정기간동안 보존할 수 있습니다. 위 값을 적절하게 설정함으로써 시간이 오래 걸리는 Query가 성공적으로 종료되게끔 조치할 수 있습니다. 이러한 작업 시, V$UNDOSTAT이라는 뷰를 통해 모니터링 할 수 있습니다.

By haisins

오라클 DBA 박용석 입니다. haisins@gmail.com 으로 문의 주세요.

73 thoughts on “Automatic Undo Management”
  1. Everyone laughed attempting to imagine what sort of birthday party Mary and Joseph gave for Jesus when He was six.
    Larry wondered, ?I bet he appreciated the identical form of toys
    we like.

  2. Among the finest methods to reach the city centre is to get the n. 23 bus or line B.
    This overcrowded event gives nearly everything on the market.

  3. High quality was never the issue with making
    Eisenberg jewelry, the best plating and metals of the
    time went into the piece.

  4. What i don’t realize is in fact how you’re no longer really much
    more smartly-appreciated than you might be right now. You’re very intelligent.
    You know therefore significantly on the subject
    of this matter, made me personally imagine it from a lot
    of various angles. Its like women and men are not fascinated until it is something to
    do with Woman gaga! Your own stuffs great. All the time care for it up!

  5. Currently it seems like WordPress is the preferred blogging platform available right
    now. (from what I’ve read) Is that what you are using on your blog?

  6. Great post. I used to be checking constantly this weblog and
    I’m inspired! Extremely helpful info particularly the remaining section 🙂 I care for such information a lot.
    I was seeking this particular information for a long time.
    Thank you and best of luck.

  7. After going over a number of the blog posts on your site,
    I really like your way of blogging. I book marked
    it to my bookmark webpage list and will be checking back in the near future.
    Take a look at my web site as well and let me know how you feel.

  8. This post is actually a pleasant one it assists new the
    web users, who are wishing in favor of blogging.

  9. I would like to thank you for the efforts you have put in writing this web site. I’m hoping the same high-grade blog post from you in the upcoming as well. In fact your creative writing skills has inspired me to get my own site now. Actually the blogging is spreading its wings quickly. Your write up is a great example of it.

  10. This is a blog compiled by a father just as i am. Most wedding speeches I’ve
    seen, including ones I did as groom and best man, are under three no time at
    all. Turns out that this can be a big mistake.

  11. It’s awesome to go to see this web site and reading the
    views of all friends about this article, while I am also keen of getting knowledge.

  12. I think this is among the most vital information for me.

    And i am satisfied studying your article. However should observation on some general things, The site style is
    perfect, the articles is actually excellent :
    D. Just right job, cheers

  13. Hey! This is my first visit to your blog! We are a team of volunteers and starting a new initiative
    in a community in the same niche. Your blog provided us beneficial information to work on. You have done a outstanding
    job!

  14. I wanted to thank you for this very good read!! I absolutely loved every bit of it.
    I’ve got you book marked to check out new things you
    post…

  15. Hi there, all is going fine here and ofcourse every one is sharing facts, that’s truly fine, keep up writing.

  16. Here is the hub for some easy methods to make from Tsu social networking.
    This really is my very own review.

  17. It’s time to change your life and hair routine to take one of the best out of your strands.
    Jewelry could trigger dermatitis.

  18. Frequent jewelry items comparable to, earrings are a form of body modification, as
    they are accommodated by creating a small hole in the ear.

  19. Thanks for any other informative site. Where else may just I get that type of information written in such an ideal method?
    I’ve a challenge that I’m just now working on, and I have been on the look out for such info.

  20. Why is it the shampoo bottle is upright, yet the conditioner container is ugly?
    on Bing. Plus my very own individual websites are As a student
    in high school, your alternatives for earnings are extremely
    restricted – particularly if you can not drive yet.

  21. An impressive share! I’ve just forwarded this onto a co-worker who had been conducting
    a little research on this. And he in fact bought me dinner due to the fact that
    I found it for him… lol. So let me reword this….
    Thanks for the meal!! But yeah, thanks for spending the time to talk about this
    matter here on your internet site.

  22. Hello i am kavin, its my frst tiime to commenting anyplace,
    when i read this article i thought i could also make comment due to this gopd
    post.

  23. These can probably be transformed to money, however cannot be used to
    pay suppliers, rent, or workers.

  24. Woah! I’m really loving the template/theme of this website.

    It’s simple, yet effective. A lot of times it’s challenging to get that “perfect balance” between usability and visual appearance.
    I must say that you’ve done a very good job with this. In addition, the
    blog loads very fast for me on Opera. Outstanding Blog!

  25. Right now it looks like Expression Engine is the best blogging platform available right now.
    (from what I’ve read) Is that what you’re using on your blog?

  26. All of these are encouraging steps in stopping the issue. But the tradition of financial exploitation of the poor
    has been versatile over time because the vary
    of subprime mortgages, payday lending and other monetary weapons
    targeting low-earnings households have shown. Targeting the worst offenders who violate the legislation is barely a part
    of the problem. So long as firms have so much knowledge about debtors, their desperation and their probability
    to just accept dangerous monetary phrases, we can count on the rising inequality described
    between the two Kansas Metropolis parishes in Pitch’s story to continue.

  27. Very great post. I simply stumbled upon your blog and wished to mention that
    I have truly enjoyed surfing around your blog posts.

    In any case I’ll be subscribing to your rss feed and I am hoping you write once more
    soon!

  28. Rapidly overview the rates of interest of a number of lenders providing 60 Day Loans to pick out probably the most most
    popular vendor as per your enterprise needs and pocket.

  29. I’m not sure why but this website is loading extremely slow
    for me. Is anyone else having this probllem or iss
    it a issue on my end? I’ll check back later and see if the problem still exists.

  30. Fasscinating blog! Is your theme custom made or did you download it from somewhere?
    A desiugn like yours with a few simple tweeks would really make my blog stajd out.
    Please let me knokw where you got your design. Thaznk you

  31. In my Managerial Economics class this time period we studied strategic interaction in great element.
    We noticed how one participant’s actions can have an effect on others’ payoffs and the way players can acquire
    benefit by means of being first movers and making credible commitments.

  32. I visited multiple web pages but the audio feature for audio songs present at this website is actually wonderful.

  33. Unquestionably believe that which you said. Your favorite reason seemed tto be
    on the net thee simplest ting to be aware of. I say to you, I definitely get annoyed wwhile people consider worriees that they plainly do not know about.
    You managed to hit the nail upon the ttop and defined out the whole thing without having side effect , people can take a signal.
    Will probably be back to get more. Thanks

  34. Hi there mates, its geat paragraph concerning teachingand
    fully explained, keep it up all the time.

  35. Maay I just sayy what a relief to unhover someone that actually knows what they’re talking
    about on the web. You certfainly know how to bring a problem to light and make it important.

    A lot more people need to look at this and understand this side of thee
    story. I was surprised that you’re noot more popular since you surely possess the gift.

  36. I was suggested this web site by my cousin. I am not
    sure whether this post is written by him as no one else know such detailed about my trouble.
    You are wonderful! Thanks!

  37. Why viewers still make use of to read news papers when in this technological globe the whole thing is presented on net?

  38. Nice blog here! Also your web site loads up fast!

    What web host are you using? Can I get your affiliate link to
    your host? I wish my site loaded up as quickly as yours lol

  39. I loved as much as you will receive carried out right here.

    The sketch is tasteful, your authored subject matter stylish.
    nonetheless, you command get bought an shakiness over that you wish be delivering the following.
    unwell unquestionably come more formerly again since exactly the same nearly very
    often inside case you shield this hike.

  40. I seriously love your blog.. Very nice colors & theme.

    Diid you mae this web site yourself? Please reploy back as I’m
    trying to create my very own site and would like to fiind out where you
    got this from or just what the theme is named. Kudos!

  41. Excellent post. I was checking continuously this blog and I’m impressed!
    Very useful information particularly the last part 🙂 I care for such info much.
    I was seeking this certain info for a long time. Thank you and
    good luck.

  42. Hiya! I know this is kinda off topic nevertheless I’d figured I’d ask.

    Would you be interested in trading links or maybe guest authoring
    a blog post or vice-versa? My website discusses a lot
    of the same subjects as yours and I believe we could greatly benefit from each other.
    If you happen to be interested feel free to send me an email.
    I look forward to hearing from you! Fantastic blog by the way!

  43. Great weblog here! Additionally your site a lot up very fast!
    What host are you the usage of? Can I get your associate hyperlink on your host?
    I desire my site loaded up as fast as yours lol

  44. Useful information. Fortunate me I discovered your
    web site by accident, and I am surprised why
    this accident did not came about earlier! I bookmarked it.

  45. Today, I went to the beachfront with my children. I found a sea shell and
    gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.”
    She put the shell to her ear and screamed.
    There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  46. Its like you read my mind! You seem to know so much about this, like you
    wrote the book in it or something. I think that you can do
    with some pics to drive the message home a little bit, but other than that, this is excellent blog.
    A fantastic read. I’ll definitely be back.

  47. Wow, superb blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your website is great,
    as well as the content!

Comments are closed.