TX enqueue Mode 4的一点补充

在06年的一篇blog TX lock中简略的解释了下TX enqueue的类型和对应的例子。

最近在数据库维护中又有了一点新的发现。

前面文章中提到Mode=4的TX lock又分为下面三种情况

* ITL entry数目不够
* Unique key的约束
* Bitmap index entry

再补充几种情况:

* Index block spilt
* Foreign key enforcement
* Alter tablespace … read only;
* Free Lists slot waits
* Possible with two phase commit
* Extent allocation slow in DMT tablespace

前面几种情况一些文档中多多少少有所提及,index block split较为常见。

最后一种extent allocation slow是实际中遇到的。在DMT的tablespace中,当free extent很多,但不满足分配条件时就会出现extent分配慢的情况,实际中分配一个extent需要8,9秒钟。从而导致大量的session wait在TX-4 enqueue上。

目前还没有找到文档有关于这个的相关说明,也许是因为DMT已经退出历史舞台了吧。

91 Responses to “TX enqueue Mode 4的一点补充”

  1. Eagle Fan Says:

    再补充一点,对于IOT table,request type就是mod 4而不是mod 6

  2. robinma Says:

    很好,很强大

  3. purchase generic tramadol online Says:

    Do not use this medicine if you take selegiline capsules or tablets. ,

  4. Brigitte Says:

    I all the time used to read piece of writing
    in news papers but now as I am a user of net thus from now I am using net for articles
    or reviews, thanks to web.

  5. Discount codes Says:

    Today, taking into consideration the fast life style that everyone is having, credit cards get this amazing demand throughout the market. Persons from every field are using credit card and people who are not using the card have made up their minds to apply for one in particular. Thanks for expressing your ideas about credit cards.

  6. American eagle coupons Says:

    F*ckin’ tremendous things here. I am very happy to peer your post. Thanks a lot and i’m having a look forward to contact you. Will you kindly drop me a mail?

  7. Blake Froehle Says:

    hi!,I really like your writing very so much! percentage we communicate extra about your post on AOL? I need an expert in this house to unravel my problem. May be that’s you! Having a look forward to peer you.

  8. kwiaty Gdańsk Says:

    It is the best time to make a few plans for the long run and it is time to be happy. I’ve learn this publish and if I may just I want to counsel you few fascinating issues or suggestions. Perhaps you could write next articles referring to this article. I want to read even more issues approximately it!

  9. Suggested Web page Says:

    Its my fortune to visit at this website and find out my required post along with video demo, that’s YouTube video and its also in quality.

  10. Nathanial Kamler Says:

    I’ve been absent for a while, but now I remember why I used to love this web site. Thanks , I¡¦ll try and check back more frequently. How frequently you update your web site?

  11. Thyromine complaints Says:

    I am not really certain if greatest practices have emerged close to things like that, but I’m sure that your great job is clearly identified. I was wondering if you offer any subscription to your RSS feeds as I will be very fascinated and can?t find any link to subscribe right here.

  12. full kids bed frames Says:

    I really feel other web-site lovers might look into this valuable website as a model. Especially clean and user-friendly approach, along with extremely good subject material! You’re very skilled when it comes to this important niche :)

  13. Stephane Croan Says:

    Hi, Neat post. There’s a problem together with your website in internet explorer, would check this… IE still is the market chief and a big component to people will omit your great writing due to this problem.

  14. Chandler AZ Dentist Says:

    There’s noticeably a whole lot of dollars comprehend this. I assume you have produced particular good points in functions also.

  15. How to coach rugby Says:

    Hi! I’ve been reading your website to get a though now and lastly got the bravery to go ahead and provide you with a shout out from Kingwood Texas! Just wanted to mention retain up the wonderful job!

  16. vanuatu holidays Says:

    hey there and thank you for the info - I have absolutely picked up anything new from proper right here. I did on the other hand expertise a couple of technical difficulties using this site, as I knowledgeable to reload the web site a lot of instances previous to I could get it to load correctly. I had been asking yourself in case your net host is OK? Not that I’m complaining, but slow loading instances instances will occasionally impact your placement in google and could damage your high-quality score if marketing and marketing and advertising with Adwords. Properly I am adding this RSS to my e-mail and may look out for a great deal far more of the respective fascinating content material. Make sure that you just update this again soon..

  17. hair treatment loss Says:

    I do trust all the ideas you’ve offered in your post. They are very convincing and will certainly work. Nonetheless, the posts are very short for novices. May you please extend them a little from next time? Thanks for the post.|

  18. broker option binaire Says:

    You’re so interesting! I don’t believe I’ve truly read something like this before. So good to discover somebody with some unique thoughts on this issue. Seriously.. thanks for starting this up. This site is something that is needed on the web, someone with a little originality!

  19. viagra Says:

    Websites we think you should visit… […]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[…]……

  20. site Says:

    Very efficiently written story. It will be beneficial to anybody who employess it, as well as yours truly :) . Keep up the good work - looking forward to more posts.

  21. FSBO Says:

    You may have some actual insight. Why not hold some kind of contest for your readers?

  22. strony internetowe tanie Says:

    It’s truly a nice and helpful piece of information. I am happy that you simply shared this helpful information with us. Please stay us informed like this. Thanks for sharing.

  23. Jurata kwatery Says:

    I enjoy your piece of work, regards for all the good blog posts.

  24. Arletha Bloczynski Says:

    Hello, Neat post. There’s an issue with your site in internet explorer, could test this… IE still is the marketplace chief and a big component to folks will miss your magnificent writing due to this problem.

  25. Nicky Marklund Says:

    According to my observation, after a foreclosed home is available at a sale, it is common to the borrower in order to still have any remaining balance on the financial loan. There are many loan companies who attempt to have all expenses and liens repaid by the upcoming buyer. On the other hand, depending on a number of programs, rules, and state legal guidelines there may be many loans that are not easily fixed through the exchange of lending products. Therefore, the obligation still lies on the lender that has got his or her property in foreclosure process. Many thanks for sharing your ideas on this website.

  26. Shantel Sherrill Says:

    When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove people from that service? Appreciate it!

  27. Mason Stocco Says:

    Thanks for your article. I also think that laptop computers are becoming more and more popular right now, and now will often be the only kind of computer employed in a household. It is because at the same time that they’re becoming more and more economical, their computing power keeps growing to the point where they may be as potent as desktop through just a few years back.

  28. Cesar Buttolph Says:

    I will immediately grab your rss feed as I can not find your email subscription link or newsletter service. Do you have any? Kindly let me know so that I could subscribe. Thanks.

  29. Quintin Averyt Says:

    Things i have generally told people is that while searching for a good on-line electronics shop, there are a few variables that you have to consider. First and foremost, you should really make sure to look for a reputable along with reliable retail store that has received great opinions and rankings from other people and business sector people. This will make certain you are getting through with a well-known store providing you with good support and help to it’s patrons. Many thanks sharing your opinions on this blog.

  30. Read More on Naughty marital Affair Says:

    Hey very nice site!! Guy .. Beautiful .. Wonderful .. I’ll bookmark your web site and take the feeds also…I am happy to find numerous useful information here within the post, we need work out extra techniques in this regard, thanks for sharing.

  31. Quincy Revalee Says:

    Hmm it appears like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog writer but I’m still new to the whole thing. Do you have any points for rookie blog writers? I’d definitely appreciate it.

  32. Darrin Mcelwee Says:

    I’ve learn several good stuff here. Definitely worth bookmarking for revisiting. I wonder how so much effort you place to make such a great informative website.

  33. Fredrick Lestronge Says:

    I am not sure where you’re getting your information, but good topic. I needs to spend some time learning much more or understanding more. Thanks for excellent information I was looking for this information for my mission.

  34. Jeffry Dannelly Says:

    It’s laborious to find knowledgeable folks on this matter, however you sound like you recognize what you’re talking about! Thanks

  35. Erika Trautz Says:

    Thanks for your write-up. My partner and i have generally seen that many people are desirous to lose weight as they wish to show up slim and also attractive. On the other hand, they do not generally realize that there are other benefits for you to losing weight additionally. Doctors declare that fat people are afflicted with a variety of conditions that can be instantly attributed to their excess weight. Fortunately that people who definitely are overweight in addition to suffering from a variety of diseases can reduce the severity of their illnesses by means of losing weight. It is possible to see a progressive but marked improvement with health if even a negligible amount of fat reduction is realized.

  36. Lexie Girolamo Says:

    Hello my friend! I want to say that this post is awesome, nice written and include approximately all important infos. I’d like to see more posts like this.

  37. Auto relocation Says:

    My husband and i felt comfortable that Michael managed to finish off his research through your precious recommendations he was given in your blog. It’s not at all simplistic to simply continually be giving for free guidelines that other folks have been trying to sell. And now we fully understand we have you to appreciate for that. The illustrations you’ve made, the easy blog navigation, the relationships you will aid to instill - it is all superb, and it’s assisting our son and us consider that that situation is thrilling, which is seriously important. Thank you for the whole thing!

  38. best baby monitor Says:

    I’m commenting to let you understand what a fine discovery my wife’s girl gained reading through your web site. She came to understand some details, which include what it is like to have an incredible coaching style to make certain people really easily know several tricky topics. You undoubtedly surpassed my desires. Thanks for displaying such essential, safe, revealing and even fun tips on your topic to Gloria.

  39. 8772200050 Says:

    Hey there! This post could not be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this article to him. Pretty sure he will have a good read. Many thanks for sharing!

  40. hotel Polanica ZdrĂłj Says:

    Oh my goodness! a tremendous article dude. Thanks Nonetheless I’m experiencing problem with ur rss . Don’t know why Unable to subscribe to it. Is there anyone getting similar rss downside? Anybody who is aware of kindly respond. Thnkx

  41. More info on latest technology Says:

    I have been absent for some time, but now I remember why I used to love this website. Thank you, I¡¦ll try and check back more often. How frequently you update your site?

  42. More Information on Date cougars Says:

    Someone necessarily help to make significantly posts I’d state. This is the first time I frequented your website page and up to now? I surprised with the analysis you made to make this particular submit amazing. Fantastic task!

  43. VGA Cables Says:

    power tools can truly save you from loads of headache, specially when the job is pretty hard,

  44. Marital Affairs Do They Last Says:

    Wonderful beat ! I wish to apprentice while you amend your site, how could i subscribe for a blog web site? The account aided me a acceptable deal. I had been tiny bit acquainted of this your broadcast offered bright clear concept

  45. Is Midsummer Festival Wow Daily Quests Says:

    Of course, what a splendid website and enlightening posts, I surely will bookmark your blog.Best Regards!

  46. Know More on Arkansas Criminal Defense Lawyer Says:

    I do trust all the concepts you’ve introduced to your post. They’re really convincing and can certainly work. Still, the posts are very brief for newbies. May you please extend them a bit from subsequent time? Thanks for the post.

  47. online news Says:

    Needed to send you the tiny word to be able to thank you very much as before with the lovely concepts you have shown in this article. It’s so surprisingly open-handed of people like you to grant freely just what a number of us would have distributed as an e-book to make some profit for themselves, principally seeing that you could have tried it if you decided. Those suggestions in addition worked to be a fantastic way to be sure that the rest have a similar keenness like my very own to understand more and more in regard to this issue. Certainly there are millions of more enjoyable times in the future for people who find out your blog post.

  48. rippln rewards program Says:

    I precisely wanted to appreciate you once more. I’m not certain the things that I would’ve carried out without these tactics contributed by you relating to my theme. It seemed to be an absolute traumatic matter in my opinion, but noticing your professional manner you dealt with that forced me to leap for gladness. Now i am happy for your guidance and believe you recognize what an amazing job you happen to be putting in instructing others through a site. Probably you haven’t met all of us.

  49. Learn More on 1300 Numbers Says:

    I’ve recently started a site, the info you provide on this web site has helped me tremendously. Thank you for all of your time & work.

  50. travel italy Says:

    Hello there, You’ve done a great job. I’ll certainly digg it and personally recommend to my friends. I am confident they’ll be benefited from this site.

  51. online casino Says:

    F*ckin’ tremendous issues here. I’m very satisfied to peer your post. Thanks a lot and i am taking a look forward to contact you. Will you kindly drop me a mail?

  52. Shelba Torrano Says:

    Thanks for any other informative web site. Where else may I am getting that type of info written in such a perfect approach? I’ve a venture that I am simply now running on, and I have been on the look out for such info.

  53. Know More on wooden decking Says:

    I must point out my love for your generosity in support of men and women who must have help on your niche. Your real commitment to passing the solution all around became remarkably effective and has encouraged girls much like me to reach their endeavors. Your new important recommendations implies a whole lot to me and further more to my office colleagues. Many thanks; from everyone of us.

  54. www.abcronline.net Says:

    It’s a pity you don’t have a donate button! I’d definitely donate to this brilliant blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will share this website with my Facebook group. Talk soon!
    www.abcronline.net
    [url=http://www.abcronline.net/]www.abcronline.net[/url]

  55. コーチ-腕時計2013 Says:

    It’s a pity you don’t have a donate button! I’d definitely donate to this brilliant blog! I guess for now i’ll settle for bookmarking and adding your RSS feed to my Google account. I look forward to fresh updates and will talk about this site with my Facebook group. Talk soon!
    コーチ-腕時計2013

  56. Anonymous Says:

    you are my intake , I have few web logs and rarely run out from to brand : (.

  57. Houses For Sale In Maryland Says:

    I like the valuable information you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite certain I’ll learn many new stuff right here! Best of luck for the next!

  58. Click This Link Says:

    I do accept as true with all of the ideas you have offered for your post. They are very convincing and can certainly work. Still, the posts are too brief for novices. Could you please prolong them a little from next time? Thank you for the post.

  59. website Says:

    Good article and right to the point. I don’t know if this is really the best place to ask but do you folks have any thoughts on where to employ some professional writers? Thanks in advance :)

  60. Go Here Says:

    Good web site! I really love how it is simple on my eyes and the data are well written. I’m wondering how I could be notified when a new post has been made. I have subscribed to your feed which must do the trick! Have a nice day!

  61. visit Says:

    Good article and right to the point. I don’t know if this is really the best place to ask but do you folks have any thoughts on where to employ some professional writers? Thanks in advance :)

  62. Visit This Link Says:

    Hi there, I found your site via Google at the same time as looking for a similar subject, your site came up, it appears great. I have bookmarked it in my google bookmarks.

  63. Find Out More Says:

    My husband and i felt now lucky that Raymond could round up his research out of the ideas he came across using your web site. It’s not at all simplistic just to choose to be giving freely strategies people today may have been making money from. And we also figure out we’ve got you to be grateful to for that. All of the explanations you made, the easy web site menu, the relationships you help instill - it’s most sensational, and it’s really letting our son in addition to us believe that that situation is pleasurable, and that’s extremely important. Thanks for everything!

  64. Inverter heat pump Says:

    Wow, marvelous weblog layout! How lengthy have you been blogging for? you made blogging glance easy. The overall look of your website is fantastic, as well as the content!

  65. Discover More Here Says:

    I’m still learning from you, but I’m trying to reach my goals. I absolutely enjoy reading all that is posted on your blog.Keep the stories coming. I liked it!

  66. visit here Says:

    Howdy very cool site!! Man .. Excellent .. Wonderful .. I’ll bookmark your web site and take the feeds also¡KI am glad to search out numerous useful info here within the post, we want work out extra strategies on this regard, thanks for sharing. . . . . .

  67. Get More Info Says:

    Nice post. I was checking constantly this blog and I am impressed! Very useful info specifically the last part :) I care for such info a lot. I was looking for this particular info for a long time. Thank you and good luck.

  68. visit Says:

    I do accept as true with all of the ideas you have offered for your post. They are very convincing and can certainly work. Still, the posts are too brief for novices. Could you please prolong them a little from next time? Thank you for the post.

  69. posters from photos Says:

    Its like you read my mind! You appear to know a lot 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 bit, but instead of that, this is wonderful blog. A great read. I’ll definitely be back.

  70. more info Says:

    Hey, you used to write fantastic, but the last several posts have been kinda boring¡K I miss your tremendous writings. Past several posts are just a little out of track! come on!

  71. Trailer hub assembly Says:

    I would like to thnkx for the efforts you’ve put in writing this website. I’m hoping the same high-grade website post from you in the upcoming as well. Actually your creative writing abilities has encouraged me to get my own web site now. Really the blogging is spreading its wings quickly. Your write up is a great example of it.

  72. visit here Says:

    Heya i am for the first time here. I came across this board and I find It really useful

  73. Find Out More Says:

    I truly wanted to post a brief comment to be able to thank you for some of the lovely pointers you are sharing at this site. My incredibly long internet search has at the end of the day been honored with excellent facts and techniques to share with my good friends. I ‘d express that most of us site visitors are really lucky to exist in a wonderful site with so many special people with insightful tips and hints. I feel rather blessed to have come across your site and look forward to so many more entertaining moments reading here. Thanks a lot once more for all the details.

  74. Get More Info Says:

    I have been reading out many of your stories and i can state clever stuff. I will definitely bookmark your site.

  75. Discover More Says:

    Definitely, what a splendid blog and illuminating posts, I surely will bookmark your site.All the Best!

  76. Click This Link Says:

    Normally I do not learn post on blogs, however I wish to say that this write-up very forced me to take a look at and do so! Your writing style has been amazed me. Thanks, quite great article.

  77. Learn More Says:

    I just could not go away your site before suggesting that I actually enjoyed the standard info a person supply in your guests? Is going to be back continuously to investigate cross-check new posts

  78. Discover More Says:

    Thanks a bunch for sharing this with all folks you really understand what you’re speaking about! Bookmarked. Please also talk over with my web site =). We may have a link change arrangement between us!

  79. visit Says:

    Someone necessarily assist to make critically articles I would state. This is the very first time I frequented your website page and thus far? I amazed with the analysis you made to create this particular put up incredible. Great process!

  80. read more Says:

    Someone necessarily assist to make critically articles I would state. This is the very first time I frequented your website page and thus far? I amazed with the analysis you made to create this particular put up incredible. Great process!

  81. Visit This Link Says:

    magnificent issues altogether, you just received a logo new reader. What may you recommend about your put up that you simply made a few days ago? Any certain?

  82. Visit Website Says:

    I have been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the internet will be much more useful than ever before.

  83. esa telephone number Says:

    I think other site proprietors should take this website as an model, very clean and great user genial style and design, let alone the content. You’re an expert in this topic!

  84. eformula evolution Says:

    Hello.This post was extremely interesting, particularly because I was looking for thoughts on this topic last Thursday.

  85. Anadrol Pills Says:

    Great tremendous things here. I¡¦m very glad to look your article. Thank you so much and i am taking a look ahead to contact you. Will you please drop me a mail?

  86. Clicking Here Says:

    I want to express my appreciation to the writer just for bailing me out of this type of setting. After looking through the world wide web and getting views that were not beneficial, I assumed my entire life was well over. Existing without the presence of solutions to the difficulties you have solved all through your entire write-up is a crucial case, and ones that might have negatively damaged my entire career if I hadn’t come across your blog. Your own personal mastery and kindness in dealing with all areas was tremendous. I don’t know what I would’ve done if I had not discovered such a step like this. I can now look forward to my future. Thanks for your time very much for this reliable and results-oriented help. I will not hesitate to refer your web site to anyone who requires assistance about this issue.

  87. halifax helpline Says:

    Hi, Neat post. There is an issue with your website in web explorer, would test this¡K IE still is the market chief and a huge element of folks will pass over your great writing due to this problem.

  88. Discover More Here Says:

    magnificent issues altogether, you just received a logo new reader. What may you recommend about your put up that you simply made a few days ago? Any certain?

  89. Nike Free Pas Cher Says:

    Do you mind if I quote a few of your articles as long as I provide credit and sources back to your website? My blog site is in the exact same area of interest as yours and my visitors would truly benefit from some of the information you present here. Please let me know if this ok with you. Thanks a lot!
    Nike Free Pas Cher

  90. Eve Alt Says:

    How have you you could make your site look this cool. Email me if you possibly could and share your wisdom. Id be appreciative!

  91. ios apps development on windows Says:

    Simply wish to say your article is as surprising.
    The clearness in your put up is simply cool and that i could think you’re knowledgeable on this
    subject. Well along with your permission let me to grasp
    your feed to keep updated with drawing close post. Thanks a million and please carry
    on the enjoyable work.

Leave a Reply