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

From: jametong <jametong_at_gmail.com>
Date: Tue, 17 Apr 2007 21:48:58 +0800
Message-ID: <4624d05f.46f6be36.6da1.3122@mx.google.com>

two possibilities:

1. smon coalesce sequetial segments
2. you have done a cancel a big segments,(eg: create table ). smon to do the undo.

Jametong  

DBA Team. B2B. 阿里巴巴中国

---

Phone   : 0571-85022088-12372
Fax     : 0571-85022958
Mobile  : 135-8803-9828
Mail    : jame.tongjw_at_alibaba-inc.com
          jametong_at_gmail.com
Msn     : kt_tongjiawang_at_hotmail.com
Yahoo   : jametong

Alitalk : jametong
Skype : jametong

---

-----邮件原件-----

发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代 表 Ujang Jaenudin
发送时间: 2007年4月17日 20:41
收件人: oracle-l_at_freelists.org
主题: smon locked sys.fet$ on oracle 816 (unix)

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:48:58 CDT