Oracle archivelog usage

WITH hours AS (
    SELECT trunc(sysdate) + ((LEVEL - 1) / 24) AS HOURS
    FROM DUAL
    CONNECT BY LEVEL < = 24
)
SELECT h.HOURS AS DATE_HOUR,
    round(sum(BLOCKS * BLOCK_SIZE) / 1e9, 2) SIZE_GB
FROM hours h
    LEFT OUTER JOIN V$ARCHIVED_LOG al ON h.HOURS = trunc(al.FIRST_TIME, 'HH24')
GROUP BY h.HOURS
ORDER BY h.HOURS;

Similar codes

5 votes77 views1 answer
Mongodb vs
SQL
-1 vote130 views3 answers
PS5
SQL
0 vote117 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
2 votes163 views2 answers
Postgres drop column if exists
SQL
0 vote138 views1 answer
What is common table expression in sql
SQL
0 vote126 views1 answer
Grant owner postgresql
SQL
3 votes116 views2 answers
Postgresql remove not null constraint
SQL
0 vote124 views1 answer
How to get first 10 records of a table in mysql
SQL
5 votes109 views2 answers
Oracle timestamp to date
SQL
2 votes70 views2 answers
Mysql get last character of string
SQL