| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of TOMPKINS, MARGARET
Sent: Wednesday, August 04, 2004 7:46 PM
To: oracle-l_at_freelists.org
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_at_dfas.mil
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of david wendelken
Sent: Wednesday, August 04, 2004 6:37 PM
To: oracle-l_at_freelists.org
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_at_cosmiccooler.org>
Sent: Aug 4, 2004 3:45 PM
To: oracle-l_at_freelists.org
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
-- 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_at_freelists.org 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_at_freelists.org 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_at_freelists.org 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 -----------------------------------------------------------------Received on Wed Aug 04 2004 - 22:17:50 CDT
 |
 |