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 vote244 views1 answer
Mysql print variable
SQL
0 vote239 views4 answers
First max salary in sql
SQL
2 votes263 views3 answers
Xampp mysql database not starting
SQL
15 votes222 views7 answers
MYSQL
SQL
0 vote244 views1 answer
Mysql trigger to delete old data
SQL
0 vote219 views1 answer
Mysql error codeigniter
SQL
6 votes228 views1 answer
To count number of rows in SQL table
SQL
0 vote252 views1 answer
How to find symmetric pairs in sql
SQL
24 votes239 views4 answers
Mysql datetime
SQL
1 vote233 views1 answer
Mysql strict_trans_tables
SQL