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

  • From: Mayen.Shah@xxxxxxxxxx
  • To: ujang.jaenudin@xxxxxxxxx
  • Date: Tue, 17 Apr 2007 09:10:02 -0400

Hi Ujang,

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

Mayen Shah



                                                                                
                                                                                
                                                                                
    "Ujang Jaenudin"                                                         To 
    <ujang.jaenudin@g         oracle-l@xxxxxxxxxxxxx                            
    mail.com>                                                                cc 
    Sent by:                                                                    
    oracle-l-bounce@f                                                   Subject 
    reelists.org              smon locked sys.fet$ on oracle 816 (unix)         
                                                                                
                                                                                
    Apr 17 2007 08:40                                                           
    AM                                                                          
                                                                                
                                                                                
    Please respond to                                                           
    ujang.jaenudin@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
--
//www.freelists.org/webpage/oracle-l





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


Other related posts: