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

3 votes345 views1 answer
Make a field auto_increment mysql
SQL
0 vote372 views1 answer
Python connect to mysql in settings.py
SQL
0 vote423 views3 answers
How to find all role in mysql
SQL
1 vote374 views2 answers
Get table column names sql laravel
SQL
1 vote348 views1 answer
Mysql connect command
SQL
1 vote380 views1 answer
Convert epoch to date in sql server
SQL
2 votes313 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote368 views1 answer
Sql getdate minus 1 day without time
SQL
7 votes372 views1 answer
Sql limit decimal places
SQL
1 vote306 views1 answer
Unique vs distinct sql
SQL