select * from v$sqlarea t where t.PARSING_SCHEMA_NAME in ('ç¨æ·å') order by t.LAST_ACTIVE_TIME desc
ç¨æ·åéè¦å¤§å
select * from v$sqlarea t order by t.LAST_ACTIVE_TIME desc
注æ ï¼æ§è¡æ¤è¯å¥ççä¸äºç¸å
³çè¯å¥ å¿
é¡»å
·æDBA çæé è½ç¶è¿æ¡è¯å¥å¾æ®é ä½æ¯éè¦çæ¶åå¾ç®¡ç¨ è½å¤åæ¶æ¥åºä¸ä¸ªäººæ§è¡sqlè¯å¥æ
åµ
-------oracle æ¥çå·²ç»æ§è¡è¿çsql è¿äºæ¯åå¨å
±äº«æ± ä¸ç --------->
select * from v$sqlarea t order by t.LAST_ACTIVE_TIME desc
-----------æ¥çoracleä¼è¯----------------------------ã
select * from v$session t order by t.LAST_ACTIVE_TIME desc
-------------æ¥çoracleçæéè§è²------------------------------>
select * from dba_role_privs; æäºç¨æ·åå
¶ä»è§è²çè§è²
select * from dba_sys_privs; æäºç¨æ·åå
¶ä»è§è²çç³»ç»æé
select * from dba_tab_privs; æ°æ®åºä¸å¯¹è±¡çææææ
select * from user_role_privs; æ¥çå½åç¨æ·çè§è²
温馨提示:答案为网友推荐,仅供参考