home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 971 of 2,288   
   buky to All   
   killed session   
   16 Jan 04 09:58:03   
   
   From: _buky_zg@hotmail.com   
      
   I killed a session on a local database using "alter system kill session"   
   command. But, in v$session, there is still a recordsed with that session,   
   marked as killed (db version 9.2.0.1).   
      
   How could I really delete this session, because I think it's causing me some   
   problems?   
      
   Also, how could I know which objects (tables, packages) are locked by some   
   session?   
      
   tnx in advance   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca