Database Tuning (MOSC)

MOSC Banner

Query to find SID, serial# and inst_id for a particular package

edited May 13, 2013 6:32AM in Database Tuning (MOSC) 2 commentsAnswered
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


Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center