RE: standards

In terms of standards I have found Feuerstein's "Oracle PL/SQL Best
Practices" a great reference for PL/SQL coding standards.

With regard to Oracle installation standards Cary's original OFA white paper
or even a installation guide such as this are useful references:
http://www.dbspecialists.com/presentations/oracle920linux.html Although file
system and Oracle database enhancements like Automatic Storage Management
(Oracle 10G) convolute the relevance of these timeless standards it is still
darn useful to standardize the file system/mount points...nothing like every
file system being unique as a snow flake or what I like to call "the APS
standard" when one is faced with an Oracle "data warehouse" outage at 6pm.

I have used elements of "Extreme Programming" to develop overall
programming/development standards with regard to unit testing, change
management, versioning, etc. for small teams.

Finally, I have always tried to include, even under threats, protests, and
angry accusations of witchcraft and sorcery, some sort of enterprise
database monitoring such as OEM (Oracle Enterprise Manager) including alerts
and automation of routine maintenance (almost been lynched for it if that
walker brigade would have caught up to me) as part of the Oracle standards,
assuming you are developing standards that are this far reaching.

Keep in mind, there are several good PL/SQL best practices presentations on
the Internet that offer a somewhat condensed version of the main points in
Feuerstein's book.

Thanks.

Ellis

PS I would send the standards I developed in the past but fear they might
incite the same level of Luddite reprisal I experienced and I would hate to
see your data center over-turned and beaten with hammers and the feet of
gold-plated walkers.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of TOMPKINS, MARGARET
Sent: Wednesday, August 04, 2004 7:46 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: standards


I personally prefer firing before flogging, but flogging first does set =
a better example.....

Respectfully,
> Maggie Tompkins - CAD SQA
> Corporate Applications Division
> Technology Services Organization - Kansas City
> Defense Finance and Accounting Service
> 816-926-1117 (DSN 465); Margaret.Tompkins@xxxxxxxx


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of david wendelken
Sent: Wednesday, August 04, 2004 6:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: standards



How about:

PL/SQL Programmers who use exception blocks like this will be flogged, =
then fired from their job.

EXCEPTION
  WHEN OTHERS THEN
     NULL;
END;

:)

-----Original Message-----
From: David <thump@xxxxxxxxxxxxxxxx>
Sent: Aug 4, 2004 3:45 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: standards

I ahve been asked to write the standards for the company in terms of
Oracle databases.
I have never done anythign like that before...
Anyone have any pointers or skeletons or examples I could review?
Cheers
--=20
..
David

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: