Caught user

[sam.surf]

Hello everyone ....

I have a problem here, I have a base rolling Oracle 9i, there is a user who is locking the base, and I can not knock down via alter system kill, someone can suggest me Another way, logic that without giving a reboot at the logical base !!!!!!


I await contact .....

[dr_gori]

Well, I use:

Select all

ALTER SYSTEM DISCONNECT SESSION '36,30483' immediate;

and 36 is the SID
and the 30483 is the serial, found in the V $ session .

Is that what you did?

[sam.surf]

That's right ... but the user does not fall ... remains locked ....