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 vote353 views1 answer
Show per page table in xampp
SQL
0 vote316 views1 answer
How to install Firebird
SQL
0 vote363 views1 answer
Sql get latest of 2 datetimes
SQL
1 vote359 views3 answers
Rename table snowflake
SQL
6 votes388 views2 answers
Foreign key sqlite3 python
SQL
0 vote386 views2 answers
Connect to mysql server mac terminal
SQL
0 vote305 views2 answers
Influxdb delete measurement based on date
SQL
16 votes392 views3 answers
T-SQL Add Column
SQL
19 votes355 views5 answers
Change column name mysql command line
SQL
2 votes368 views1 answer
Orcale index size
SQL