24 lines
562 B
MySQL
24 lines
562 B
MySQL
|
-- 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'))
|
||
|
|
/
|