в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T10:01:10Z

1 версия

Новая страница

==Query v$session_event==



<source lang="sql">

SQL>
SQL> set echo on
SQL>
SQL> create global temporary table sess_event on commit preserve rows as select * from v$session_event where 1=0;
Table created.
SQL>
SQL> truncate table sess_event;
Table truncated.
SQL>
SQL> insert into sess_event select * from v$session_event where sid = ( select sid from v$mystat where rownum = 1 );
22 rows created.
SQL>
SQL> select a.event,
2 (a.total_waits-nvl(b.total_waits,0)) total_waits,
3 (a.time_waited-nvl(b.time_waited,0)) time_waited
4 from ( select * from v$session_event where sid = (select sid from v$mystat where rownum = 1 )) a,
5 sess_event b
6 where a.event = b.event(+) and (a.total_waits-nvl(b.total_waits,0)) > 0
7 /
EVENT
--------------------------------------------------
TOTAL_WAITS TIME_WAITED
----------- -----------
SQL*Net message to client
5 0
SQL*Net message from client
4 11

2 rows selected.
SQL>
SQL>
SQL> drop table sess_event;
drop table sess_event
*
ERROR at line 1:
ORA-14452: attempt to create, alter or drop an
index on temporary table already in use

SQL> --
</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/System Tables Views/session event - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия