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 vote308 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote311 views1 answer
Alter table name including schema
SQL
1 vote305 views1 answer
Sql try catch
SQL
0 vote326 views1 answer
Mysql make date from 2 column
SQL
0 vote303 views1 answer
2020 new year
SQL
1 vote327 views1 answer
Where date = max(date) in sql
SQL
1 vote317 views1 answer
Postgres convert date to string
SQL
0 vote328 views1 answer
How we can perform acid Operations in sql with examples
SQL
24 votes342 views6 answers
Replace mysql
SQL
5 votes342 views1 answer
Add column table sql default value
SQL