Differences in features provided by both Oracle and MS SQL determine the tasks that DBA needs to carry out while managing and maintaining the concern databases. As per my opinion SQL server can be placed between MS Access and Oracle as far as its functionality, performance, and scalability are concerned. It is a simple and good work-group solution, simple to use and administer.
Whereas Oracle on the other hand is much advanced and has more to offer.
Here is the comparison in Oracle and SQL Server feature which draw us to a conclusion about how Oracle DBA job is tough as compare to MS SQL DBA job:
Platform dependency – it’s necessary for oracle dba to have knowledge of multiple platforms from windows to all flavors of Unix from vendors such as IBM, Sun, HP, Digital, etc. whereas MS SQL is only operable on windows platform, a life of MS SQL dba is quite simple as compare to that of an oracle dba when it comes to administering databases on various platform.
Performance and Tuning – MS SQL is far behind when it comes to tuning the databases. Let have a glance at features that are uncommon to Oracle and MS SQL Server.
- In MS SQL, memory allocation is decided globally in the server properties memory folders, and that all applies for all memory and not caching and Therefore MS SQL dba has no control over sorting and caching memory allocation. Whereas Oracle architecture has its own large manageable instance. Hence Oracle dba has much real control over memory and has much more responsibility in tuning memory for better performance.
- In MS SQL, all pages are 8K and all extents are always 8 pages. This means that MS SQL dba has no choice to specify a larger extent to ensure contiguous space for large objects. On other had oracle has concepts of extents, hence it tasks of Oracle dba to ensure the contiguous space for a larger object by properly allocating extents as and when
- Following are some more feature that MS SQL lacks and those determine the tasks of concern dbas:
Partitioning. Bitmap Indexes.
Star query Optimization.
Reverse Key Indexes.
Real Application Cluster
Automatic Storage Management
The reason behind not having this feature may be making MS SQL Server self-tunable and less prone to human errors where the goal of the oracle would be to have total control over memory and utilize it as per requirements. Therefore we can surely say that to optimize the performance of database oracle dba has to work to have much more in-depth knowledge of memory structure, indexing, and various optimization levels as Operating systems, Networks, etc.
As said earlier Oracle has much more to offer. One such thing is cluster technology where Oracle is much more ahead than MS SQL. Oracle dba’s have continuously kept themselves updated with new technologies and even with each new release of database versions.
Technologies like Automated Storage Management, Oracle Real Applications Clusters(RAC) in oracle requires oracle dba to have knowledge about storage mechanisms and networks. In this case MS SQL dba need not worry about such things as MS SQL doesn’t have such things.
There are many such scenarios such as upgrading database to a newer release, migrating database between various database servers with the different operating systems, patching databases, etc, where oracle dba has to pay more attention when compared to MS SQL dba.
Here the simple comparison between features of Oracle and MS SQL themselves concludes that Oracle DBA job is tough than that of MS SQL dba. Right from having knowledge of the operating system, network, storage to the domain knowledge, that is the database itself Oracle DBA has many roles to play under one name and perform many tasks. Hence we can say that as Oracle outsmarts MS SQL, the same way Oracle dba outsmarts MS SQL dba.