Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: standards

RE: standards

From: Ellis R. Miller <sartre1_at_comcast.net>
Date: Wed, 4 Aug 2004 22:35:15 -0600
Message-ID: <AOEDLEKLOHPKBBLDFCLAEECLDPAA.sartre1@comcast.net>


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



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
-----------------------------------------------------------------

----------------------------------------------------------------
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US