Re: process M000 holds library cache lock
- From: Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
- To: De DBA <dedba@xxxxxxxxxx>
- Date: Wed, 28 Mar 2012 15:55:50 +0200
as a summary for this post:
we started with killing M000 and this went well, but the next run of
M000 repeated the hold of library cache mutex (so we were again in the
same position) - then the only option was to restart and with still
decreasing performance we did it, which helped of course
Regards
Remigiusz
W dniu 28.03.2012 15:50, De DBA pisze:
> Hi Remigiusz,
>
> Most likely nothing else than a restart of the process. It is a slave
> process of mmon. As my test instance has no m000 at the moment, I just
> killed mmon to prove the point.. :-)
>
> This is what happened:
>
> $ pgrep -lf mmon_TST2
> 14079 ora_mmon_TST2
> $ sudo kill -9 14079
> [sudo] password for lingent:
> $ pgrep -lf
> mmon_TST2 # MMON
> on the TST2 instance is dead
> $ tail /u00/oracle/diag/rdbms/tst2/TST2/trace/alert_TST2.log
> Starting background process VKRM
> Wed Mar 28 22:00:00 2012
> VKRM started with pid=21, OS id=20915
> Wed Mar 28 22:00:30 2012
> Thread 1 advanced to log sequence 59 (LGWR switch)
> Current log# 2 seq# 59 mem# 0: /u00/oracle/oradata/TST2/redo02.log
> Wed Mar 28 23:42:02 2012
> *Restarting dead background process MMON* # It's
> dead has been noticed by the instance
> Wed Mar 28 23:42:02 2012
> MMON started with pid=15, OS id=22229 #
> mmon is restarted.8-)
> $ pgrep -lf mmon_TST2
> 22229 ora_mmon_TST2
>
> Since brutally killing mmon has as only effect that it is restarted, I
> would conclude that any slaves of it can be safely killed as well...
> (but maybe others have one that they can kill to test)
>
> Hth,
> Tony
>
>
> On 28/03/12 18:47, Remigiusz Sokolowski wrote:
>> hi,
>>
>> anyone tried to kill M000 - what are possible implications?
>> Will the instance die?
>> It just took library cache mutex (X) and holds for very considerable
>> amount of time.
>>
>> Regards
>> Remigiusz
>
--
Pole nakazi
----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos : DBA at DIiUSI
addr : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem:
0000021828,
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku,
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego,
o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych,
NIP: 586-000-78-20, REGON: 190024711--
//www.freelists.org/webpage/oracle-l
Other related posts:
