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 vote161 views1 answer
Xampp import sql file command line
SQL
2 votes190 views4 answers
How to find 2nd highest salary in mysql
SQL
10 votes175 views2 answers
SQL rounding numbers
SQL
3 votes186 views1 answer
Oracle function return
SQL
0 vote166 views1 answer
Mysql workbench view
SQL
0 vote162 views1 answer
Query on date sqlite flutter
SQL
0 vote177 views1 answer
Sql find record cannot cast date
SQL
0 vote180 views2 answers
Timing sql queries
SQL
0 vote170 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
2 votes189 views3 answers
Sql server: how to concatenate column data using comma
SQL