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 vote233 views1 answer
Python sql last insertend
SQL
0 vote212 views1 answer
Sql max min
SQL
0 vote225 views1 answer
How to get specific salary in sql
SQL
0 vote208 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
1 vote217 views2 answers
Drop function in sql
SQL
0 vote223 views2 answers
How to tun mysql on ubunto
SQL
13 votes216 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes204 views1 answer
Oracle create directory
SQL
5 votes204 views2 answers
Oracle show procedures
SQL
-1 vote263 views2 answers
Mysql get day of week
SQL