Re: smon locked sys.fet$ on oracle 816 (unix)

From: <Mayen.Shah_at_lazard.com>
Date: Tue, 17 Apr 2007 09:58:23 -0400
Message-ID: <OFDC8E7FBC.D64C3BE4-ON852572C0.004CBAC9-852572C0.004CC1F2@lazard.com>

Most probably SMON is coalescing free extents after that truncate. This will be the case if you are not using LMT (I do not know if you are using LMT or not). If you are not using LMT and SMON is holding ST lock, you may set event no : 10269 (please confirm with Oracle support) to skip coalescing by SMON. Coalesce manually when database is not loaded and please convert to LMT.

Good luck.
Mayen Shah

                                                                                
                                                                                
                                                                                
    "Ujang Jaenudin"                                                         To 
    <ujang.jaenudin_at_g         Mayen Shah/ITS/Lazard_at_Lazard NYC                  
    mail.com>                                                                cc 
                              oracle-l_at_freelists.org,                           
    Apr 17 2007 09:53         oracle-l-bounce_at_freelists.org                     
    AM                                                                  Subject 
                              Re: smon locked sys.fet$ on oracle 816 (unix)

On 4/17/07, Mayen.Shah_at_lazard.com <Mayen.Shah_at_lazard.com> wrote:
>
> Hi Ujang,
>
> What type of lock SMON is holding? Do you use LMT?
>
> Mayen Shah
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 17 2007 - 08:58:23 CDT