Archive log count per day
Hi,
On 11.2.0.4
I run this:
select to_char(first_time, 'mm/dd/yy hh24:mi:ss') from v$archived_log where first_time > sysdate -2;
Which gives:
TO_CHAR(FIRST_TIM
06/27/23 02:18:48
06/27/23 11:04:28
06/27/23 11:04:29
06/27/23 11:05:31
06/27/23 11:05:31
06/27/23 11:44:19
06/28/23 02:17:26
06/28/23 02:17:27
06/28/23 02:17:53
06/28/23 02:17:53
10 rows selected
I wish group by them to have count for each day. For example:
First_time count
---------- ---------
06/27/23 6
06/28/23 4
How to have that?
Thanks.