ITPub博客

http://www.itpub.net/thread-1587833-1-2.html

http://www.hellodba.com/reader.php?ID=58&lang=CN

http://www.eygle.com/archives/2011/11/oracle_hwm_tuning.html

前几篇主要测试了范围分区的创建及维护,侧重语法方面;   参见:http://space.itpub.net/9240380/viewspace-751843如:创建分区表,添加分区表,删除分区,修改分区属性,合并分区,拆分分区,交换分区等如...

http://space.itpub.net/?uid-9240380-action-viewspace-itemid-751842 ------------交换分区,用普通表和分区表某个分区交换,即把普通表的数据可以转化到分区表中---如下说明要进行交换分区,普通表要与...

 http://space.itpub.net/9240380/viewspace-751835 续上继续测试: ----------------------------truncate分区SQL> select table_name,composite,partition_name from user_tab_partitions w...

-- Create tablecreate table PORTAL_REQUESTWS_HISTORY_01(  id                 VARCHAR2(32) not null,  c...

1,SQL> set sqlprompt session_130>session_130>insert into t_free select * from t_free;2,session_8>truncate table t_free;truncate table t_free        &nbs...

http://blog.csdn.net/tianlesoftware/article/details/6526238

http://www.dbtan.com/2010/05/event-about-log.html

bitand　　bitand 　　返回两个数值型数值在按位进行 AND 运算后的结果。 　　语法 　　BITAND(nExpression1, nExpression2) 　　参数 　　nExpression1, nExpression2 　　指定按位进行 AND ...

http://blog.csdn.net/hijk139/article/details/7411106 小结:经加大alter table x allocate(extent 1000m);通过监控select * from v$session_wait;--仍会产生hw contention 明天继续分析! ...

SQL> alter table t_free storage (maxextents 120);alter table t_free storage (maxextents 120)*第 1 行出现错误:ORA-25150: 不允许对区参数执行 ALTERING SQL> select tablespace_name,extent_mana...

http://blog.csdn.net/gguxxing008/article/details/6858579

http://docs.oracle.com/cd/E11882_01/server.112/e25513/waitevents003.htm#sthref3925

Table 10-1 Wait Events and Potential CausesWait EventGeneral AreaPossible CausesLook for / Examinebuffer busy waitsBuffer cache, DBWRDepends on buffer type. For example, waits for an index blo...

http://www.itpub.net/thread-1362104-1-1.html

http://www.itpub.net/thread-1088598-1-1.html

Diff B/W Truncate & DeleteSubmitted by arunbharat2001 on Sat, 2012-10-20 11:03SQL & PL/SQLDelete 1.DML data can be recovered by rollback before commit2.Remove any subset of data3.Delete is slo...

http://qjoycn.iteye.com/blog/1279731