Re: Pro's & Con's on Oracle & SQL Svr?

in article I0Ww6.1130$RF1.92706_at_bgtnsc06-news.ops.worldnet.att.net, Dr. Mueller at nospam_at_nospam.com wrote on 3/29/01 10:50 PM:

> Thanks Wayne. That was a very interesting piece you wrote. The small-time
> shop scenario is the one that fits what I'm doing. Thanks again for your
> help.
>
> Regards.
>
>

It always surprises me that people tend to naturally think MS products are more appropriate for the small-time shop, and Oracle more appropriate for large shops.

For instance, if I was a part time DBA, I'd want a product that allowed me to do as much as possible during normal business hours - without the need to come in at night or over the weekend. Oracle's ability to have reports running at the same time as users are entering data without these users affecting each other, it's ability to do online backups as well as restores, support for online index builds, built in resource management, fast recovery, fast data loading etc would all be things I would be looking for to make my life as easy as possible no matter how large my shop. And Oracle9i's new dynamic memory management and ability to re-org and redefine tables and other database objects online is only going to make this even better.

After all, high availability and scalability actually means "is the system there when I want to use it", and "can I get the performance I need to do this task now, or do I have to wait". These issues are experienced by all sites, both large and small, and do NOT necessarily only equate to sites supporting 50,000 users online 24x7. Received on Sat Mar 31 2001 - 00:45:33 CST