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

9 votes254 views4 answers
How to alter table column name in mysql
SQL
7 votes236 views6 answers
Group_concat mysql
SQL
0 vote259 views1 answer
Sql with example
SQL
0 vote245 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote273 views2 answers
Insert data mysql with cmd
SQL
0 vote246 views1 answer
OFFSET consulta mysql
SQL
8 votes194 views1 answer
Similarities between ddl and dml
SQL
7 votes242 views3 answers
Convert ansi sql
SQL
1 vote234 views1 answer
Grab all records from one table to another oracle sql
SQL
4 votes249 views4 answers
Start mysql
SQL