Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1097803063.15327_at_yasure>...
> Mark D Powell wrote:
>
> > 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 --
>
> Actually even if it is wrapped and even if it is in a compile C++ front
> end. Take a look at the ADDM.
>
> I think the capability is coming from DBMS_SQLTUNE.ACCEPT_SQL_PROFILE
> but I could be incorrect as I am still working my way through the DBMS
> packages that support ADDM functionality.
Daniel, I will add the ADDM to my ever growing list of things to look into.
Received on Fri Oct 15 2004 - 08:31:35 CDT
