Query to find SID, serial# and inst_id for a particular package
Hi Team ,
I need a query by which I can find sid, serial# and inst_id in one go for a particular package i.e XYZ_PKG,
What I am doing now is,
select * from gv$access where object='XYZ_PKG';
Then according to this SID, I am querying for SERIAL#
select serial# from gv$session where sid=743 and inst_id=2
Can any one help me to find one query by which I can find SID< SERIAL#, INST_ID for XTZ_PKG;
Thanks
PP
I need a query by which I can find sid, serial# and inst_id in one go for a particular package i.e XYZ_PKG,
What I am doing now is,
select * from gv$access where object='XYZ_PKG';
Then according to this SID, I am querying for SERIAL#
select serial# from gv$session where sid=743 and inst_id=2
Can any one help me to find one query by which I can find SID< SERIAL#, INST_ID for XTZ_PKG;
Thanks
PP
0