SQLLODER导入WIn性能数据

简介: "(PDH-CSV 4.0) ()(-480)","\\CW5128\Memory\Available KBytes","\\CW5128\Memory\Pages/sec","\\CW5128\PhysicalDisk(_Total)\% Idle Time","\\CW5128\PhysicalDisk(_Total)\Avg.

"(PDH-CSV 4.0) ()(-480)","\\CW5128\Memory\Available KBytes","\\CW5128\Memory\Pages/sec","\\CW5128\PhysicalDisk(_Total)\% Idle Time","\\CW5128\PhysicalDisk(_Total)\Avg. Disk Queue Length","\\CW5128\PhysicalDisk(_Total)\Avg. Disk sec/Read","\\CW5128\PhysicalDisk(_Total)\Avg. Disk sec/Write","\\CW5128\Processor(_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 ;

目录
打赏
0
0
0
0
91
分享
相关文章
VS Code 切换中英文
VS Code 切换中英文
1822 0
VS Code 切换中英文
lda模型和bert模型的文本主题情感分类实战
lda模型和bert模型的文本主题情感分类实战
269 0
【异常】Caused by: java.lang.ClassNotFoundException: javax.xml.bind.annotation.XmlType
【异常】Caused by: java.lang.ClassNotFoundException: javax.xml.bind.annotation.XmlType
258 0
C语言程序设计——int,double,char的用法
C语言程序设计——int,double,char的用法
掌握 go test 命令,写出可信赖的代码
掌握 go test 命令,写出可信赖的代码
185 0
Redis监控方案
Redis监控方案
195 0
Java 最常见的面试题:jedis 和 redisson 有哪些区别?
Java 最常见的面试题:jedis 和 redisson 有哪些区别?