主页 > 新闻资讯 > > 正文

谷歌云_oracle数据库授权_9元

来源:胜利云 发布时间:2021-05-05 04:29 标签:数据库Oracle谷歌授权9元
浏览:

If you want to find out what are the frequently executed statement or query or a view in HANA  per client which connects to HANA DB ,below SQL will help with the same . Here I am displaying top 5 statements ,aggregated per client.(Eg Clients that connects here: -WebIntelligence,ABAP,Mashup Engine etc.

=========

with cte as (select distinct statement_hash, application_name,count(statement_hash) as num, rank() over ( partition by application_name order by count(statement_hash)desc) R from m_expensive_statements group by statement_hash,application_name order by application_name desc)

select * from cte where R in (‘1′,’2′,’3′,’4′,’5’);

======

The above sql outputs the top 5 statement hashes that each of the applications like SLT,Studio,ABAP,WebIntelligence etc along with the number of times it was executed in HANA DB based on the data available in M_EXPENSIVE_STATEMENTS .

If you want to find out the SQL associated with these statement hashes refer my below blog for more details.

https://blogs.sap.com/2020/09/16/how-to-find-sql-statement-from-sql-hash/

WARNING:

-The sub sql involved does not segregate between successful and failed statements. If you want to be very specific about checking on only successful statements alone, add an additional clause as ERROR_CODE=0 .For failed statements go for ERROR_CODE ‘0’

eg:

with cte as (select distinct statement_hash, application_name,count(statement_hash) as num, rank() over ( partition by application_name order by count(statement_hash)desc) R from m_expensive_statements where ERROR_CODE =’0′ group by statement_hash,application_name order by application_name desc)

select * from cte where R in (‘1′,’2′,’3′,’4′,’5’);

-If you have no records inside M_EXPENSIVE_STATEMENTS, it means you have not enabled the expensive statement trace .Hence before trying any of the above, ensure that you have enabled the expensive statement trace and with default threshold for memory,cpu and duration such as all the statements that are running in HANA db gets recorded.

Hope it was helpful!! Click on like if you found this article useful and FOLLOW for more such articlesRajarajeswari Kaliyaperuumal

Please leave a comment or suggestion!

,淘客公众号,大数据解决方案,产业云,全球云购,大数据分析
发表评论
验证码: 点击我更换图片

注:网友评论仅供其表达个人看法,并不代表本站立场。

热门文章

  • 海外云服务器_关于_有关物联网的问题
    <strong>海外云服务器_关于_有关物联网的问题</strong>

    海外云服务器_关于_有关物联网的问题

    消费者在哪里?这不是医疗保健领域的"捉迷藏"游戏,而是建立一个全面运转的医疗保健系统所需要的关键缺失要素。让消费者参与进来——作为一个消费...

  • 云视频存储_云主机部署网站
    <strong>云视频存储_云主机部署网站</strong>

    云视频存储_云主机部署网站

    集成/docker/梅索斯/marathonapachemesos是一个用于调度和管理分布式应用程序的开源集群管理器。Mesos几乎就像整个集群是一个单一的集群一样分配CPU和RAM等资源...

  • 分布式数据库_物联网技术应用前景
    <strong>分布式数据库_物联网技术应用前景</strong>

    分布式数据库_物联网技术应用前景

    技术支持副总裁Aileen Wyer和高级系统管理员Maruf Rahman最近与我们坐下来讨论我们的合作伙伴关系如何帮助CAN Capital的遗留备份基础设施现代化,以简化数据管...

  • 云服务器案例_农业物联网技术方案
    <strong>云服务器案例_农业物联网技术方案</strong>

    云服务器案例_农业物联网技术方案

    今天,两位前行业分析师(现在是Veeam高管)讨论了塑造数据保护行业和IT格局的趋势:Jason Buffington@JBuff,前ESG数据保护首席分析师Dave Russell@BackupDave,Ga...

  • 云计算应用_绿色云数据中心
    <strong>云计算应用_绿色云数据中心</strong>

    云计算应用_绿色云数据中心

    Nathan Sielaff,World Vision的系统工程师,负责备份、存储等。他致力于创建一个灵活和敏捷的IT环境,这样组织就不必担心底层基础设施,可以将精力集中在任...

云储存

更多 >
  • 企业网站_泛域名解析_免费申请
    企业网站_泛域名解析_免费申请

    你们中的一些人可能不知道SAP TechEd之前我们的Devtoberfest活动的所有细节,但现在是我喜欢谈论的一个话题Kyma的时候了。具体来说,我们如何让您能够使用...

  • 美国服务器_数据库调用_优惠
    美国服务器_数据库调用_优惠

    SAP Business Application Studio最近在Azure、AWS、阿里巴巴云上向客户发布。 了解更多有关SAP Business Application Studio的信息:一个中心博客,提供有用信息或博客文...

云储存轻量服务器_云虚拟主机怎么用_超低折扣
云储存腾讯云_市网站建设_价格
云储存云存储_分布式图片存储_评分榜
云储存分布式存储_cdn啥意思_稳定性好
云储存亚马逊云_企业邮箱在哪里登陆_便宜的