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 vote284 views1 answer
Sql eliminare un record
SQL
6 votes289 views5 answers
Sql add months to date
SQL
0 vote318 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
12 votes299 views3 answers
Install sqlite driver ubuntu
SQL
0 vote287 views1 answer
Vbscript clean up ADODB.Recordset
SQL
11 votes300 views4 answers
MYSQL LOGIN
SQL
0 vote301 views1 answer
Where date major today mysql
SQL
2 votes290 views1 answer
How to create sql database
SQL
0 vote308 views5 answers
Mode sql course
SQL
0 vote309 views1 answer
Openquery update linked server
SQL