Re: Weird database hanging

I ran a similar query to give all sums by event and minute from 11:15 to 11:45 (the alert log items first popped up at 11:23).

http://pastebin.com/m426111d8

Much thanks in advance!

Don.

On 9/14/07, Jeremiah Wilton <jeremiah_at_ora-600.net> wrote:
> Don,
>
> Can we see the following?
>
> select event, sum(time_waited) tw
> from dba_hist_active_sess_history
> where to_char(sample_time,'yyyy-mm-dd hh24:mi')='<first minute of problem>
>
> Please also provide this for the two or three minutes preceding the
> problem, and a minute with no problems from well before the issue. When
> finding the first minute, it is important you find the first minute when
> things were not looking normal in dba_hist_active_sess_history, not
> necessarily the first minute things were noticeably bad on the database.

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l