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

2 votes160 views1 answer
Removing view
SQL
1 vote203 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
4 votes149 views6 answers
List all tables in postgres
SQL
37 votes143 views3 answers
Postgresql insert column
SQL
0 vote128 views2 answers
How to start postgresql laravel
SQL
21 votes144 views5 answers
Oracle all tables
SQL
0 vote153 views1 answer
Sql server roles and users
SQL
0 vote137 views1 answer
Psql attribute cannot login
SQL
0 vote168 views1 answer
Convert LDAP Epoch to Date
SQL
1 vote139 views1 answer
Drush sql-dump
SQL