Re: "ps -ef" in oracle

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 13 Oct 2004 19:11:37 -0700
Message-ID: <1097719984.32165@yasure>

Gerhard M wrote:

> Sybrand Bakker <sybrandb_at_hccnet.nl> wrote in message news:<a4kom0p89soq6l4pj4t7mghmp23keuen7p_at_4ax.com>...
>
>

>>Of course there is. Just use the dbms_application_info package in your
>>procedure, the info you set will show in v$session.

>
>
> but what if you're unable to to modify the procedure.
> I'm not allowed to see or modify the procedure-body and the vendor has
> not used dbms_application_info.
>
> Is there an other way to check this?

In what version of Oracle? In 10g you CAN modify it no matter who wrote it or where.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Oct 13 2004 - 21:11:37 CDT