19 lines
326 B
SQL
19 lines
326 B
SQL
select /*+ ordered use_hash(s) */
|
|
b.paddr
|
|
, s.saddr
|
|
, p.spid
|
|
, p.pid
|
|
, s.sid
|
|
, b.name
|
|
, b.description
|
|
from
|
|
v$bgprocess b
|
|
, v$process p
|
|
, v$session s
|
|
where
|
|
b.paddr = p.addr
|
|
and b.paddr = s.paddr
|
|
and p.addr = s.paddr
|
|
and (lower(b.name) like lower('&1') or lower(b.description) like lower('&1'))
|
|
/
|