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

摘要： SMON的作用还包括清理IND$字典基表(cleanup ind$):触发场景当我们在线创建或重建索引时(create or rebuild index online)，服务进程会到IND$字典基表中将该索引对应的记录的FLAGS字段修改为十进制的256或者512(见上图0x100=256,0x200=512)，如:SQL> create index macleans_index on large... 阅读全文

摘要： 在我们介绍了使用ASMLIB作为一种专门为Oracle Automatic Storage Management特性设计的内核支持库(kernel support library)的优缺点，同时建议使用成熟的UDEV方案来替代ASMLIB。这里我们就给出配置UDEV的具体步骤，还是比较简单的:1.确认在所有RAC节点上已经安装了必要的UDEV包[root@rh2 ~]# rpm -qa|grep ... 阅读全文

摘要： The library cache (a component of the shared pool) stores the executable (parsed or compiled) form of recently referenced SQL and PL/SQL code. Oracle tries to reuse this code. If the code has been exe... 阅读全文

摘要： Occurs when the query coordinator is waiting for a response from a parallel slave. This is normally considered an idle event, but can cause excessive CPU in some cases. SolutionReduce the degree of ... 阅读全文

摘要： Occurs when a parallel slave is waiting to be told what to do. This is normally considered an idle event, but can cause excessive CPU in some cases. SolutionReduce the degree of parallelism in the q... 阅读全文

摘要： Occurs when a parallel slave is waiting for data from another slave. Investigate why the other slaves are not sending data fast enough. This is normally considered an idle event, but can cause excessi... 阅读全文

摘要： Contention caused by communication between parallel query processes. SolutionsDecrease the degree of parallelism for the queriesTune the parallel_execution_message_size parameter (may require larger... 阅读全文

摘要： Shareable SQL uses bind variables rather than literal values. If an application makes use of literal (unshared) SQL then this can severely limit scalability and throughput. The cost of parsing a new S... 阅读全文

摘要： Round-trip time when running "select 1 from dual" (includes network time but not connect time) on this database. SolutionIf this is high, contact your network administrator to understand network lat... 阅读全文

摘要： The term "seconds in wait" means the number of seconds that a SQL Statement, Database User, etc. was waiting on an event. It is possible that the total number of "seconds in wait" exceeds the total am... 阅读全文