Find Hourly Archival Generation for a given day

Find Hourly Archival Generation for a given day in a Oracle Database instance ----------------------------------------------------------------------------- set linesize 1000 pagesize 10000 alter session set nls_date_format='dd-mon-yyyy hh24:mi:ss'; select round(FIRST_TIME,'hh') ,count(distinct THREAD#||SEQUENCE#),sum(blocks*BLOCK_SIZE)/1024/1024/1024 from v$archived_log where first_time >=trunc(<>) group by round(FIRST_TIME,'hh') order by 1 asc;

Find files that we have in Diskgroup in Oracle ASM

How to find the files that we have in Diskgroup in Oracle ASM -Source: Oracle Metalink -------------------------------------------------------------------------------- select * from (SELECT level, dir, sys, substr(lpad(' ',2*level,' ')||CONCAT('+'||gname, SYS_CONNECT_BY_PATH(aname,'/')),1,60) full_path FROM ( SELECT g.name gname, a.parent_index pindex, a.name aname, a.reference_index rindex, a.ALIAS_DIRECTORY dir, a.SYSTEM_CREATED sys FROM v$asm_alias a, v$asm_diskgroup g WHERE a.group_number = g.group_number) START WITH (MOD(pindex, POWER(2, 24))) = 0 CONNECT BY PRIOR rindex = pindex ORDER BY rtrim(ltrim(full_path))desc, level asc) where upper(full_path) like '%<>%'