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

From: <Mayen.Shah_at_lazard.com>
Date: Tue, 17 Apr 2007 09:10:02 -0400
Message-ID: <OFCA06FB53.1DB4BBCF-ON852572C0.00483FC2-852572C0.0048546A@lazard.com>

Hi Ujang,

What type of lock SMON is holding? Do you use LMT?

Mayen Shah

                                                                                
                                                                                
                                                                                
    "Ujang Jaenudin"                                                         To 
    <ujang.jaenudin_at_g         oracle-l_at_freelists.org                            
    mail.com>                                                                cc 
    Sent by:                                                                    
    oracle-l-bounce_at_f                                                   Subject 
    reelists.org              smon locked sys.fet$ on oracle 816 (unix)         
                                                                                
                                                                                
    Apr 17 2007 08:40                                                           
    AM                                                                          
                                                                                
                                                                                
    Please respond to                                                           
    ujang.jaenudin_at_gm                                                           
         ail.com

dear all,

I have followed metalink suggestion as of Note:68836.1, but when truncate bigtable reuse storage, I
got problem with SMON that hold fet$ dictionary table.

the the server was restarted twice, but it seems to be same, even now i could not issue any DDL
syntaxes.

Now if I issue DDL syntax oracle still inform me that SMON still locking the fet$ table.

please help me up....

--

regards
ujang
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 17 2007 - 08:10:02 CDT