cat listener_0910.log |grep "HOST=13"|awk -F* ‘{print $1,$3}‘>lis1.txt
cat lis1.txt |cut -b 12-23,53-65>lis2.txt
将lis2.txt中的数据插入到表中，进行分析
select to_char(to_date(t.lis_time,‘dd:mi:ss‘),‘dd:mi:ss‘),count(*) from lis2 t group by to_char(to_date(t.lis_time,‘dd:mi:ss‘),‘dd:mi:ss‘) ;
