--查看不同用户的连接数
select TERMINAL from v$session where username='username' and machine='machine'
---查询用户会话
select username,serial#, sid from v$session where sid='sid';
---删除相关用户会话
alter system kill session 'serial#, sid '
例如删除PCISV7_DEV用户下机器号为ISS460602001667的会话
1、查看用户对应的sid--,得到sid='367'
select TERMINAL from v$session where username='PCISV7_DEV' and machine='ISS460602001667';文章地址https://www.yii666.com/article/332467.html文章来源地址:https://www.yii666.com/article/332467.html
2、对应sid,获得对应的serial#--得到serial='26820'
网址:yii666.comselect username,serial#, sid from v$session where sid='367';
3、通过sid和serial#,删除对应会话
alter system kill session '26820, 367 ';
查看所有包含某字段的表
select * from all_tab_cols t where t.column_name='字段名';
查看所有表修改情况
select object_name, created,last_ddl_time from user_objects order by last_ddl_time desc;