环境准备¶
创建表¶
create table BILL_OUT_TEMP
(
sub_service_type Char (2 ),
fee_dir Char (1 ),
msc_type Char (1 ),
call_type Char (2 ),
ora_call_type Char (2 ),
ora_calling_number Char (24),
ora_called_number Char (24),
calling_number Char (24),
called_number Char (24),
start_datetime Char (14),
call_duration Char (8 ),
Msrn Char (11),
Msc Char (15),
lac_id Char (5 ),
trunk_group_out Char (16),
trunk_group_in Char (16),
calling_home_area_code Char (4 ),
calling_fixed_area_code Char (4 ),
called_home_area_code Char (4 ),
called_fixed_area_code Char (4 ),
clearing_area_code Char (4 ),
ora_calling_operator_code Char (4 ),
ora_called_operator_code Char (4 ),
msc_operator_code Char (4 ),
clearing_operator_code Char (4 ),
ora_calling_chat_type Char (2 ),
ora_called_chat_type Char (2 ),
sub_calling_chat_type Char (2 ),
sub_called_chat_type Char (2 ),
calling_operator_code Char (4 ),
called_operator_code Char (4 ),
fixed_type Char (1 ),
fee_type Char (1 ),
clearing_type Char (2 ),
calling_cfee Char (9 ),
calling_lfee Char (9 ),
called_cfee Char (6 ),
called_lfee Char (8 ),
clearing_fee Char (9 ),
user_info Char (5 ),
user_disc Char (5 ),
file_name Char (40),
deal_date Char (8 ),
ip_shop Char (10),
Backup Char (24),
Newline Char (1 )
);
数据导入¶
oimpexp -A 1 -F "d:\TEST.TXT" -E "," -V "\n" -c "\"" -B 30 -H localhost -D ANLI -U SYSDBA -P szoscar55 -p 2003 -S SYSDBA -T BILL_OUT_TEMP
打开两个线程导入数据，数据文件大小为501m。（导入时间为：两个线程运行时间的平均值）
通过运行概况发现网络I/O很低，且一直在下降，如下图所示.通过历史对比分析继续分析。
图228 运行概况