Ray - A couple of things come to mind. First, does each developer have their
own Oracle login? If not, you probably will not be able to tell who did what
anyway.
What version of Oracle?
I would consider running the database in ARCHIVELOG mode. Not a bad
idea in a heavy development environment because people are making important
changes and a lot of changes, so while recoverability might not be quite as
important as a full production environment, it is important. A big failure
could affect a lot of people. You can also perform point-in-time recoveries.
If you have archive logs and a recent version of Oracle (8i, I believe), you
can use LogMiner to extract what they are doing / did. It also works against
the online redo logs, so when somebody really bollixes everything up, you
can read the online logs to find the culprit quickly.
Another source of information that stores less history is to dump the
V$SQLTEXT table. This is also useful to see what queries people are running
against the database. In the long run, you want to make sure they creating
good queries. You can run STATSPACK, capture the SQL each hour, and it also
lists the SQL ordered by resource usage, so you can spot the bad queries
before they migrate to production.
Yet another consideration is to turn auditing on. You can probably just
turn on a couple of auditing options and get what you need without storing
every minute detail.
Hope these are enough sources of information for you.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Monday, June 24, 2002 7:53 PM
To: Multiple recipients of list ORACLE-L
I have just been moved to a group with several hundred developers, and to
say the least the environment is chaotic.
Without putting limits on my developers (such as via READONLY user, etc.),
is there some way that every command that a developer executes using SQLPlus
gets recorded (by userid and time)?
Ray
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ray Gordon
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
