ORACLE数据库服务热线：13764045638 诗檀软件

摘要： During Direct Path operations, the data is asynchronously written to the database files. At some stage the session needs to make sure that all outstanding asynchronous I/O have been completed to disk.... 阅读全文

摘要： Waits on High Water enqueue occur when allocating space beyond the high water mark of a segment during insert operations. Also, this wait occurs when reclaiming free space in lob segments after delete... 阅读全文

摘要： Sessions waiting on this event are waiting on locks held during materialized view operations (such as refresh, alter) to prevent concurrent operations on the same materialized view.SolutionsA material... 阅读全文

摘要： New to Oracle 10g is the individual tracking of over 180 specific enqueues or internal Oracle locking mechanisms. One of these is the RO enqueue wait event for Object Reuse, and is used to synchronize... 阅读全文

摘要： Waits on this event typically occur because an index is missing on the column(s) containing a foreign key constraint. In this case Oracle is forced to acquire a TM lock on the child table during DELET... 阅读全文

摘要： TT 队列锁在官方文档中介绍为TT, Temporary Table，但是实际在版本8i之后该队列锁更多参与在表空间管理事务中。 也可以称enqueue TT为tablespace lock。作用该enqueue TT队列锁用以在各种类型的表空间操作执行过程中避免出现死锁dead lock。 该enqueue lock的 ID2表明正在执行的操作种类，ID1表明该操作对应的表空间号V$Tables... 阅读全文

摘要： SQL> select name from v$event_name where name like '%TX%';NAME----------------------------------------------------------------enq: TX - row lock contentionenq: TX - allocate ITL entryenq: TX - index c... 阅读全文

摘要： Library cache pins are used to manage library cache concurrence. Pinning an object causes the heaps to be loaded into memory (if not already loaded). PINS can be acquired in NULL, SHARE or EXCLUSIVE m... 阅读全文

摘要： Vmware Server最新版本2.0.2-203138是在2009年发布的，其使用一种较老的Kernel识别方法，这会导致我们在2.6.3x/2.6.40内核上安装Vmware Server时出现如下错误:The path "/usr/src/linux/include" is not an existing directory.The directory of kernel headers ... 阅读全文

摘要： GI PSU 11.2.0.2.3在最近的一次CPU July中被释出，该Patch Set Update包含了最新的CPU，且GI和Database PSU的都包含在其中，可以直接从页面下载到，该PSU所修复的Bug包括:CPU molecules in GI PSU 11.2.0.2.3:GI PSU 11.2.0.2.3 contains the following new CPU 11.2... 阅读全文