1
--查看oracle现在连接者信息
select username,machine, PROGRAM, count(username) from v$session
where username is not null
group by username, machine, PROGRAM
order by username
2
--查询数据库实例名[SID]
select * from v$instance;
select * from v$parameter2 t order by t.name ;
3
--查询数据库版本信息
select * from v$version
4
--查询oracle server端的字符集
select userenv('language') from dual
5
---表空间使用情况
select a.tablespace_name,total,free,total-free used from
( select tablespace_name,sum(bytes)/1024/1024 total from dba_data_files
group by tablespace_name) a,
( select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space
group by tablespace_name) b
where a.tablespace_name=b.tablespace_name;
6
----查询数据表的列数
select count(1) from user_tab_columns where table_name=upper('jkda_101');
7
--查询多少张表
--oracle某用户下所有表
select count(*) from dba_tables where owner in ('SYS');
--或者当前用户
select count(*) from user_tables;
8