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

1 vote157 views1 answer
Unique vs distinct sql
SQL
0 vote176 views1 answer
Metada in sql
SQL
0 vote187 views1 answer
Output table plsql
SQL
0 vote181 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
8 votes192 views1 answer
Oracle create datafile
SQL
3 votes225 views2 answers
Sqlite show table definition
SQL
1 vote189 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote216 views1 answer
Oracle execute package dblink
SQL
1 vote199 views1 answer
Mysql return if it contains
SQL
0 vote209 views1 answer
Function plsql
SQL