Excel 如何把 statspack 生成的采样报告以报表的形式呈现 我现在用 statspack 生成了数据库的采样报告,但是 我怎样才能用 excel 把 statspack 生成的采样报告以报表的形式呈现,就是有曲线图的那种.有会的兄弟请帮帮忙.小弟谢谢了 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 具体参数值版本不同而不同。需要查一下自己版本对应值。--物理读写IO 操作SELECT SUBSTR(TO_CHAR(SNAP_TIME, 'yyyy-mm-dd HH24:MI:SS'), 12),(NEWREADS.VALUE - OLDREADS.VALUE) READS,(NEWWRITES.VALUE - OLDWRITES.VALUE) WRITESFROM PERFSTAT.STATS$SYSSTAT OLDREADS, PERFSTAT.STATS$SYSSTAT NEWREADS,PERFSTAT.STATS$SYSSTAT OLDWRITES, PERFSTAT.STATS$SYSSTAT NEWWRITES,PERFSTAT.STATS$SNAPSHOT SNWHERE NEWREADS.SNAP_ID = SN.SNAP_IDAND NEWWRITES.SNAP_ID = SN.SNAP_IDAND OLDREADS.SNAP_ID = SN.SNAP_ID - 1AND OLDWRITES.SNAP_ID = SN.SNAP_ID - 1AND OLDREADS.STATISTIC# = 39--40 --42 physical readsAND NEWREADS.STATISTIC# = 39 --40 --42AND OLDWRITES.STATISTIC# = 42 --41 --46 physical writesAND NEWWRITES.STATISTIC# = 42 --41 --46AND (NEWREADS.VALUE - OLDREADS.VALUE) > 0AND (NEWWRITES.VALUE - OLDWRITES.VALUE) > 0--buffer命中率SELECT SUBSTR(TO_CHAR(SNAP_TIME, 'yyyy-mm-dd HH24:MI'), 12),ROUND(100 * (((A.VALUE - E.VALUE) + (B.VALUE - F.VALUE)) -(C.VALUE - G.VALUE)) /((A.VALUE - E.VALUE) + (B.VALUE - F.VALUE))) "BUFFER HIT RATIO"FROM PERFSTAT.STATS$SYSSTAT A,PERFSTAT.STATS$SYSSTAT B,PERFSTAT.STATS$SYSSTAT C,PERFSTAT.STATS$SYSSTAT D,PERFSTAT.STATS$SYSSTAT E,PERFSTAT.STATS$SYSSTAT F,PERFSTAT.STATS$SYSSTAT G,PERFSTAT.STATS$SNAPSHOT SNWHERE A.SNAP_ID = SN.SNAP_IDAND B.SNAP_ID = SN.SNAP_IDAND C.SNAP_ID = SN.SNAP_IDAND D.SNAP_ID = SN.SNAP_IDAND E.SNAP_ID = SN.SNAP_ID - 1AND F.SNAP_ID = SN.SNAP_ID - 1AND G.SNAP_ID = SN.SNAP_ID - 1AND A.STATISTIC# = 51 --39 --41 consistent getsAND E.STATISTIC# = 51 --39AND B.STATISTIC# = 48 --38 --40 db block getsAND F.STATISTIC# = 48 --38AND C.STATISTIC# = 39 --40 --42 physical reads AND G.STATISTIC# = 39 --40AND D.STATISTIC# = 可是,楼主 ,您给我的两个 SQL 语句是要在那里执行?应该怎么执行? EBS应用能否同时夸两个平台 oracel 查询排序的一点疑问 如何实现一次替换掉字符串中的 tab 符 和换行符 创建外部表,查询出错 使用自定义数组类型的问题 oracle中如何统计非空列,并将这个数值,放在最后一列中 请教Oracle中存储过程参数问题 能返回一多条记录吗? 问高手关于TO_DATE函数的问题。在线急等 oracle7到oracle8出现乱码问题,有分 两个表全联 请问谁有toad for oracle的中文电子教程?我的邮箱是[email protected],谢谢!
--物理读写IO 操作SELECT SUBSTR(TO_CHAR(SNAP_TIME, 'yyyy-mm-dd HH24:MI:SS'), 12),(NEWREADS.VALUE - OLDREADS.VALUE) READS,(NEWWRITES.VALUE - OLDWRITES.VALUE) WRITESFROM PERFSTAT.STATS$SYSSTAT OLDREADS, PERFSTAT.STATS$SYSSTAT NEWREADS,PERFSTAT.STATS$SYSSTAT OLDWRITES, PERFSTAT.STATS$SYSSTAT NEWWRITES,PERFSTAT.STATS$SNAPSHOT SNWHERE NEWREADS.SNAP_ID = SN.SNAP_IDAND NEWWRITES.SNAP_ID = SN.SNAP_IDAND OLDREADS.SNAP_ID = SN.SNAP_ID - 1AND OLDWRITES.SNAP_ID = SN.SNAP_ID - 1AND OLDREADS.STATISTIC# = 39--40 --42 physical readsAND NEWREADS.STATISTIC# = 39 --40 --42AND OLDWRITES.STATISTIC# = 42 --41 --46 physical writesAND NEWWRITES.STATISTIC# = 42 --41 --46AND (NEWREADS.VALUE - OLDREADS.VALUE) > 0AND (NEWWRITES.VALUE - OLDWRITES.VALUE) > 0--buffer命中率SELECT SUBSTR(TO_CHAR(SNAP_TIME, 'yyyy-mm-dd HH24:MI'), 12),ROUND(100 * (((A.VALUE - E.VALUE) + (B.VALUE - F.VALUE)) -(C.VALUE - G.VALUE)) /((A.VALUE - E.VALUE) + (B.VALUE - F.VALUE))) "BUFFER HIT RATIO"FROM PERFSTAT.STATS$SYSSTAT A,PERFSTAT.STATS$SYSSTAT B,PERFSTAT.STATS$SYSSTAT C,PERFSTAT.STATS$SYSSTAT D,PERFSTAT.STATS$SYSSTAT E,PERFSTAT.STATS$SYSSTAT F,PERFSTAT.STATS$SYSSTAT G,PERFSTAT.STATS$SNAPSHOT SNWHERE A.SNAP_ID = SN.SNAP_IDAND B.SNAP_ID = SN.SNAP_IDAND C.SNAP_ID = SN.SNAP_IDAND D.SNAP_ID = SN.SNAP_IDAND E.SNAP_ID = SN.SNAP_ID - 1AND F.SNAP_ID = SN.SNAP_ID - 1AND G.SNAP_ID = SN.SNAP_ID - 1AND A.STATISTIC# = 51 --39 --41 consistent getsAND E.STATISTIC# = 51 --39AND B.STATISTIC# = 48 --38 --40 db block getsAND F.STATISTIC# = 48 --38AND C.STATISTIC# = 39 --40 --42 physical reads AND G.STATISTIC# = 39 --40AND D.STATISTIC# =