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 vote201 views1 answer
Search for tables with name postgresql
SQL
0 vote199 views3 answers
How to increase size of column in sql
SQL
3 votes189 views1 answer
Oracle rollback
SQL
1 vote189 views3 answers
How to filter repeated same result using sql query
SQL
1 vote189 views1 answer
User privileges postgresql information_schema
SQL
1 vote193 views1 answer
Oracle first row
SQL
0 vote177 views2 answers
Postgresql create role
SQL
1 vote201 views1 answer
Mysql show queries running
SQL
1 vote267 views1 answer
Postgres select as csv
SQL
1 vote208 views1 answer
Oracle create index if not exists
SQL