Oracle和MySQL - 博客园

cursor: mutex X等待事件

摘要： A session waits on this event when it has requested a mutex for a cursor object in exclusive mode but must wait because it is busy. The mutex is busy because either the mutex is being held in exclusiv... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(541) 评论(0) 推荐(0)

cursor: pin S等待事件

摘要： A session waits on this event when it wants to update a shared mutex pin and another session is currently in the process of updating a shared mutex pin for the same cursor object. This wait event shou... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(143) 评论(0) 推荐(0)

cursor: pin S wait on X等待事件

摘要： A session waits on this event when requesting a mutex for sharable operations related to pins (such as executing a cursor), but the mutex cannot be granted because it is being held exclusively by anot... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(156) 评论(0) 推荐(0)

cursor: pin X等待事件

摘要： A session waits on this event when it is requesting an exclusive mutex pin for a cursor object and it must wait because the resource is busy. The mutex pin for a cursor object can be busy either becau... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(140) 评论(0) 推荐(0)

cell manager closing cell等待事件

摘要： This is an Exadata wait event that occurs during the shutdown of a storage cell. This is normal activity associated with shutdown processing. SolutionsIf there are queries waiting on this event, it ma... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(135) 评论(0) 推荐(0)

cell manager discovering disks等待事件

摘要： This is an Exadata wait event that occurs when a storage cell is starting and discovering disks. SolutionsThis is a normal part of starting up the storage cell in an Exadata system. If there are queri... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(120) 评论(0) 推荐(0)

cell manager opening cell等待事件

摘要： This is an Exadata wait event that occurs when a storage cell is starting and opening a cell for use. SolutionsThis is a normal part of starting up the storage cell in an Exadata system. If there are... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(124) 评论(0) 推荐(0)

cell multiblock physical read等待事件

摘要： This is an Exadata wait event similar to 'db file scattered read' and typically indicates the statement is performing a full table scan or an index fast full scan. This wait event is not seen nearly a... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(577) 评论(0) 推荐(0)

cell single block physical read等待事件

摘要： This is an Exadata wait event similar to db file sequential read and normally occurs during index lookups when the block is not in memory and must be read from the Exadata storage cell disks. These ar... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(2682) 评论(0) 推荐(0)

cell smart file creation等待事件

摘要： Sessions wait on this event in Exadata when creating tablespaces, adding files to an existing tablespace or automatic expansion a data file because of DML operations, e.g. data is being loaded into a ... 阅读全文

posted @ 2013-03-19 00:47 Oracle和MySQL 阅读(170) 评论(0) 推荐(0)