Re: extproc - How to tell if the feature is being used
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: peter.schauss@xxxxxxx
- Date: Wed, 11 Mar 2009 12:01:24 -0400
If extproc is served by dedicated listener, check it's log for connections.
If it's in the same listener, check for connections with the extproc key.
--
Christo Kutrovsky
Senior DBA
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
On Tue, Mar 10, 2009 at 4:37 PM, Schauss, R. Peter (IT)
<peter.schauss@xxxxxxx> wrote:
> This is Oracle 8.1.7.4 running on Solaris/SunOS 5.9. The application is
> a COTS package.
>
> Our security people just picked up via a scan of our servers that we
> still have extproc enabled in our listener.ora and tnsnames.ora files.
>
> select * from dba_libraries where file_spec is not null;
>
> returns four lines for library_name values of DBMS_SUMADV_LIB,
> ORDIMLIBS, ORDVIRLIBS, and DR$LIBX. These are owned by sys, ordsys,
> ctxsys. There are an additional 33 rows in this table where file_spec
> is null.
>
>
> select owner,name,line
> from dba_source
> where upper(line) like '%LANGUAGE%';
>
> returns no lines.
>
> Obviously we will be testing this in our QA environment before we
> disable extproc in production. However, I would like to tell my
> applications people and management that I am reasonably certain that the
> application is not using extproc before we start testing. Is there
> anywhere else I can look for evidence that we are or are not using
> external procedures?
>
> Thanks,
> Peter Schauss
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Christo Kutrovsky
Senior DBA
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
