19 lines
470 B
MySQL
19 lines
470 B
MySQL
|
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
||
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
||
|
|
|
||
|
|
SELECT
|
||
|
|
TRUNC(sample_time,'MI') minute
|
||
|
|
, sql_plan_hash_value
|
||
|
|
, COUNT(*)/60 avg_act_ses
|
||
|
|
FROM
|
||
|
|
v$active_session_history
|
||
|
|
-- dba_hist_active_sess_history
|
||
|
|
WHERE
|
||
|
|
sql_id = '&1'
|
||
|
|
GROUP BY
|
||
|
|
TRUNC(sample_time,'MI')
|
||
|
|
, sql_plan_hash_value
|
||
|
|
ORDER BY
|
||
|
|
minute, sql_plan_hash_value
|
||
|
|
/
|