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

5 votes272 views2 answers
Mysql where in array
SQL
1 vote298 views1 answer
Ubuntu access database from terminal
SQL
0 vote313 views1 answer
Oracle swap partition
SQL
3 votes322 views5 answers
Sql select
SQL
5 votes312 views2 answers
Oracle find all tables with column name
SQL
0 vote292 views1 answer
Grepper sql workbench download
SQL
49 votes341 views6 answers
Get duplicate records in sql
SQL
0 vote330 views1 answer
Add user mysql wordpress
SQL
1 vote315 views1 answer
Myql find duplicates
SQL
-1 vote282 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL