STATUS: This column identifies if the session is:Active: executing a SQL statement (waiting for/using a resource) Inactive: waiting for more work (that is, SQL statements) Killed: ed to be killed
可以使用plsql developer工具下看session和视图的源代码
CREATE OR REPLACE VIEW SYS.V_$SESSION AS select "SADDR","SID","SERIAL#","AUDSID","PADDR","USER#","USERNAME","COMMAND","OWNERID","TADDR","LOCKWAIT","STATUS","SERVER","SCHEMA#","SCHEMANAME","OSUSER","PROCESS","MACHINE","TERMINAL","PROGRAM","TYPE","SQL_ADDRESS","SQL_HASH_VALUE","PREV_SQL_ADDR","PREV_HASH_VALUE","MODULE","MODULE_HASH","ACTION","ACTION_HASH","CLIENT_INFO","FIXED_TABLE_SEQUENCE","ROW_WAIT_OBJ#","ROW_WAIT_FILE#","ROW_WAIT_BLOCK#","ROW_WAIT_ROW#","LOGON_TIME","LAST_CALL_ET","PDML_ENABLED","FAILOVER_TYPE","FAILOVER_METHOD","FAILED_OVER","RESOURCE_CONSUMER_GROUP","PDML_STATUS","PDDL_STATUS" from v$session /
回: wangybyangxr(王永斌) 看到了吗?他是 from v$session! 我想看V$session的代码 :)
V$SESSION: This view has one row for every session connected to the database instance. The sessions include user sessions, as well as background processes like DBWR, LGWR, archiver.你是怎么断开连接的?还是只是你以为已经断开了......
FT, CSDN怎么把我的代码过虑了...select * from v$fixed_view_definition Where VIEW_NAME='GV$SESSION'; select * from v$fixed_view_definition Where VIEW_NAME='V$SESSION';自己去查吧。:)
登录了3人了,只有一个是ACTIVE的。
刷新?肯定拉,我直接执行sql语句的。顺便问:如何看视图的源代码?我通过 PL/SQL 可以看到v_$session(其中调用 v$session),可就是看不到v$session的! 哪个命令是看视图的创建语句?
Inactive: waiting for more work (that is, SQL statements)
Killed: ed to be killed
AS
select "SADDR","SID","SERIAL#","AUDSID","PADDR","USER#","USERNAME","COMMAND","OWNERID","TADDR","LOCKWAIT","STATUS","SERVER","SCHEMA#","SCHEMANAME","OSUSER","PROCESS","MACHINE","TERMINAL","PROGRAM","TYPE","SQL_ADDRESS","SQL_HASH_VALUE","PREV_SQL_ADDR","PREV_HASH_VALUE","MODULE","MODULE_HASH","ACTION","ACTION_HASH","CLIENT_INFO","FIXED_TABLE_SEQUENCE","ROW_WAIT_OBJ#","ROW_WAIT_FILE#","ROW_WAIT_BLOCK#","ROW_WAIT_ROW#","LOGON_TIME","LAST_CALL_ET","PDML_ENABLED","FAILOVER_TYPE","FAILOVER_METHOD","FAILED_OVER","RESOURCE_CONSUMER_GROUP","PDML_STATUS","PDDL_STATUS" from v$session
/
1.可是,明明已经断开连接了,为什么还显示Inactive?!2.回到问题:请问哪里可以获得当前正登录着的[!当前正登录着的!]用户/会话信息呢????
3.回复: LGQDUCKY(飘) :看不到v$session的阿!贴出来看看?
This view has one row for every session connected to the database instance. The sessions include user sessions, as well as background processes like DBWR, LGWR, archiver.你是怎么断开连接的?还是只是你以为已经断开了......
问题列表:
1。请问哪里可以获得当前正登录着的[!当前正登录着的!]用户/会话信息呢????
2。v$session的创建代码
]
还有你是通过什么字段来确定你两次看到是同一个SESSION?通过SID判断的?
2,v$session其实是视图v_$session的一个同义词。
是基于另一个视图GV$SESSION创建的,GV$SESSION是基于动态性能表X$ksuse创建的。
v$session:
Select Saddr, Sid, Serial#, Audsid, Paddr, User#, Username, Command, Ownerid, Taddr, Lockwait, Status, Server, Schema#,
Schemaname, Osuser, Process, Machine, Terminal, Program, Type, Sql_Address, Sql_Hash_Value, Prev_Sql_Addr,
Prev_Hash_Value, Module, Module_Hash, Action, Action_Hash, Client_Info, Fixed_Table_Sequence, Row_Wait_Obj#,
Row_Wait_File#, Row_Wait_Block#, Row_Wait_Row#, Logon_Time, Last_Call_Et, Pdml_Enabled, Failover_Type,
Failover_Method, Failed_Over, Resource_Consumer_Group, Pdml_Status, Pddl_Status, Pq_Status,
Current_Queue_Duration, Client_Identifier
From Gv$session
Where Inst_Id = Userenv('Instance')
select * from v$fixed_view_definition Where VIEW_NAME='V$SESSION';自己去查吧。:)
建议再仔细观察一下
难道PB9的BUG!?! pb/sql没有这个问题,pb/sql关闭后pb/sql的连接就没了。召唤有同感的。