Re: "ps -ef" in oracle

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 14 Oct 2004 17:49:51 -0700
Message-ID: <2687bb95.0410141649.69801de1@posting.google.com>

notruf_1102003_at_yahoo.de (Gerhard M) wrote in message news:<942c5b0d.0410140212.24486e3e_at_posting.google.com>...
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097719984.32165_at_yasure>...
>
> > In what version of Oracle? In 10g you CAN modify it no matter who wrote
> > it or where.
>
> Oracle9i Enterprise Edition Release 9.2.0.5.0

Daniel is correct in that technically, if the code is not a wrapped packaged procedure, in that you can extract a copy and modify it. This might however violate vendor contract terms.

You can see pl/sql code being executed by a session in the v$sql views just like SQL though this might be hard to identify.

I believe that if a procedure is in use you willl be able to see it in v$db_object_cache and it will show as pinned while in use by any session. Perhaps this will give you what you need.

HTH -- Mark D Powell -- Received on Thu Oct 14 2004 - 19:49:51 CDT