Re: smon locked sys.fet$ on oracle 816 (unix)
- From: Mayen.Shah@xxxxxxxxxx
- To: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- Date: Tue, 17 Apr 2007 09:58:23 -0400
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@g Mayen Shah/ITS/Lazard@Lazard NYC
mail.com> cc
oracle-l@xxxxxxxxxxxxx,
Apr 17 2007 09:53 oracle-l-bounce@xxxxxxxxxxxxx
AM Subject
Re: smon locked sys.fet$ on oracle 816 (unix)
ST
On 4/17/07, Mayen.Shah@xxxxxxxxxx <Mayen.Shah@xxxxxxxxxx> wrote:
>
> Hi Ujang,
>
> What type of lock SMON is holding? Do you use LMT?
>
> Mayen Shah
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
