• 查看當(dāng)前在用DB的用戶
• 查看用戶正在執(zhí)行的語(yǔ)句
• 查看鎖住的語(yǔ)句
• 查看用戶在那個(gè)機(jī)器鏈接進(jìn)來(lái)
• 查看哪個(gè)Session的CPU占用率最高
• 查看數(shù)據(jù)庫(kù)的最大并發(fā)鏈接
• 查看歷史最大并發(fā)數(shù)
• 查看當(dāng)前并發(fā)數(shù)
• 查看某個(gè)用戶所具備的角色和權(quán)限
• 查看數(shù)據(jù)庫(kù)版本
• 查看patch情況
• 查看服務(wù)器端的parameter
• 殺Session
• 看某個(gè)Session對(duì)應(yīng)的操作系統(tǒng)PID
• 。。。

---

select username,default_tablespace from user_users;
select * from user_role_privs;
select * from user_sys_privs;
select * from user_tab_privs;
select * from user_tables;
select object_name,object_id from user_objects
                where instr(object_name,'LOG')>0;
select object_name,created from user_objects where object_name=upper

('&table_name');
select * from user_sequences;
select view_name from user_views;
select member from v$logfile;
Select version FROM Product_component_version
    Where SUBSTR(PRODUCT,1,6)='Oracle';
用系統(tǒng)管理員，查看當(dāng)前數(shù)據(jù)庫(kù)有幾個(gè)用戶連接：

SQL> select username,sid,serial# from v$session;

如果要停某個(gè)連接用

SQL> alter system kill session 'sid,serial#';

如果這命令不行,找它UNIX的進(jìn)程數(shù)

SQL> select pro.spid from v$session ses,v$process pro where ses.sid=21

and ses.paddr=pro.addr;

說(shuō)明：21是某個(gè)連接的sid數(shù)

然后用 kill 命令殺此進(jìn)程號(hào)。

select column_name,comments from dict_columns where

table_name='USER_INDEXES';

select column_name,comments from dict_columns where upper(table_name)

='v$session';
如何查看最大會(huì)話數(shù)？
SELECT * FROM V$PARAMETER WHERE NAME LIKE 'proc%'；
Select * from v$license;
SELECT *  FROM  USER_ERRORS;
SELECT * FROM V$INSTANCE;
select a.sid,spid,status,substr(a.program,1,40)

prog,a.terminal,osuser,value/60/100 value
     from v$session a,v$process b,v$sesstat c
     where c.statistic#=11 and c.sid=a.sid and a.paddr=b.addr order by

value desc;

select * from v$sqltext where address = 'C0000001E0B4A160';
select sql_text, piece, hash_value
from v$sqltext
where  address = 'C0000001E0B4A160'
order by hash_value, piece;

select * from v$sqlarea where address = (select sql_address from

v$session where sid = :1);