用到的表结构如下:
create table buffer
(
streamnumber varchar2(20),
scpid varchar2(20),
locationnumber varchar2(20),
chargerecordedenti varchar2(20),
chargepartingdica varchar2(20),
specificchargedpar varchar2(20),
typeoftraffic varchar2(20),
causeofcallend varchar2(20),
insurcharge varchar2(20),
chargemodulator varchar2(20),
transparentparanet varchar2(20),
servicekey number(8) not null,
chargemode number(2) not null,
chargeclass number(8) not null,
callcost number(8) not null,
caller varchar2(20) not null,
callee varchar2(20) not null,
called varchar2(20) not null,
startdateandtime varchar2(14) not null,
enddateandtime varchar2(14) not null,
duration varchar2(8) not null
flag varchar2(4);
flagi number(4);
);
call_intellective 、call_pre_pay、call_201等所指向的表就是在buffer的基础上增加
(
p_duration number(8),callee_subsidiaryid number(9),caller_subsidiaryid number(9),caller_type varchar2(32),callee_company varchar2(32)这些字段。create table errors_log(errorid number(5),errortime date,jobname varchar2(128),sys_err_info varchar2(256));
create table buffer
(
streamnumber varchar2(20),
scpid varchar2(20),
locationnumber varchar2(20),
chargerecordedenti varchar2(20),
chargepartingdica varchar2(20),
specificchargedpar varchar2(20),
typeoftraffic varchar2(20),
causeofcallend varchar2(20),
insurcharge varchar2(20),
chargemodulator varchar2(20),
transparentparanet varchar2(20),
servicekey number(8) not null,
chargemode number(2) not null,
chargeclass number(8) not null,
callcost number(8) not null,
caller varchar2(20) not null,
callee varchar2(20) not null,
called varchar2(20) not null,
startdateandtime varchar2(14) not null,
enddateandtime varchar2(14) not null,
duration varchar2(8) not null
flag varchar2(4);
flagi number(4);
);
call_intellective 、call_pre_pay、call_201等所指向的表就是在buffer的基础上增加
(
p_duration number(8),callee_subsidiaryid number(9),caller_subsidiaryid number(9),caller_type varchar2(32),callee_company varchar2(32)这些字段。create table errors_log(errorid number(5),errortime date,jobname varchar2(128),sys_err_info varchar2(256));
pre_page_sga=yes
然后重新启动数据库db_block_size=8092注意块的大小不能轻易改变!
buffer 表flag字段是否有索引,如果flag字段不同值不多,可以考虑建一个位图索引,这样可以避免每次查询buffer表时进行全表扫描.