零散技术oracle
select *
from v$session
where paddr in
(select addr
from v$process
where spid =
(select b.oracle_process_id
from apps.fnd_concurrent_requests b
where b.request_id = &req_number))
select request_id
from apps.fnd_concurrent_requests b
where oracle_process_id in
(select spid from v$process
where addr in (select paddr from v$session where sid = &sid))
select *
from v$session
where paddr in
(select addr
from v$process
where spid =
(select b.oracle_process_id
from apps.fnd_concurrent_requests b
where b.request_id = &req_number))
SELECT request_id,oracle_process_id FROM APPS.FND_concurrent_requests where
select SID from v$session_wait order by seconds_in_wait desc
select * from v$session
select a.sid, b.name, sum(value)/1024/1024
from v$sesstat a, v$statname b
where a.statistic#=b.statistic#
and b.name='redo size'
group by sid,name
select sum(sum_size) from
(select a.sid, b.name, sum(value)/1024/1024 sum_size
from v$sesstat a, v$statname b
where a.statistic#=b.statistic#
and b.name='redo size'
group by sid,name )
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8568259/viewspace-1412499/ ，如需转载，请注明出处，否则将追究法律责任。
