- 博客(8)
- 收藏
- 关注
原创 char和varchar2对比
-- Create tablecreate table TLCB_HARDWARE_INFO( sdate DATE, ip CHAR(20), operating_system VARCHAR2(30), operatingsystemrelease CHAR(10), hostname
2017-05-31 15:14:57 622
原创 利用组合索引优化
select /*+ parallel(d 16)*/ count(*) from t47_transaction_uh d --174027378 select /*+ parallel(d 16)*/ count(*) from t47_transaction_uh d where d.TX_DT BETWEEN DATE '2015-10-01' AND D
2017-05-25 11:34:02 435
原创 Oracle range 分区表
-- Create tablecreate table TLCB_MON_LINUX( sdate DATE, ip CHAR(20), processcpu CLOB, processmem CLOB, port CLOB, countprocess VARCHAR2(100), countport
2017-05-25 10:15:37 481
原创 enq: TX - row lock contention 行锁
10.3.6.2.4 TX enqueue:那些是排他的当一个事务开始它的第一次改变持有知道COMMIT或者ROLLBACK:Waits for TX in mode 6:发生当一个session 是等待一个row level lock 被其他session持有。这个发生在一个yoghurt是更新或者删除一个记录, 另外一个session需要来更新或者删除。这类TX enque
2017-05-18 19:33:16 508
原创 分页语句模板
分页语句方法:1.rownum 2.row_number over(order by column) as 行号例子:create table page as select * from dba_objects;create index idx_page_1 on page(object_id,owner);BEGIN DBMS_STATS.GATHER_TABLE_STAT
2017-05-12 09:01:26 98
原创 彻底理解谓词推入的利弊
谓词推入(PUSHING PREDICATE):create or replace view vtest as select * from test1 where object_id>1000;SQL> explain plan for select /*+use_nl(test2 vtest) no_merge(vtest)*/ * from test2,vtestwhere test
2017-05-03 18:05:10 963
原创 集群因子 例子
测试:create table t1 as select trunc((rownum-1)/100) id, rpad(rownum,100) t_pad from dba_source where rownum<100000;create index t1_idx1 on t1(id);
2017-05-02 16:09:33 558
原创 优化 集群因子概念
一. 官网说明 The index clustering factor measures row order in relation to an indexed value suchas employee last name. The more order that exists in rowstorage for this value, the lower t
2017-05-02 15:21:21 415
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人