Pages
(Move to ...)
FUSION
AP
AR
GL
INV
PO
OM
HR
PA
FAQS
PL-SQL
TECH
SCRIPTS
OAF
DOWNLOADS
▼
Saturday, July 11, 2015
Query to find the pid of the concurrent job and kill it
SELECT
a
.
inst_id
,
sid,
b
.
spid
FROM
gv$session
a
,
gv$process
b
,
apps
.
fnd_concurrent_requests c
WHERE
a
.
paddr
=
b
.
addr
AND
request_id
=
'31689665'
AND
a
.
inst_id
=
b
.
inst_id
AND
c
.
os_process_id
=
a
.
process
;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment