In case of parallel queries you can have more than 1 session :)
Simple example:
declare
cursor c is select/*+ parallel(4) */ * from all_objects;
crow c%rowtype;
begin
open c;
fetch c into crow;
for r in (select s.sid,s.serial#,px.qcsid,px.qcserial# from v$session s,
v$px_session px where s.audsid=userenv('sessionid') and s.sid=px.sid) loop
dbms_output.put_line('Sid:'|| r.sid ||', serial#:'|| r.serial# ||'
qcsid='|| r.qcsid);
end loop;
end;
/
or another example - just just one simple query:
with v as (select/*+ parallel(4) materialize */ count(*) from all_objects)
select/*+ parallel(8) */
px.sid,px.serial#,qcsid,qcserial#
,s.*
from v,v$session s, v$px_session px
where
s.audsid=userenv('sessionid')
and s.sid=px.sid(+)
and s.serial#=px.serial#
/
On Fri, Mar 29, 2019 at 10:54 PM Luis Santos <lsantos@xxxxxxxxx> wrote:
Sounds reasonable, but V$SESSION is not V$SESSIONS... :-)
from mobile
Em sex, 29 de mar de 2019 15:43, Oleksandr Denysenko <odenysenko@xxxxxxxxx>
escreveu:
I think v$mysession is really good for my current session,
but v$mysessions is good for all my(current user) sessions.
пт, 29 мар. 2019 г., 20:39 Norman Dunbar <oracle@xxxxxxxxxxxxxxx>:
On 29/03/2019 18:29, Oleksandr Denysenko wrote:> hi.
>
> just re-read requirements
> "(current and possibly other sessions from the same user)"
I sit corrected, thank you very much. Apologies.
Note to self, remember to read the text before jumping in with both feet!
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG
Company Number: 05132767
--
//www.freelists.org/webpage/oracle-l
