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 vote158 views1 answer
Alter table change default
SQL
0 vote135 views1 answer
Clear query cache sql server
SQL
-1 vote158 views1 answer
Adding a new table psql
SQL
0 vote139 views1 answer
Soql more than today
SQL
2 votes146 views1 answer
Sql column values comma separated
SQL
0 vote182 views1 answer
Mariadb used space
SQL
1 vote160 views1 answer
Delete specific row in sql
SQL
2 votes136 views1 answer
Postgresql left join distinct on
SQL
1 vote154 views1 answer
Declare variables sql
SQL
0 vote157 views1 answer
Select distinct after join
SQL