Home » RDBMS Server » Server Administration » Query to find count of executions hourly for the last 30 days (merged) (Oracle Enterprise Edition, 11.2.0.4, Oracle Linux X86-64, version 5)
Query to find count of executions hourly for the last 30 days (merged) [message #677605] Mon, 30 September 2019 12:55 Go to previous message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
Hi,

I am trying to find a particular sql (using sql id) executions hourly and daily counts for the last 30 days. Can anyone has command please?

I have tried with dba_hist_active_sess_history and dba_hist_sqlstat for the last 1 hour to test if it gives correct result. But the output doesn't match with sum of counts in each instance taken from awrsqlrpt.sql

Thanks,
Suresh

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how are the bits in ASSM calculated?
Next Topic: DB12.1 upgrades
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 23:43:49 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.