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: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:[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,
>
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).