oracle常见问题

1.获取有哪些用户在使用数据库：select * from v$session

2.查数据库sid:select name from v$database

3.在Oracle服务器上通过SQLPLUS查看本机IP地址:select sys_context('userenv','ip_address') from dual;

4.查询每个用户的权限：SELECT * FROM DBA_SYS_PRIVS

 5.查询当前用户对像:SELECT * FROM USER_OBJECTS; 　　SELECT * FROM DBA_SEGMENTS

6.获取错误信息:SELECT * FROM USER_ERRORS

7.查看ORACLE中有哪些程序在运行之中:查看v$sessions表

8.查询某天的数据：select * from table_name where trunc(日期字段)＝to_date('2003-05-02','yyyy-mm-dd');

9.察看控制文件select name from v$controlfile

10察看日志文件select member from v$logfile

11察看还没有提交的事务select * from v$locked_object;select * from v$transaction;