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 vote327 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
3 votes335 views2 answers
Create schema postgres
SQL
0 vote271 views1 answer
Denied
SQL
16 votes345 views2 answers
Mysql date between two dates
SQL
0 vote418 views1 answer
How to show current database in mysql
SQL
0 vote322 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote314 views1 answer
Create a PostgreSQL user django on mac
SQL
2 votes331 views1 answer
Postgresql create schema in specific database
SQL
0 vote344 views1 answer
Sql server alter table add column tinyint
SQL
0 vote362 views1 answer
Sql sort ages
SQL