摘要：
今天开发问我一个问题,PL/SQL很快出结果了,为什么应用还是很慢create index F_AGT_SAVB_ACCTINFO_H_idx4 on F_AGT_SAVB_ACCTINFO_H(agmt_id,last_trans_date,acct_bal,start_dt,end_dt,acc... 阅读全文
摘要：
with aa as (select a.agmt_id, sum(c.acct_bal) as card_bal, --借记卡期末存款余额 a.card_open_org, a.OPEN_DATE, -- 发卡日期 ... 阅读全文
摘要：
explain plan for with aa as (select a.agmt_id, sum(c.acct_bal) as card_bal, --借记卡期末存款余额 a.card_open_org, a.OPEN_DATE,... 阅读全文
摘要：
[root@ywcrmdb ~]# fdisk -lDisk /dev/sda: 751.6 GB, 751619276800 bytes255 heads, 63 sectors/track, 91379 cylindersUnits = cylinders of 16065 * 512 = 82... 阅读全文
摘要：
[root@localhost home]# su - cn0000rm: cannot remove `/home/cn0000/log/monitor_xmllog.20140417': Read-only file systemrm: cannot remove `/home/cn0000/l... 阅读全文
摘要：
use mastergodump transaction MBFEWKDB with no_loggodump transaction MBFEHISDB with no_loggouse mastergodump database MBFEWKDB to 'MBFEWKDB.bak'gouse m... 阅读全文
摘要：
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g ... 阅读全文
摘要：
select a.username,(select count(*) from all_objects b where b.owner=a.username) cnt from all_users a;create table a as select * from all_users;create ... 阅读全文
摘要：
select e.last_name, e.department_id, d.department_name from hr.employees e left outer join hr.departments d on (e.department_id = d.department_id); ... 阅读全文
摘要：
SQL> begin for i in 1..1000000 loop execute immediate 'insert into p1 values(i)' ; commit; end loop;end; 2 3 4 5 6 7 8 /begin*ERROR at line 1:... 阅读全文