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 vote134 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
22 votes115 views3 answers
Sql cheat sheet
SQL
1 vote116 views1 answer
Mysql limit results to 10
SQL
1 vote116 views1 answer
Mysql select month and year
SQL
0 vote120 views1 answer
Oracle gather table statistics
SQL
1 vote76 views1 answer
Sql convert month name to number
SQL
6 votes165 views3 answers
Psql show columns of table
SQL
11 votes114 views2 answers
Insert current date sql
SQL
0 vote123 views1 answer
Delete duplicate rows
SQL
-1 vote127 views2 answers
Postgres autoincrement primary key
SQL