Answer the question
In order to leave comments, you need to log in
What are the main advantages of ORACLE DBMS?
What is the advantage of oracle over the same microsoft sql and other competitors?
Answer the question
In order to leave comments, you need to log in
the first advantage in the language, PL/SQL is at least a decade ahead of anyone. neither IBM nor Microsoft has a package into which code can be combined, no dependency tracking, no row level triggers, no %ROWTYPE %TYPE analogs, and a million other things. those. heavy logic in PL/SQL is more convenient to write.
the second big advantage is that oarkle is initially correct versioning, everything is very successful and correct in the inside. there versioning is at the page level, the locking attribute of the data and not in memory swells, there UNDO is a separate structure that does not require vacuum, etc. while the core is well debugged and optimized decades ago. IBM blocker, dies from the abundance of locks and deadlocks, Microsoft tried to get away from blockers, made an IL snapshot but from the side of the kernel. row versions in tempdb require vacuum. generally weak.
Third, amazing scalability: Oracle has the only truly working cluster on which serious companies run OLTP tasks. no one else has an OLTP cluster, there is a marketing bullshit, but in reality telecoms and banks only have oracle clusters for OLTP tasks.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question