全局事务 有开始 无commit 这时停服务,但数据库层面还有有对象锁定。 select addr,sid,username,s.status,process,s.LAST_CALL_ET,s.program,START_DATE from v$transaction t,v$session s where t.ses_addr=s.saddr order by LAST_CALL_ET; 查询无事务。 但下面锁定对...【阅读全文】
创建范围分区:create table range_part_tab (id number,deal_date date,area_code number,contents varchar2(4000))partition by range(deal_date)(partition p1 values less than (TO_DATE('2012-02-01','YYYY-MM-DD')),partition p2 values less than (TO_DATE('2012-03-01','YYYY-MM-DD')),partition p3 values l...【阅读全文】