If, as is shown in the original can be normal use after the execution of the lightning icon lit up, ready to break
After 2 days before the computer power is now a bit execution is stuck, want to interrupt cannot interrupt,
To turn a great god how to restore the original way!


Reshipment I tried!

CodePudding user response:

That has been performed, what are you doing to interrupt

CodePudding user response:

Probably the deadlock
Method 1, open the tools - sessions and then see the locks in the following, take a look at what data is locked, right-click the kill off
Method 2, first find a deadlock session ids,
The select sess. Sid,
Sess. Serial#,
Lo oracle_username,
Lo os_user_name,
Ao object_name,
Lo locked_mode,
Sess. Machinefrom v $locked_object lo,
Dba_objects ao,
V $session sess the where ao. Object_id=lo. Object_id and lo. Session_id=sess. Sid.

Kill the corresponding process:

The alter system kill session '738142'.