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 vote329 views1 answer
Oracle synonym procedure dblink
SQL
7 votes353 views1 answer
Sql server management studio turn on line numbers
SQL
12 votes309 views4 answers
SQL Where
SQL
0 vote348 views1 answer
Compare two tables to find unmatched records
SQL
0 vote467 views1 answer
Postgresql powershell query
SQL
0 vote369 views1 answer
Python sql last insertend
SQL
0 vote330 views1 answer
Sqlite update where exists
SQL
0 vote361 views1 answer
Sql update subtract value
SQL
9 votes351 views5 answers
Laravel to sql
SQL
1 vote355 views1 answer
Write a query to create an empty table from an existing table?
SQL