Shulou(Shulou.com)06/01 Report--

The reason that the database object cannot DROP is that the object is being executed, and the other is that the resource is not released after the object execution.

The first case is to cancel or pause calls to objects that may be deleted.

In the second case, kill a session in oracle using the following statement:

SQL > conn / as sysdba

Connected.

View information about locked objects.

SQL > select * from v$locked_object

Execute the following SQL to find out the locked session and record the value of b.PIDreb.SPID

Select a.sidjijie a.serialrecording b where username is not null and a.paddr a.paddr.usernameauthora.statusdiary b.PIDreb. SPID from v$session aMagna vandalism process b where username is not null and a.paddr = b.addr

Delete locked object Session

Alter system kill session 'a.sidsid1 a. Serialkeeper'

Finally, kill the process with kill-9 b.spid in the unix environment and orakill sid spid in the windows environment

Ladies and gentlemen. Please add. Thank you.

You can also take a look at the introduction to database locks: http://blog.itpub.net/787018/viewspace-628986/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.