SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : Oracle Corporation (ORCL) -- Ignore unavailable to you. Want to Upgrade?


To: Soumen Barua who wrote (10061)3/13/1999 10:05:00 AM
From: Rick Kupcunas  Read Replies (3) | Respond to of 19079
 
Let me clue you in PAL ... as a certified Oracle DBA for over two years, managing some of the largest databases around I can tell you that some thought must go into the design and configuration of any respectable product. Sure if you want to slap together some hardware, install a quick database it will run but if you want a highly effiecient database machine you must do some planning, configuration and have the vision to properly create your database to support your customers.

I necessary I will put you in touch with several Database architecture and they will give you some items to consider when designing a database; or even share some white papers to properly design a design a database.

As for knowing database check out my web-site:

home1.gte.net

from there you will see that I know a little about database design... and yes, I still believe in the statement:

"it is the DBA's responsibility to design, configure, tune and optimize the queries that access the database"

1. design .... you must layout the database to minimize disk I/O as well as to properly set the parameters within your init.ora file

2. configure.. there are 100+ different parameters that must be set in the init.ora; most of the default parameters will work but several must be carefully set (i.e.: wether or not to use asyn I/O; raw devices, type of RAID)

3. tune and configure.... about 80% of performance gains are made by rewriting queries, adding indexes or changing proces flows.

As for LE bashing MSFT's product ... when someone from MSFT can publish performance benchmarks close to the throughput of Oracle's database give me a call! After reading your statement I assume your a SQL Server DBA - this explains alot as to why MSFT will not publish benchmark results.