24 lines
535 B
SQL
24 lines
535 B
SQL
-- 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(timestamp#,'MI') minute
|
|
, userid
|
|
, userhost
|
|
, COUNT(*)
|
|
FROM
|
|
sys.aud$
|
|
WHERE
|
|
timestamp# BETWEEN TO_DATE('20101030 18:00', 'YYYYMMDD HH24:MI')
|
|
AND TO_DATE('20101030 19:00', 'YYYYMMDD HH24:MI')
|
|
GROUP BY
|
|
TRUNC(timestamp#,'MI') --minute
|
|
, userid
|
|
, userhost
|
|
ORDER BY
|
|
minute
|
|
, userid
|
|
, userhost
|
|
/
|
|
|