摘要：
library cahce pin(库高速缓存pin)等待事件与库高速缓存并发性有关,当会话尝试在库高速缓存中钉住对象以修改或检查该对象时产生该事件。会话必须获取(pin)以确保此时对象没有被其他会话更新。当会话正在编译或分析PL/SQL过程和视图时,Oracle提交该事件。library cac... 阅读全文
posted @ 2014-03-21 11:05
czcb
阅读(255)
评论(0)
推荐(0)
摘要：
delete from dupes where rowid in (select rowid from (select a.*,row_number() over(partition by name order by name) as rn from dupes a)where rn>1); 阅读全文
posted @ 2014-03-19 19:50
czcb
阅读(269)
评论(0)
推荐(0)
摘要：
SQL> select corp_org,count(*) from test_2 where end_dt > date'2013-05-01' 2 group by corp_org order by count(*) desc;CORP_ORG COUNT(*)------... 阅读全文
posted @ 2014-03-19 19:45
czcb
阅读(235)
评论(0)
推荐(0)
摘要：
||--批量修改sequence: select 'alter sequence ' || SEQUENCE_OWNER ||'.'||sequence_name|| ' cache 1000;' from dba_sequences;---批量drop 表:SQL> select 'drop ta... 阅读全文
posted @ 2014-03-19 19:39
czcb
阅读(165)
评论(0)
推荐(0)
摘要：
一: 创建的索引1create index f_agt_comr_intdist_h_idx2 on f_agt_comr_intdist_h(agmt_id,intt,payable_int_amt,dw_data_dt) tablespace EDWFIDXTBS nologging SQL> ... 阅读全文
posted @ 2014-03-19 19:38
czcb
阅读(188)
评论(0)
推荐(0)
摘要：
create table a3 as select * from dba_objectscreate index a3_idx1 on a3(owner);select owner from a3 where owner='SCOTT';SQL> set linesize 200SQL> set p... 阅读全文
posted @ 2014-03-19 16:44
czcb
阅读(258)
评论(0)
推荐(0)
摘要：
---原始SQLSQL> SELECT deptno FROM emp WHERE empno = 7788 OR job = 'SALESMAN' ORDER BY 1; DEPTNO---------- 20 30 30 30 30SQL> SELECT deptno FROM emp W... 阅读全文
posted @ 2014-03-18 19:31
czcb
阅读(499)
评论(0)
推荐(0)
摘要：
select aa.acct_org,aa.loan_acct_no,aa.FUNCTIONARY,aa.cust_no,sum(dwm.pkg_tools.currcdtran(bb.INTT,aa.trans_cur_cd,'T00CNY','2014-02-10')) as jtlx fr... 阅读全文
posted @ 2014-03-18 19:29
czcb
阅读(274)
评论(0)
推荐(0)
摘要：
/* Formatted on 2014/03/18 09:48 (Formatter Plus v4.8.8) */SELECT c.fee_type_desc, i.order_code, b.chn_name AS rexp_code_name, i.rexp_code, ... 阅读全文
posted @ 2014-03-18 10:59
czcb
阅读(268)
评论(0)
推荐(0)
摘要：
--并行查询可以使用并行查询的情况1. Full table scans, full partition scans, and fast full index scans2. Index full and range scans, but only if the index is partitio... 阅读全文
posted @ 2014-03-17 16:23
czcb
阅读(464)
评论(0)
推荐(0)
浙公网安备 33010602011771号