Hi,
You can do
Select object_name, object_type, status
from dba_objects
where object_type like '%PACK%' or
object_type like '%PROCE%'
order by 2,1;
Sinardy
-Original Message-
[EMAIL PROTECTED]
Sent: 22 January 2002 15:10
To: Multiple recipients of list ORACLE-L
Can
Title: RE: Re: How can I tell if a procedure/package is running?
Sinardy,
This only tells you if an object exists not if it is running - or even if it is valid unless status is elected from dba_objects as well.
There was a thread around 30/10/01 with the appropriate title 'How can I tell
that will merely tell you the object exists and that it is either valid
(cleanly compiled) or invalid (needs recompilation)
--- Sinard Xing [EMAIL PROTECTED] wrote:
Hi,
You can do
Select object_name, object_type, status
from dba_objects
where object_type like '%PACK%' or
Can anyone give me a good example on how this works?
Thanks in advance
Roland
Connor McDonald [EMAIL PROTECTED]@fatcity.com den 2001-10-25 01:45 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Kopia:
I
Subject: RE: How can I tell if a procedure/package is running?
Hi Rahul,
0 means not pinned; 3 means pinned in exclusive mode.
I don't know what 1 means. I'm not accustomed to seeing it.
Do you have any examples?
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au
i guess KGLHDLMD is lock Mode ? and KGLHDPMD = mode pinned ?
--
From: Steve Adams[SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 3:51 PM
To: Rahul; Multiple recipients of list ORACLE-L
Subject: RE: How can I tell if a procedure/package is running
Title: RE: How can I tell if a procedure/package is running?
Hi adams
What should i get details of X$ tables.
How much these tables are important as a DBA..
Rgds,
Nirmal,
-Original Message-
From: Steve Adams [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 9
recipients of list ORACLE-L
Subject: RE: How can I tell if a procedure/package is running?
Hi Doug,
You can look at the mode in which the stored procedure or package is
pinned in the library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object
Hi Doug,
You can look at the mode in which the stored procedure or package is pinned in the
library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by
one or more sessions. If necessary,
you can join to X$KGLPN to find the
Hi Doug,
You can look at the mode in which the stored procedure or package is pinned in the
library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in shared mode by
one or more sessions. If necessary,
you can join to X$KGLPN to find the
can I tell if a procedure/package is running?
Hi Doug,
You can look at the mode in which the stored procedure or package is
pinned in the library cache. This information is in
X$KGLOB.KGLHDPMD. A value of 2 indicates that the object is pinned in
shared mode by one or more sessions
PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: How can I tell if a procedure/package is running?
Hi Doug,
You can look at the mode in which the stored procedure or package is
pinned
? ( in X$KGLOB.KGLHDPMD)
--
From: Steve Adams[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Tuesday, October 30, 2001 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: How can I tell if a procedure/package is running?
Hi Doug
I would say that the best way is in its coding
typically by adding calls to dbms_application_info -
which is great way of tying SQL to its owning PL/SQL
as well.
You might be lucky to catch it in sql_address in
v$session (depending on what its actually doing at the
time). Similarly, you could
14 matches
Mail list logo