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

3 votes183 views4 answers
Mysql decimal
SQL
0 vote164 views4 answers
Sql limit 1 offset 1
SQL
0 vote200 views1 answer
Sql examples from framework
SQL
0 vote180 views1 answer
Sql convert datetime to year
SQL
0 vote144 views1 answer
Flask_sqlalchemy install
SQL
0 vote191 views1 answer
Replace content value from old to new sql
SQL
0 vote195 views1 answer
Copy data from one postgres container to another
SQL
0 vote178 views1 answer
Postgres call view
SQL
0 vote237 views1 answer
Get initials name in sql
SQL
0 vote185 views1 answer
Sql select non unique
SQL