RE: Oracle Baselines and Java Internals

From: <Jared.Still_at_radisys.com>
Date: Tue, 20 Jul 2004 15:39:40 -0700
Message-ID: <OF3C578AEA.BBAC05A9-ON88256ED7.007C3989-88256ED7.007C7BEF@radisys.com>

> Jared,
>
> >Track DDL_TIME, CREATION_DATE and TIMESTAMP for all objects.
>
> In our Apps database, I have a System trigger that records *all* DDL,
with
> the exception of 'pre-approved' DDL. [Remember your earlier post about
the
> pre-approved changes?]

That would be useful, but I need a baseline at a certain date, for comparison
to the database at a later date.

> In short, you will need to keep in mind that:
>
> * Java code (and applications) could be stored in many locations,
including
> the Database (Java Stored Procedure), Business Tier (OC4J, EJB), Web
Tier
> (JSPs and Servlets) as well as at the Client tier (separately as a Java
> Application or run as an Applet).
> ...

Thanks for the great input John.

We don't write any any Java apps here, so all I'm interested tracking are changes to std installed stuff (if installed) and new Java that has been added. There may be database utility code, but that will all be stored in the database.

I'll check the articles.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 17:36:23 CDT