Re: MMNL absent during shutdown immediate
- From: Peter Hitchman <pjhoraclel@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Apr 2013 12:13:07 +0100
Hi
Is this bug 14213856?
I guess the workaround is to do a checkpoint and then an abort.
Regards
Pete
On 12 April 2013 17:55, Ray Stell <stellr@xxxxxx> wrote:
> WIth 11.2.0.3 on OL 5.9 we are experiencing some long delays during
> shutdown immediate. I did a 10046 trace as suggested in 164504.1
> on a shutdown immediate and the wait all with this MMNL process going AWOL:
>
> *** 2013-04-12 07:21:19.315
> WAIT #47711582838936: nam='rdbms ipc reply' ela= 149 from_process=7
> timeout=2147483647 p3=0 obj#=-1 tim=1365765679315276
> XCTEND rlbk=0, rd_only=1, tim=1365765679315850
> MMNL absent for 1304 secs; Foregrounds taking over
>
> this was a rather short wait, only 20 minutes as some have been much
> longer. Is there something I can do to make this wait/shutdown
> cleaner/shorter?
> I see this has been an issue for awhile via google, but I don't see any
> fix besides an abort. This is an interesting observation:
> http://www.runningoracle.com/product_info.php?products_id=386
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Regards
Pete
--
//www.freelists.org/webpage/oracle-l
Other related posts:
