ORACLE故障案例
-
编辑 删除
死锁检查及处理
查看有哪些表被锁住select b.owner,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects bwhere b.object_id = a.object_idselect b.username,b.sid,b.serial#,logon_timefrom v$locke...
-
编辑 删除
WARNING: inbound connection timed out (ORA-3136)错误分析
1.set INBOUND_CONNECT_TIMEOUT_<listenername>=0 in listener.ora 2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.3. stop and start both listener and database.4. Now try to...
