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!

Comment pages
  1. No trackbacks yet.