What is the difference between DB2 and Oracle?

1, architecture, DB2 examples and database keyword separation practices, I am still a comparative favorite, because the instance can be created multiple, the recovery of the database directly to the instance can be, relatively more than Oracle.

2, Management things, DB2 management things do too rough, control center can only say can use it, and there are a lot of bugs, not as good as Oracle's company manager, even the web version did not.

3, backup management, DB2 Backup can only be said to be rude, there is no backup set of management functions, no recovery preview and verification function, can not write to the network drive, alas too many no, Oracle's Rman is indeed powerful;

4, DB2 instruction fulfillment method, I very much love, can perform the SQL on the instruction line, also can perform the SQL on the instruction window, the relative sqlplus is more sensitive;

5, DB2 the active protection function to do a very good, able to regularly take the initiative to clean up the database fragments and rebuild the index, only the less ambitious is the active protection of backup function can not specify a compressed backup, relatively Oracle's active protection function is very common;

6, the function of the operation of DB2 I also very much love, Oracle also has similar ahm, but the operation of DB2 more direct, can see what the database is currently in doubt, DB2 give the idea of how to dispose of the staff procedures;

7, DB2 memory monitoring function of the original I also love, can directly in the memory monitoring directly change the corresponding parameters, but found an infinite bug, I do not like, if you always point rewriting, found that memory consumption will continue to rise, I have a time in order to monitor a memory parameter, Let this thing run for a day and night, the result came back a look, fainted, all the memory parameters grew to hundreds of G, I want to see the history of the change situation unexpectedly did not.

8, DB2 the long-distance network to choose the cataloging method to depict the link string method I feel very uncomfortable, in order to change the client's connection server IP address, all the clients need to delete the catalog, and then from the beginning to catalog the link address, fainted more than 100 PC machine to get down, although the ability to use the script, But it's still driving people crazy. Oracle uses files to equip long-distance servers, all PCs are updated directly by the server tnsname,1 minutes.

9, DB2 database establishment if you want to craft management container, unexpectedly did not specify the default system tablespace data file name, you want to create piles corresponding file name, no way, had to copy Oracle's OFA architecture file name.

10, DB2 of the cohesion equipment graphics is really poor, in the above equipped with a step-by-step matching the cohesion can not be used! Using scripts, Oracle is much stronger than DB2.

11, DB2 in the Windows channel reliability is not good, 3 weeks without a 4-time machine, Oracle well-equipped probably not so miserable it.

12, DB2 lock active management mechanism, I compare love, opened, the probability of interlocking greatly reduced, the same procedure, in DB2 under the lock significantly less, but uncomfortable is DB2 's Select command is also locked.

13, DB2 9.7 of the Oracle compatible form, I also love, relocation trouble a lot less.

14, DEB2 active memory management I look better than Oracle, almost all of the memory parameters can be actively managed, oracle11g shape can be all active management.

15, DB2 the export data of things is too rough, even Oracle exp/imp are inferior, not to mention EXPDP/IMPDP

16, DB2 SQL sentence speed significantly faster than the oracle,5-6 section of the same code, the same machine, parameters are the default parameters, their own test DB2 performance speed is about 10%-15%, perhaps with the DB2 default parameter tuning, oracle10g tuning, There is still 5-10% at the mercy of the difference.