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

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 17 Apr 2007 19:40:38 +0700

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

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

please help me up....


Other related posts: