24 lines
562 B
SQL
24 lines
562 B
SQL
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
select /*+ ordered use_hash(s) */
|
|
b.name
|
|
, b.description
|
|
, s.sid
|
|
, p.pid opid
|
|
, p.spid
|
|
, b.paddr
|
|
, s.saddr
|
|
-- , b.typea -- 12.2+
|
|
-- , b.priority -- 12.2+
|
|
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'))
|
|
/
|