Re: Script displaying in a matrix format , how many logs are create p

select substr(to_char(FIRST_TIME,'MM/DD/YY'),1,5),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'00',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'00',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'01',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'01',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'02',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'02',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'03',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'03',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'04',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'04',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'05',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'05',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'06',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'06',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'07',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'07',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'08',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'08',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'09',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'09',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'10',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'10',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'11',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'11',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'12',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'12',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'13',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'13',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'14',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'14',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'15',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'15',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'16',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'16',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'17',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'17',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'18',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'18',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'19',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'19',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'20',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'20',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'21',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'21',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'22',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'22',1,0))),

decode(sum(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'23',1,0)),0,'-',su m(decode(substr(to_char(FIRST_TIME,'HH24'),1,2),'23',1,0))) from sys.v_$log_history
group by substr(to_char(FIRST_TIME,'MM/DD/YY'),1,5) order by substr(to_char(first_time,'MM/DD/RRRR'),1,10) desc;

HTH,

• Original Message ----- From: Hatzistavrou Giannis <j.hatzistavrou_at_telesoft.gr> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, December 13, 2000 11:24 AM Subject: Script displaying in a matrix format , how many logs are create p

> Dear All,
>
> I used to have a scipt that displayed in a matrix format how many logs
where
> created per hour . Does anybody of you have such a script to share?
>
>
> Thanks.
>
>
> Hatzistavrou Yannis
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Hatzistavrou Giannis
> INET: j.hatzistavrou_at_telesoft.gr
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).