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 vote131 views1 answer
Mariadb maximum left join
SQL
0 vote156 views1 answer
Truncate a table then insert data
SQL
0 vote128 views1 answer
Order by monthly in sql
SQL
0 vote126 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
19 votes136 views5 answers
Change column name mysql command line
SQL
0 vote159 views1 answer
Check constraint is violated
SQL
2 votes135 views1 answer
Mysql select random id from table
SQL
27 votes155 views6 answers
Set password mysql
SQL
0 vote142 views2 answers
Sql query in dax power bi
SQL
-1 vote145 views1 answer
Sql set max value in column
SQL