零散技術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  )