Re: "ps -ef" in oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 14 Oct 2004 18:16:16 -0700
Message-ID: <1097803063.15327@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 A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Thu Oct 14 2004 - 20:16:16 CDT