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 vote275 views1 answer
Check sql database table lock
SQL
9 votes287 views6 answers
Replace sql
SQL
0 vote297 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
5 votes289 views2 answers
Postgresql insert select
SQL
0 vote281 views1 answer
Mysql workbench indent formatting
SQL
0 vote310 views1 answer
Sqlite trim
SQL
0 vote266 views1 answer
Char varchar nvarchar sql
SQL
0 vote311 views1 answer
Mysql delete entire row on condition
SQL
-1 vote308 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote259 views1 answer
Sql view index
SQL