Alex,
that was the result of an "inexperienced" DBA. an experienced DBA would
know that there is a load placed on the server during datafile addition
time. if you have a server with extra "oomf", then the users should not see
any difference.
it sounds like you had a very sensitive database that the DBA should have
known to schedule the file addition with management.
don't get me wrong, the real issue with your example and with Jay's is
education. management (or was it damagement?) needs to be educated about
what DBA's do, how to establish proper procedures for database tuning and
changes, what is "change management" and what kind of (DBA) freedom is
appropriate for the organization. generally, we should be considered
System Administrators, and such, we can have a very large impact (good and
bad) on the system.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, June 25, 2001 12:12 PM
To: Multiple recipients of list ORACLE-L
I agree with you, however in one of my previous contracts one guy decided to
add datafile to the database. He aadded a 2G file and database for several
minutes did only one thing - created datafile. Application servers were shut
down because they checked DB every 5 sec or something like that. There was a
big fass because even several minutes of downtime were not acceptable for
this app. This guys even considered to sue Oracle (this guy was Oracle
consultant).
Alex Hillman
-----Original Message-----
Sent: Monday, June 25, 2001 11:32 AM
To: Multiple recipients of list ORACLE-L
Jay,
You did not say what type of an employer you are currently at, so it is
tough to comment.
I have seen *very* strict controls put into place at various places of
employment. It sounds like you are at a gov't facility where audit and
control is serious business.
You have three choices:
1). try and work thru the system to show why this is a bad idea - like let
the system go to hell and explain that you would have fixed it, but have
been waiting for a signature from the VP.
2). flood the VP with so many requests that he/she sees how ridiculous the
requirement is.
3). if all else fails, start looking for another job. at exit interview
time, explain that the audit process is NOT conducive to business standards.
hope this helps
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, June 25, 2001 11:07 AM
To: Multiple recipients of list ORACLE-L
One of the reasons DBA's are paid well is that they have total control over
the production data. No matter what rules the auditors put in place, a DBA
could manipulate the data if they wanted to. The company should trust you
to do your job and not put up read blocks that prevent you from maintaining
the database and making changes in a timely manner.
-----Original Message-----
Sent: Monday, June 25, 2001 9:32 AM
To: Multiple recipients of list ORACLE-L
We've been through an internal audit and I was just wondering if anyone else
has to deal with the rather ludicrous requirements I now have. In order to
add or resize a datafile I now need to fill out a form and get Senior VP
approval and the alert logs must be reviewed every day by a non-DBA in order
to be certain that I didn't make any database changes without such approval.
The auditors were horrified to discover that not only did I do such things
whenever I thought them necessary but that we didn't have a non-DBA review
everything I did after an Oracle upgrade to ensure I didn't install any
other software.
Fortunately I managed to convince them that yes, I really did need a Unix
login (they were skeptical).
So, any similar horror stories?
Jay Miller
Sr. Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Miller, Jay
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: Smith, Ron L.
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: Mercadante, Thomas F
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: Hillman, Alex
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: Mercadante, Thomas F
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).
