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 vote231 views1 answer
Mysql get longest string in column
SQL
1 vote223 views5 answers
What is in operator in sql
SQL
2 votes274 views3 answers
How to replace null values in sql
SQL
0 vote209 views1 answer
Rename view mysql
SQL
0 vote238 views1 answer
Ubuntu stop mysql from starting on boot
SQL
7 votes195 views6 answers
Nth highest salary in sql
SQL
1 vote205 views2 answers
Mysql remove first and last character from string
SQL
14 votes237 views6 answers
Finding duplicate rows mysql
SQL
1 vote204 views2 answers
Populate sql table with random data
SQL
0 vote202 views1 answer
Match end of string regex sql
SQL