oracle 表解锁sql
Select p.Spid, c.Object_Name, b.Session_Id, b.Oracle_Username, b.Os_User_Name From V$process p, V$session a, V$locked_Object b, All_Objects c Where p.Addr = a.Paddr And a.Process = b.Process And c.Object_Id = b.Object_Id And c.object_name = ‘’;kill掉Session_Id即可[@more@]
FRM-41839: Disk I/O error on temporary record buffer file
原因:是Var/Tmp目录的空间用完了[@more@]