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 vote257 views1 answer
Sql into vs insert into
SQL
0 vote250 views1 answer
Sql convert datetime to year
SQL
0 vote318 views1 answer
Intellij mysql set timezone
SQL
13 votes270 views3 answers
Insert mysql ifile nto database
SQL
2 votes253 views1 answer
Oracle sql day of month from date
SQL
0 vote251 views4 answers
Database stuck at restoring state
SQL
104 votes418 views2 answers
Like in mysql
SQL
0 vote274 views1 answer
Get primary key of table
SQL
0 vote262 views1 answer
Mysql in clausule string array
SQL
2 votes266 views1 answer
Oracle kill session by sql_id
SQL