Liste des sessions actives de la base

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
select 
  sid,
  serial#,
  program,
  machine,
  username
from 
  v$session 
where 
  username is not null
order by 
  program, 
  machine;
	
accept ids prompt 'session ' --fournir l'un des sid de la liste ci-dessus

select
  t.sql_text
from 
  v$session s,
	v$sqltext t
where
  s.sid = &ids
	and t.hash_value = s.sql_hash_value
order by 
  t.piece;