Ray,
The integration problems you seem to be having sounds like the problem is more with the cowboys...errr....developers :-) Or with the processes and procedures in your development group.
I would have thought that with a hundred or so developers it would be more chaotic sharing the same schema. How will you stop developers interferring with each others work? I'd be surprised if this schema ever becomes stable. That is, how will developers know whether the tables/data/code they see in the schema is suppose to be apart of the system, or just apart of something another developer is "trying out"? How will you stop developers writing code that isn't suppose to be there.
I think having a shared integration area/schema is essential, so long as there are procedures around what gets released to this area.
I believe that you are going to have problems if you let everyone share the same development schema. Having said that, I would be interested to hear how it turns out for you.
Cheers,
Craig.
-----Original Message-----
From: Ray Gordon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 26 June 2002 5:24 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: recording SQLPlus activity
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).
