>Regards, >Paul Wakefield >BRIDON ict >information & communication technology >tel : 01302 382 300 >_ >This email has been scanned for all viruses by the MessageLabs Email >Security System on behalf of BRIDON International. >From: “Paul Wakefield via oracle-db-l” >Reply-To: >To: ahmed hazzaf >Subject: killed sessions not releasing locks >Date: Thu, 09:26:32 -0000 ># Manipulating Oracle Files with UTL_FILE ># Read Paper: ># View Group Archive: >hi…we are having an problem with sessions we kill via pl/sql developer >and >sqlplus not releasing locks they have on tables, even though the session is >flagged as killed….has anyone else had this problem? we are running >oracle9i…any suggestions would be a great help, it seems we have to >bounce >the database to clear these locks when they happen. It must work but if you still have problem there is another solution using v$process 1-select SID,SERIAL# from v$session where SID in (select SID from v$access where OBJECT like ‘%OBJECT_NAME%’) Ģ- conn alter system kill session ‘SID,SERIAL#’
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |