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

Option 1: shut down the database and restart it.

Option 2:

Alter user XXX account lock

SELECT * FROM V$SESSION WHERE USERNAME='LGDB'

Alter system kill session 'xx,xx'drop user xx cascade

(1) check the connection status of users

Select username,sid,serial# from v$session

(2) find the sid, serial and delete the user you want to delete.

Alter system kill session 'xx,xx'drop user xx cascade

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.