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

Home -> Community -> Usenet -> c.d.o.server -> Re: Deadly sins againts database performance/scalability

Re: Deadly sins againts database performance/scalability

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 25 Nov 2003 15:42:35 -0800
Message-ID: <1069803787.196016@yasure>


Anurag Varma wrote:

> "Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message
> news:3722db.0311251414.775ac3e7_at_posting.google.com...
> 

>>Norman did a great job listing the database development sins, but I
>>have 1 more: Doing everything that Siebel enforces its customers to
>>do! For example:
>>- Enforce the use of RBO instead of CBO!
>>- Rebuild indexes periodically, in the hope that "it will help
>>performance"
>>- create gazillions of indices on an OLTP system (it's not common in
>>Siebel that more than 100 indices are defined on a table)
>>- Have no reference integrity at the database level!
>>- Avoid at all costs to use MV's or views!!!! (they prefer instead to
>>use giant SQL statements).
>>
>>Daniel Roy
>>Siebel Developer!
>>
> 
> --snip--
> 
> he he .. and you would wonder how Tom Siebel who was former group vice president for Oracle USA
> could be incharge of an application which breaks so many rules in the Oracle world.
> 
> :) Maybe getting back at Larry and his customers ...
> 
> Anurag

If Larry doesn't get PeopleSoft he may turn his attentions elsewhere. Hmmmm!

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Nov 25 2003 - 17:42:35 CST

Original text of this message

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