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 vote110 views1 answer
Convert polygon to text in mysql
SQL
0 vote128 views1 answer
Select count concat string sql server
SQL
2 votes127 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote56 views1 answer
Full text index mysql
SQL
1 vote98 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
0 vote100 views1 answer
Mysql jdbc timezone
SQL
0 vote92 views1 answer
Import sql mysql ubuntu
SQL
0 vote101 views1 answer
Convert sql server guid to varbinary
SQL
6 votes105 views3 answers
Mysql create database utf8
SQL
0 vote114 views1 answer
How to reset the database value in SQL server
SQL