Ray,
- Don't count out the idea of separate schemas. Your options to track
what you are proposing is quite limited otherwise. Unfortunately, most
things are tracked in Oracle only by userid. Someone on this list pointed
out a way to have separate schemas pretty efficiently. Create a developer
template, so you create the userid, grant the tables, and create private
synonyms for the developer. The advantage is that if a developer needs to
make a table change, and with this many developers you will be doing that a
lot, you can let them drop the synonym and create the table in their schema
until you are ready to roll the change out to the other developers.
- The only idea I have for doing what you the way you describe would be
to use the SQL*Plus login.sql script so you configure some identity
information automatically. You could even start a spool file that would
track their activities, but the drawback is if they open a spool file, that
would terminate your file.
- I liked your joke about your being in control of the development. With
that many developers, control is about the last thing you'll have. :-)
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Tuesday, June 25, 2002 2:24 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I dont want to create separate working environments for each of the users.
We have had cases where developers compile programs in their programs and
which do not work in the real environment, and several other issues.
Ideally, I would like to have everyone work in the same environment, but
with controls.
Ray
>From : DENNIS WILLIAMS <[EMAIL PROTECTED]>
Reply-To : [EMAIL PROTECTED]
To : Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject : RE: recording SQLPlus activity
Date : Mon, 24 Jun 2002 17:43:18 -0800
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).
