1. 首页
  2. IT资讯

SQLLODER导入WIn性能数据

“(PDH-CSV 4.0) ()(-480)”,”\CW5128MemoryAvailable KBytes”,”\CW5128MemoryPages/sec”,”\CW5128PhysicalDisk(_Total)% Idle Time”,”\CW5128PhysicalDisk(_Total)Avg. Disk Queue Length”,”\CW5128PhysicalDisk(_Total)Avg. Disk sec/Read”,”\CW5128PhysicalDisk(_Total)Avg. Disk sec/Write”,”\CW5128Processor(_Total)% Idle Time”
“10/16/2012 10:10:36.459″,”8825532″,” “,” “,” “,” “,” “,” “
“10/16/2012 10:10:51.459″,”8830616″,”412.44303858134458″,”79.362825411250697″,”0.2632983148907847″,”0.0032208791208791208″,”0.0052627118644067794″,”98.150413837351437”

 create table per
   (gettime timestamp,
    mem_free_kb number(30),
     mem_pages_sec number(30),
     phy_disk_total_pct number(30),
    phy_Disk_total_Que_len number(30),
     phy_Disk_total_sec_read number(30),
    phy_Disk_total_sec_write number(30),
    cpu_Idle_time_pct number(30));
    alter table per add constraint pk_p primary key(gettime);

LOAD DATA
INFILE ‘/home/oracle/per_000003.csv’
into table PER
FIELDS TERMINATED BY ‘,’
OPTIONALLY ENCLOSED BY ‘”‘
(gettime timestamp “mm/dd/YYYY hh24:mi:ss.ffx”,mem_free_kb,mem_pages_sec,phy_disk_total_pct,phy_Disk_total_Que_len,phy_Disk_total_sec_read,phy_Disk_total_sec_write,cpu
_Idle_time_pct)

select to_char(gettime, ‘yyyy-mm-dd hh24:mi:ss’) time_per,
       mem_free_kb,
       mem_pages_sec,
       NET_FACE_BYTE_SEC,
       phy_disk_total_pct,
       phy_Disk_total_Que_len,
       phy_Disk_total_sec_read,
       phy_Disk_total_sec_write,
       cpu_Idle_time_pct
  from per
  order by time_per ;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-756942/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183812.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code