Oracle相关查询

select * from TBEMPLOYEEINFO for update nowait

edit TBEMPLOYEEINFO

select rowid,e.* from TBEMPLOYEEINFO e

select * from v$lock;

select * from v$locked_object;

select * from all_tables where owner='YZD7' --等价于select * from user_all_tables

/* Formatted on 2011/08/30 10:17 (Formatter Plus v4.8.8) */
SELECT object_name
  FROM dba_objects
 WHERE owner = 'YZD7' AND object_type = 'TABLE'
 
 
select * from user_objects

select name from v$database --查询当前情况下有哪些数据库

select username,default_tablespace from dba_users order by username

select * from user_all_tables --查询当前用户下的有哪些表及相关情况
select tabtype, count(*) from tab group by tabtype;

select * from user_source --查询所有函数和储存过程

select * from all_users;--查询所有用户
select * from dba_users; --查询所有用户

select * from v$Session --查看当前用户连接

select * from session_privs --查看当前用户权限

--查看用户表空间使用情况：
　select a.file_id "FileNo",a.tablespace_name

　　"Tablespace_name",

　　a.bytes "Bytes",a.bytes-sum(nvl(b.bytes,0)) "Used",

　　sum(nvl(b.bytes,0)) "Free",

　　sum(nvl(b.bytes,0))/a.bytes*100 "%free"

　　from dba_data_files a, dba_free_space b

　　where a.file_id=b.file_id(+)

　　group by a.tablespace_name ,

　　a.file_id,a.bytes order by a.tablespace_name;
-------------------------------------------------

select * from dba_tab_columns where owner='YZDGD'


sys_param


select username,default_tablespace,temporary_tablespace from dba_users order by username