分类: Oracle
2011-11-15 17:51:54
This event is used for two purposes:
Switching sessions
If a time-out period has been specified, then wait that amount of time for the session to be detached.
Killing sessions
From either KILL SESSION or internal request. Having posted a session that it should kill itself, wait for up to 1 minute for the session to terminate.
Wait Time: 1 second
Parameter | Description |
---|---|
session# | See |
waited | See |
SQL> select a.sample_time,b.event_name,a.wait_time,a.time_waited,a.program,a.module
2 from WRH$_ACTIVE_SESSION_HISTORY a,WRH$_EVENT_NAME b
3 where a.event_id=b.event_id and a.instance_number=1
4 and trunc(sample_time,'DD')=to_date('2010-04-14','yyyy-mm-dd')
5 and b.event_name='inactive session';
SAMPLE_TIME EVENT_NAME WAIT_TIME TIME_WAITED PROGRAM MODULE
------------------------------ ------------------ --------- ----------- ------------------------------ ----------------
-
14-4月 -10 09.54.20.591 上午 inactive session 0 986323 plsqldev.exe PL/SQL Developer
14-4月 -10 09.54.10.491 上午 inactive session 0 986324 plsqldev.exe PL/SQL Developer
14-4月 -10 09.53.30.091 上午 inactive session 0 986323 plsqldev.exe PL/SQL Developer
14-4月 -10 09.53.19.991 上午 inactive session 0 986320 plsqldev.exe PL/SQL Developer
14-4月 -10 09.53.09.891 上午 inactive session 0 986309 plsqldev.exe PL/SQL Developer
14-4月 -10 09.52.59.791 上午 inactive session 0 986321 plsqldev.exe PL/SQL Developer
14-4月 -10 09.47.06.176 上午 inactive session 0 986657 sqlplus@XGP2_db1 (TNS V1-V3) SQL*Plus
14-4月 -10 09.46.05.577 上午 inactive session 0 986209 sqlplus@XGP2_db1 (TNS V1-V3) SQL*Plus
14-4月 -10 09.45.04.967 上午 inactive session 0 986258 plsqldev.exe PL/SQL Developer
14-4月 -10 09.44.54.859 上午 inactive session 0 983625 plsqldev.exe PL/SQL Developer
14-4月 -10 09.44.44.749 上午 inactive session 0 986287 plsqldev.exe PL/SQL Developer
SAMPLE_TIME EVENT_NAME WAIT_TIME TIME_WAITED PROGRAM MODULE
------------------------------ ------------------ --------- ----------- ------------------------------ ----------------
-
14-4月 -10 09.44.34.649 上午 inactive session 0 986195 plsqldev.exe PL/SQL Developer
14-4月 -10 09.44.24.539 上午 inactive session 0 986176 plsqldev.exe PL/SQL Developer
14-4月 -10 09.44.14.439 上午 inactive session 0 985975 plsqldev.exe PL/SQL Developer
14-4月 -10 09.43.23.929 上午 inactive session 0 986760 plsqldev.exe PL/SQL Developer
14-4月 -10 09.43.13.829 上午 inactive session 0 985187 plsqldev.exe PL/SQL Developer
14-4月 -10 09.43.03.730 上午 inactive session 0 986105 plsqldev.exe PL/SQL Developer
14-4月 -10 09.42.53.631 上午 inactive session 0 986288 plsqldev.exe PL/SQL Developer
14-4月 -10 09.42.43.531 上午 inactive session 0 986283 plsqldev.exe PL/SQL Developer
14-4月 -10 09.42.33.431 上午 inactive session 0 986271 plsqldev.exe PL/SQL Developer