高玉昆
Archives for: July 2007, 24
如何查看oracle的所有用户,会话，执行sql
Category: sql
查询所有用户
select * from all_users;
select * from dba_users;
查询所有会话
select * from v$session
和会话相关的系统表：
v$session_wait,v$session_connect_info, v$session_event,v$session_object_cache,v$session_cursor_cache,v$session_longops
查询所有在执行的sql
select * from v$sqltext
高玉昆
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| << < | Current | > >> | ||||
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 | |||||
Search
Categories
Archives
- September 2009 (2)
- August 2009 (3)
- July 2009 (1)
- June 2009 (11)
- May 2009 (5)
- April 2009 (2)
- March 2009 (2)
- February 2009 (1)
- December 2008 (9)
- November 2008 (1)
- October 2008 (5)
- September 2008 (11)
- More...
Choose skin
Linkblog
公益网站
Misc
Syndicate this blog 
What is RSS?
Who's Online?
Guest Users: 14powered by
Original b2evolution template design by Topanga based on the standard template by François PLANQUE.
