怎样获得oracle中的进程信息？

Question

select * from v$session;

Answer 1

楼上说的对
你先desc v$session
然后选择合适的col进行查看
实际上我们通常将v$session同别的视图象
v$lock 等进行关联查询。希望对你有帮助

Answer 2

谢谢支持
能否将V$SESSION的数据结构传上来？还有我怎么确定该会话是否ACTIVE?该问题解决立马送分！

Answer 3

SQL> desc v$session;
名称                          是否为空？类型
------------------------------- -------- ----
 SADDR                                    RAW(4)
 SID                                      NUMBER
 SERIAL#                                  NUMBER
 AUDSID                                   NUMBER
 PADDR                                    RAW(4)
 USER#                                    NUMBER
 USERNAME                                 VARCHAR2(30)
 COMMAND                                  NUMBER
 OWNERID                                  NUMBER
 TADDR                                    VARCHAR2(8)
 LOCKWAIT                                 VARCHAR2(8)
 STATUS                                   VARCHAR2(8)
 SERVER                                   VARCHAR2(9)
 SCHEMA#                                  NUMBER
 SCHEMANAME                               VARCHAR2(30)
 OSUSER                                   VARCHAR2(30)
 PROCESS                                  VARCHAR2(9)
 MACHINE                                  VARCHAR2(16)
 TERMINAL                                 VARCHAR2(16)
 PROGRAM                                  VARCHAR2(64)
 TYPE                                     VARCHAR2(10)
 SQL_ADDRESS                              RAW(4)
 SQL_HASH_VALUE                           NUMBER
 PREV_SQL_ADDR                            RAW(4)
 PREV_HASH_VALUE                          NUMBER
 MODULE                                   VARCHAR2(48)
 MODULE_HASH                              NUMBER
 ACTION                                   VARCHAR2(32)
 ACTION_HASH                              NUMBER
 CLIENT_INFO                              VARCHAR2(64)
 FIXED_TABLE_SEQUENCE                     NUMBER
 ROW_WAIT_OBJ#                            NUMBER
 ROW_WAIT_FILE#                           NUMBER
 ROW_WAIT_BLOCK#                          NUMBER
 ROW_WAIT_ROW#                            NUMBER
 LOGON_TIME                               DATE
 LAST_CALL_ET                             NUMBER
 PDML_ENABLED                             VARCHAR2(3)
 FAILOVER_TYPE                            VARCHAR2(13)
 FAILOVER_METHOD                          VARCHAR2(10)
 FAILED_OVER                              VARCHAR2(3)
 RESOURCE_CONSUMER_GROUP                  VARCHAR2(32)
 PDML_STATUS                              VARCHAR2(8)
 PDDL_STATUS                              VARCHAR2(8)要解释起来就麻烦了，你还自己先看看吧，呵呵。STATUS                                   VARCHAR2(8)
可以判断是否active,但是如果一个用户不是正在操作数据的话，一般都是判断处于inactive状态的，所以......你要干什么用的？

Answer 4

在oracle下一个会话结束，数据库会立即删除该进程么？

Answer 5

执行：alter system kill session 'sid,serial#';即可删除。