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

6 votes349 views2 answers
Mysql timestamp to date
SQL
0 vote320 views1 answer
TSQL function split string
SQL
1 vote335 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote308 views1 answer
Selects all the columns from the sailors table
SQL
6 votes355 views2 answers
Postgresql database url
SQL
0 vote344 views2 answers
Suse stop MySQL
SQL
2 votes343 views4 answers
2nd highest salary in mysql
SQL
0 vote321 views1 answer
How to avoid duplicate records in sqlite
SQL
6 votes327 views1 answer
What is where clause in sql
SQL
0 vote317 views1 answer
Mysql database is not starting in xampp
SQL