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

0 vote201 views1 answer
Oracle cpu metric
SQL
0 vote188 views1 answer
Get duplicate entry sql
SQL
0 vote208 views1 answer
Change database name psql 8
SQL
0 vote204 views1 answer
Dbms_output sql developer
SQL
2 votes201 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote190 views1 answer
Check mysql password with docker container magento 2
SQL
8 votes196 views1 answer
Oracle add months to sysdate
SQL
2 votes211 views1 answer
Create mysql user on all hosts
SQL
0 vote188 views1 answer
Sql roll up rows into columns
SQL
7 votes202 views2 answers
Mysql default value
SQL