Re: Weird database hanging
- From: "Don Seiler" <don@xxxxxxxxx>
- To: "Jeremiah Wilton" <jeremiah@xxxxxxxxxxx>
- Date: Fri, 14 Sep 2007 16:54:00 -0500
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@xxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
