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

Hi Nirmal,

There is some information about the X$ tables available on the Ixora web site. However, knowledge of the X$ tables is not really important for most DBAs. They are only useful in rare, advanced tuning and diagnostic situations.

@   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 19:25
To: Multiple recipients of list ORACLE-L

Hi adams....
What should i get details of X$ tables..... How much these tables are important as a DBA.. Rgds,
Nirmal,
-----Original Message-----
Sent: Tuesday, October 30, 2001 9:45 AM To: Multiple recipients of list ORACLE-L 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). 
-- 
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).