SELECT t.SQL_ID AS SQL的ID, t.SQL_TEXT AS SQL语句, t.HASH_VALUE AS 完整SQL哈希值, t.ELAPSED_TIME AS 解析执行总共时间微秒, t.EXECUTIONS AS 执行总共次数, t.LAST_ACTIVE_TIME AS 执行最后时间, t.CPU_TIME AS CPU执行时间微秒 FROM v$sqlarea t WHERE t.PARSING_SCHEMA_NAME IN ( 'C##DBAAS' ) AND t.EXECUTIONS > 10 AND t.LAST_ACTIVE_TIME > TO_DATE('0001-01-01 01:01:01', 'yyyy-MM-dd hh24:mi:ss') AND t.ELAPSED_TIME > 0 AND t.CPU_TIME > 0 ORDER BY t.EXECUTIONS DESC;

@Query(value="https://www.it610.com/article/SELECT/r/n" + " t.SQL_ID,\r\n" + " t.ELAPSED_TIME,\r\n" + " t.EXECUTIONS,\r\n" + " t.LAST_ACTIVE_TIME, \r\n" + " t.CPU_TIME \r\n" + "FROM\r\n" + " v$sqlarea t \r\n" + "WHERE\r\n" + " t.PARSING_SCHEMA_NAME IN ( 'C##DBAAS' )AND t.EXECUTIONS > 100\r\n" + "ORDER BY\r\n" + " t.EXECUTIONS DESC",nativeQuery=true) public List findTopSQLS4();

