PL/SQL (MOSC)

MOSC Banner

Archive log count per day

edited Jun 28, 2023 3:58PM in PL/SQL (MOSC) 2 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center