Oracle when other,ORA-12721: operation cannot execute when other sessions are active — oracle-tech

Thank you Aman, but Why this error when DB is opened in restrict mode and I'm the only user ?

SQL> select sid, serial#,program ,status from v$session;

SID SERIAL# PROGRAM STATUS

---------- ---------- ------------------------- --------

151 4 OMS INACTIVE

152 14 OMS ACTIVE

155 459 OMS INACTIVE

156 1 ORACLE.EXE (ARC1) ACTIVE

157 63 ORACLE.EXE (ARC0) ACTIVE

158 93 OMS KILLED

159 5 sqlplus.exe ACTIVE

160 5 ORACLE.EXE (MMNL) ACTIVE

161 3 ORACLE.EXE (MMON) ACTIVE

162 3 ORACLE.EXE (CJQ0) ACTIVE

163 1 ORACLE.EXE (RECO) ACTIVE

SID SERIAL# PROGRAM STATUS

---------- ---------- ------------------------- --------

164 3 ORACLE.EXE (SMON) ACTIVE

165 1 ORACLE.EXE (CKPT) ACTIVE

166 3 ORACLE.EXE (LGWR) ACTIVE

167 1 ORACLE.EXE (DBW0) ACTIVE

168 3 ORACLE.EXE (MMAN) ACTIVE

169 3 ORACLE.EXE (PSP0) ACTIVE

170 1 ORACLE.EXE (PMON) ACTIVE

18 rows selected.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值