package com.befery.oams.entity; import java.io.Serializable; import java.math.BigInteger; import java.security.Timestamp; import java.util.Date; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Id; import javax.persistence.Table; @Entity@Table(name = "v$sqlarea")public class V$sqlarea implements Serializable { @Id private String sqlId; private Number elapsedTime; // 解析+执行sql 总时间 微秒 private Number executions; // 执行次数 private Date lastActiveTime; private Number cpuTime; public String getSqlId() {return sqlId; } public void setSqlId(String sqlId) {this.sqlId = sqlId; } public Number getElapsedTime() {return elapsedTime; } public void setElapsedTime(Number elapsedTime) {this.elapsedTime = elapsedTime; } public Number getExecutions() {return executions; } public void setExecutions(Number executions) {this.executions = executions; } public Date getLastActiveTime() {return lastActiveTime; } public void setLastActiveTime(Date lastActiveTime) {this.lastActiveTime = lastActiveTime; } public Number getCpuTime() {return cpuTime; } public void setCpuTime(Number cpuTime) {this.cpuTime = cpuTime; } public V$sqlarea() { } public V$sqlarea(String sqlId, Number elapsedTime, Number executions, Date lastActiveTime,Number cpuTime) {this.sqlId = sqlId; this.elapsedTime = elapsedTime; this.executions = executions; this.lastActiveTime = lastActiveTime; this.cpuTime = cpuTime; } }

package com.befery.oams.util; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import java.lang.reflect.Constructor; import java.lang.reflect.Field; import java.lang.reflect.Method; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; public class EntityUtils {private static Logger logger = LoggerFactory.getLogger(EntityUtils.class); /*** 将数组数据转换为实体类* 此处数组元素的顺序必须与实体类构造函数中的属性顺序一致** @param list数组对象集合* @param clazz实体类* @param 实体类* @param model实例化的实体类* @return 实体类集合*/public static List castEntity(List list, Class clazz, Object model) {List returnList = new ArrayList(); if (list.isEmpty()) {return returnList; }//获取每个数组集合的元素个数Object[] co = list.get(0); //获取当前实体类的属性名、属性值、属性类别List

@GetMapping(value = "https://www.it610.com/list") @ResponseBody public List selectTopSQLUntreated() {System.out.println("============================TOPSQLSTART================================="); List list = v$sqlareaDao.findTopSQLS4(); List list1 =EntityUtils.castEntity(list, V$sqlarea.class,new V$sqlarea()); System.out.println("============================TOPSQLEND================================="); return list1; }

============================TOPSQL START=================================
Hibernate:
SELECT
t.SQL_ID,
t.ELAPSED_TIME,
t.EXECUTIONS,
t.LAST_ACTIVE_TIME,
t.CPU_TIME
FROM
v$sqlarea t
WHERE
t.PARSING_SCHEMA_NAME IN (
'C##DBAAS'
)
AND t.EXECUTIONS > 100
ORDER BY
t.EXECUTIONS DESC
============================TOPSQL END=================================
2019-03-12 18:06:57.108 INFO 21076 --- [nio-8081-exec-7] com.befery.oams.config.LogAspectConfig : --------------返回内容----------------
2019-03-12 18:06:57.114 INFO 21076 --- [nio-8081-exec-7] com.befery.oams.config.LogAspectConfig : Response内容:[{"cpuTime":84731,"elapsedTime":183491,"executions":348,"lastActiveTime":1552385204000,"sqlId":"f05fn7j6rbcsj"},{"cpuTime":17827,"elapsedTime":33036,"executions":212,"lastActiveTime":1552385203000,"sqlId":"avc1jqzz04wpr"},{"cpuTime":9054,"elapsedTime":23874,"executions":174,"lastActiveTime":1552385204000,"sqlId":"b4xr1nw5vtk2v"},{"cpuTime":102017,"elapsedTime":97842,"executions":153,"lastActiveTime":1552313331000,"sqlId":"711b9thj3s4ug"},{"cpuTime":89011,"elapsedTime":90341,"executions":153,"lastActiveTime":1552313331000,"sqlId":"grqh1qs9ajypn"},{"cpuTime":58984,"elapsedTime":81214,"executions":135,"lastActiveTime":1552385214000,"sqlId":"d442vk7001fvw"},{"cpuTime":17260604818,"elapsedTime":41375561059,"executions":122,"lastActiveTime":1552297847000,"sqlId":"170am4cyckruf"},{"cpuTime":13194,"elapsedTime":31267,"executions":108,"lastActiveTime":1552383540000,"sqlId":"9q00dg3n0748y"}]
2019-03-12 18:06:57.114 INFO 21076 --- [nio-8081-exec-7] com.befery.oams.config.LogAspectConfig : --------------返回内容----------------

/** * * @author xiaofanku@live.cn */@Entity@Table(name="apo_config")public class SiteConfig implements Serializable {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Long ID; private String caption; @ElementCollection(fetch = FetchType.LAZY)@MapKeyColumn(name="name")@Column(name="value")@CollectionTable(name="apo_config_attributes", joinColumns=@JoinColumn(name="ca_id"))private Map attributes = new HashMap(); //GET/SET}

@Testpublic void test(){SiteConfig sc=new SiteConfig(); sc.setID(1L); sc.setCaption("全局配置"); Map data=https://www.it610.com/article/new HashMap<>(); data.put("site", "csdn.net"); data.put("account", "xiaofanku"); sc.setAttributes(data); siteConfigDao.save(sc); }@Testpublic void getConfig(){SiteConfig config=siteConfigDao.findOne(1L); assertEquals(config.getAttributes().get("site"), "csdn.net"); }

/** * * @author xiaofanku@live.cn */@Entity@Table(name="apo_config")public class SiteConfig implements Serializable {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Long ID; private String caption; @OneToMany(cascade=CascadeType.ALL, orphanRemoval = true)@MapKey(name="name")@JoinTable(name = "apo_config_attributes")private Map attributes=new HashMap<>(); //GET/SET}

/** * * @author xiaofanku@live.cn */@Entity@Table(name="apo_attributes")public class ConfigAttribute implements Serializable {@Id@GeneratedValue(strategy = GenerationType.IDENTITY)private Long ID; @Column(name="name")private String name; private String value; //GET/SET}

@Test @Ignorepublic void test(){SiteConfig sc=new SiteConfig(); sc.setID(1L); sc.setCaption("全局配置"); Map data=https://www.it610.com/article/new HashMap<>(); ConfigAttribute ca1=new ConfigAttribute(); ca1.setName("site"); ca1.setValue("csdn.net"); data.put("site", ca1); ConfigAttribute ca2=new ConfigAttribute(); ca2.setName("account"); ca2.setValue("xiaofanku"); data.put("account", ca2); sc.setAttributes(data); siteConfigDao.save(sc); }@Test @Ignorepublic void getConfig(){SiteConfig config=siteConfigDao.findOne(1L); assertEquals(config.getAttributes().get("site").getValue(), "csdn.net"); }

import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Objects; import java.util.Set; import org.apache.commons.beanutils.BasicDynaClass; import org.apache.commons.beanutils.ConvertUtils; import org.apache.commons.beanutils.DynaBean; import org.apache.commons.beanutils.DynaProperty; /** * 使用Commons Beanutils实现动态类 * @author xiaofanku@live.cn * @since 20171024 */public class DynamicClass{private final DynaBean config; /*** 构造一个运态类型* @param attributeMeta key属性名,value为属性名的类型,例:java.lang.Boolean* @throws IllegalAccessException* @throws InstantiationException* @throws ClassNotFoundException */public DynamicClass(Map attributeMeta) throws IllegalAccessException, InstantiationException, ClassNotFoundException{DynaProperty[] props=covert(attributeMeta).toArray(new DynaProperty[]{}); BasicDynaClass dynaClass = new BasicDynaClass("CustomConfig", null, props); this.config = dynaClass.newInstance(); }/*** 构造一个运态类型* @param attributes* @throws ClassNotFoundException* @throws IllegalAccessException* @throws InstantiationException */public DynamicClass(Set attributes) throws ClassNotFoundException, IllegalAccessException, InstantiationException{DynaProperty[] props=covert(attributes).toArray(new DynaProperty[]{}); BasicDynaClass dynaClass = new BasicDynaClass("CustomConfig", null, props); this.config = dynaClass.newInstance(); load(attributes); }/*** 获得属性值* @param attributeName 属性名* @return*/public Object getValue(String attributeName){return config.get(attributeName); }/*** 获得属性值* @param attributeName 属性名* @param classType 属性类型* @param * @return* @throws java.lang.ClassCastException*/public T getValue(String attributeName, Class classType) throws java.lang.ClassCastException{return (T)getValue(attributeName); }/*** 设置属性* @param attributeName 属性名* @param attributeValue 属性值*/public void setValue(String attributeName, String attributeValue){DynaProperty dp = config.getDynaClass().getDynaProperty(attributeName); config.set(attributeName, ConvertUtils.convert(attributeValue, dp.getType())); }/*** 设置属性* @param attribute 属性实例* @throws ClassNotFoundException*/public void setValue(Attribute attribute) throws ClassNotFoundException {config.set(attribute.getName(), ConvertUtils.convert(attribute.getValue(), Class.forName(attribute.getClassName()))); }/*** 装载属性集合,填充动态类实例* @param attributes */private void load(Set attributes){for(Attribute attr : attributes){try{config.set(attr.getName(), ConvertUtils.convert(attr.getValue(), Class.forName(attr.getClassName()))); }catch(ClassNotFoundException e){}}}/*** 返回一个DynaProperty列表* @param attributes* @return* @throws ClassNotFoundException*/private List covert(Set attributes) throws ClassNotFoundException{List attres=new ArrayList<>(); for(Attribute attr : attributes){attres.add(new DynaProperty(attr.getName(), Class.forName(attr.getClassName()))); }return attres; }/*** 返回一个DynaProperty列表* @param attributeMeta key属性名,value为属性名的类型,例:java.lang.Boolean* @return* @throws ClassNotFoundException*/private List covert(Map attributeMeta) throws ClassNotFoundException{List properties=new ArrayList<>(); Set attrSet=attributeMeta.keySet(); for(String attrName : attrSet){String className=attributeMeta.get(attrName); properties.add(new DynaProperty(attrName, Class.forName(className))); }return properties; }public static enum Type{BOOLEAN("java.lang.Boolean"),INTEGER("java.lang.Integer"),LONG("java.lang.Long"),STRING("java.lang.String"),CHAR("java.lang.Character"),DOUBLE("java.lang.Double"),FLOAT("java.lang.Float"); private final String name; private Type(String className){this.name=className; }public String getName() {return name; }}public static class Attribute{//属性名,例:showprivate final String name; //属性名的值,例:"true"private final String value; //属性名的类型,例:java.lang.Booleanprivate final String className; public Attribute(String name, String value, String className) {this.name = name; this.value = https://www.it610.com/article/value; this.className = className; }public String getName() {return name; }public String getValue() {return value; }public String getClassName() {return className; }@Overridepublic int hashCode() {int hash = 5; hash = 97 * hash + Objects.hashCode(this.name); hash = 97 * hash + Objects.hashCode(this.className); return hash; }@Overridepublic boolean equals(Object obj) {if (this == obj) {return true; }if (obj == null) {return false; }if (getClass() != obj.getClass()) {return false; }final Attribute other = (Attribute) obj; if (!Objects.equals(this.name, other.name)) {return false; }if (!Objects.equals(this.className, other.className)) {return false; }return true; }}}

@Testpublic void test(){Set sas=new HashSet<>(); sas.add(new Attribute("logo", "logo.png", DynamicClass.Type.STRING.getName())); sas.add(new Attribute("pageSize", "50", DynamicClass.Type.INTEGER.getName())); sas.add(new Attribute("shortcut", "true", DynamicClass.Type.BOOLEAN.getName())); try{DynamicClass dc=new DynamicClass(sas); Integer ps = dc.getValue("pageSize", Integer.class); System.out.println(ps); dc.setValue("pageSize", "150"); System.out.println(dc.getValue("pageSize")); }catch(Exception e){e.printStackTrace(); }}@Test @Ignorepublic void base() {Map am = new HashMap<>(); am.put("logo", DynamicClass.Type.STRING.getName()); am.put("pageSize", DynamicClass.Type.INTEGER.getName()); am.put("shortcut", DynamicClass.Type.BOOLEAN.getName()); try {DynamicClass dc = new DynamicClass(am); dc.setValue("pageSize", "150"); System.out.println(dc.getValue("pageSize")); dc.setValue(new Attribute("shortcut", "true", DynamicClass.Type.BOOLEAN.getName())); System.out.println(dc.getValue("shortcut")); } catch (IllegalAccessException | InstantiationException | ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace(); }}

• JPA 2.1 实现 EclipseLink 2.5.2
• JDK 1.8.x
• Mysql 5.5.x
• ASF Commons BeanUtils 1.8.3

推荐阅读

• 

  基金初级训练营－毕业感言
• 

  iphone怎么换行输入 iphone如何换行
• 

  （家）‖盼啊盼，五月终于开始发“牙”了。
• 

  浙江省台州市神仙居门票多少钱 台州神仙居免费门票答题入口在哪
• 

  奇亚籽食用方法 奇亚籽食用方法介绍
• 

  芯片|无缘麒麟芯片，荣耀新机曝光，要与小米争第一
• 

  孕妇可不可以吃毛豆
• 

  各种app图标大全现代朗动，现代朗动里面有个小车图标要不要亮起的
• 

  算法分析与设计 耿国华
• 

  保健养生应顺应节气的变化
• 

  颈椎病需要注意什么 颈椎病的病因是什么
• 

  南通人才公寓出租 南通人才公寓房租多少？
• 

  原发性高血压|致2.45亿高血压患者：若掉进6个坑，并发症可能提早10年来
• 

  马齿苋的副作用你知道吗？ 马齿苋的副作用
• 

  《和平精英》11.4光子将24套“绝版皮肤”进行投票,排名前6会返场！你喜欢哪一个？
• 

  快速傅立叶变换 例题 n=8 数值分析
• 

  无线网络地址怎么设置 无线如何设置
• 

  林内牌热水器代码故障怎么自己解除，常见故障处理技巧知识介绍 ,该怎么解决呢？
• 

  黄金圈法则
• 

  商标注册分为哪几类 水商标分为多少类，商标按知名度可分为哪几类

• Activiti（一）SpringBoot2集成Activiti6
• SpringBoot调用公共模块的自定义注解失效的解决
• 解决SpringBoot引用别的模块无法注入的问题
• 2018-07-09|2018-07-09 Spring 的DBCP，c3p0
• 数据库总结语句
• spring|spring boot项目启动websocket
• Spring|Spring Boot 整合 Activiti6.0.0
• vue组件中为何data必须是一个函数（）
• Spring集成|Spring集成 Mina
• springboot使用redis缓存