发布时间:2013-06-14 14:27:15
If the high concurrency of insert, and if we insert into the same block, the block will became a hot block, the wait event maybe latch: CBC, data buffer busy. this usually is the case when the index is date related and sequence related. and for some power seller.........【阅读全文】
发布时间:2013-06-13 18:38:34
点击(此处)折叠或打开select count(*) from v$process --当前的连接数select value from v$parameter where name = 'processes' --数据库允许的最大连接数修改最大连接数:alter system set processes = 300 scope = spfil.........【阅读全文】
发布时间:2013-06-09 13:52:57
11gR2 rac开归档:点击(此处)折叠或打开11g RAC 更改归档模式 ASM1.在节点1 cedb1上执行[root@devnode1 ~]# su - grid[grid@devnode1 ~]$ [grid@devnode1 ~]$ [grid@devnode1 ~]$ sqlplus .........【阅读全文】
发布时间:2013-06-07 13:31:45
由于工作需求经常需要查看一个库的sql执行消耗情况,为了方便查询写了一个小查询sql与大家分享一下:点击(此处)折叠或打开select cast(buffer_gets/decode(EXECUTions,0,10000,EXECUTions) as int) avg_IO ,EXECUTions execs,buffer_gets logical_IO,disk_read.........【阅读全文】