sys用户的操作
oracle中查找某个表属于哪个用户?
select owner from dba_tables where table_name=upper('t_l_tradelist' ) 1 NAC_USER
oracle中查询某个视图属于哪个用户?
select owner from all_views where view_name=upper('user_tab_columns' ) 1 SYS
显示当前所属实例:
select instance_name from v$instance;
显示当前实例参数:
show parameter instance
查询数据库各服务的数据连接数
select count (*),program from v$session group by program;
select count (*) from v$session;