ITPub博客

管理会计-ofsaa批处理时，作成本分摊的时候执行时间要很久，查看数据库等待事件为db file sequential read，简单描述一下此等待事件，如下：Wait Event: db file sequential readWait Class: User I/OData blocks are being read one at a time. Excessive time on this wait often signals unselective indexes or po...

drop table test01 purge;create table test01(emp_no number primary key,  --雇员号dep_no number,              --部门号sal number                  --薪水);--初始化四个雇员insert into test01 values(1,10,3000);i...