Oralce stops running and cannot be solved

Oralce stops running and cannot solve the problem. First, find "session" in the plsql tool ", you can check that the sid corresponds to "ACTIVE" to check which program is run in SQL text. 1 \ -- Query sid select * from v $ session t1, v $ locked_object t2 where t1.sid = t2.SESSION _ ID; 2 \ -- Query spid select s. sid, spid, osuser, s. program from v $ process p, v $ session s where p. addr = s. paddr and s. sid = 26; 3 \ -- unlock -- Unlock under dos (under dos) orakill zzdb19 (database) 8068 (spid) ---- unlock kill-9 (spid) under linux) -- check where the program runs select B. * from v $ session a, v $ sqlarea B where. SQL _hash_value = B. hash_value and. sid = 33