Payday loan very quickly they often decide Emergency Payday Loans Emergency Payday Loans not refusing to new one.

Home > oracle > TX enqueue Mode 4的一点补充

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已经退出历史舞台了吧。

Eagle Fan oracle

  1. August 6th, 2013 at 16:21 | #1

    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?

  2. September 3rd, 2013 at 01:30 | #2

    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.

  3. September 27th, 2013 at 03:41 | #3

    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.

  4. September 30th, 2013 at 07:35 | #4

    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!
    http://www.abcronline.net
    [url=http://www.abcronline.net/]www.abcronline.net[/url]

  5. October 8th, 2013 at 11:40 | #5

    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

  6. October 24th, 2013 at 15:39 | #6

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

  7. March 20th, 2014 at 08:38 | #7

    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!

  8. May 28th, 2014 at 14:40 | #8

    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.

  9. May 29th, 2014 at 03:09 | #9

    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 )

  10. May 29th, 2014 at 23:10 | #10

    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!

  11. May 30th, 2014 at 00:38 | #11

    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 )

  12. May 30th, 2014 at 02:15 | #12

    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.

  13. May 31st, 2014 at 21:13 | #13

    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!

  14. May 31st, 2014 at 22:43 | #14

    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!

  15. May 31st, 2014 at 23:21 | #15

    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!

  16. visit here
    June 1st, 2014 at 19:41 | #16

    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. . . . . .

  17. June 1st, 2014 at 21:55 | #17

    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.

  18. June 2nd, 2014 at 13:55 | #18

    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.

  19. June 5th, 2014 at 20:05 | #19

    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.

  20. June 5th, 2014 at 23:20 | #20

    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!

  21. June 5th, 2014 at 23:41 | #21

    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.

  22. June 7th, 2014 at 23:38 | #22

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

  23. June 9th, 2014 at 02:42 | #23

    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.

  24. June 9th, 2014 at 15:56 | #24

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

  25. June 9th, 2014 at 16:17 | #25

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

  26. June 9th, 2014 at 22:42 | #26

    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.

  27. June 11th, 2014 at 03:17 | #27

    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

  28. June 11th, 2014 at 03:54 | #28

    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!

  29. June 12th, 2014 at 21:44 | #29

    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!

  30. June 12th, 2014 at 22:30 | #30

    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!

  31. June 16th, 2014 at 06:00 | #31

    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?

  32. June 16th, 2014 at 10:21 | #32

    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.

  33. June 20th, 2014 at 02:03 | #33

    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!

  34. June 21st, 2014 at 19:04 | #34

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

  35. June 21st, 2014 at 20:46 | #35

    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?

  36. June 22nd, 2014 at 18:22 | #36

    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.

  37. June 24th, 2014 at 16:00 | #37

    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.

  38. June 25th, 2014 at 13:00 | #38

    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?

Comment pages
  1. No trackbacks yet.