RE: How can I tell if a procedure/package is running?

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Tue, 30 Oct 2001 01:37:00 -0800
Message-ID: <F001.003B8042.20011030012517@fatcity.com>

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:steve.adams_at_ixora.com.au]
Sent:   Tuesday, October 30, 2001 9:45 AM
To:     Multiple recipients of list ORACLE-L

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/              -  For DBAs
@   http://www.secularislam.org/call.htm  -  For Muslims
@   http://www.christianity.net.au/       -  For all

-----Original Message-----
Sent: Tuesday, 30 October 2001 16:00
To: Multiple recipients of list ORACLE-L

out of curiosity...
what does the values 0 and 1 implies ? ( in X$KGLOB.KGLHDPMD)

> ----------
> From:         Steve Adams[SMTP:steve.adams_at_ixora.com.au]
> Reply To:     ORACLE-L_at_fatcity.com
> 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 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 sessions holding the pins. See
> "executing_packages.sql" at
> http://www.ixora.com.au/scripts/misc.htm#executing_packages for an
> example.
>
> @   Regards,
> @   Steve Adams
> @   http://www.ixora.com.au/              -  For DBAs
> @   http://www.secularislam.org/call.htm  -  For Muslims
> @   http://www.christianity.net.au/       -  For all
>
> -----Original Message-----
>
> How can I tell if a stored procedure or package is in the middle of
> execution?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 30 2001 - 03:37:00 CST