Feature
|
Oracle 11g
|
SQL Server 2012
|
Supported Platform
|
All Unix/Linux Certified Platform Windows Server
|
Windows Server, Windows Sever Core
|
Shared Storage not Needed
|
Yes
|
Yes
|
Replication from the Data
|
Yes
|
Yes
|
Replication from the Service
|
Yes
|
Yes
|
Which component are replicated
|
Instance and database
|
Only database(jobs and system table are not replicated)
|
Automatic Failover
|
Yes(Observer & Fast-Start Failover)
|
Yes (Availability Groups)
|
Logical data storage terminology:
|
Oracle, DB2 and other RDBMS products call this logical storage a
"tablespace"
|
SQL Server uses the term "page" and "file group" to
refer to a unit of storage.
|
Data Blocks:
|
block sizes can range from 2K to 32K,
|
SQL Server, being constrained by Windows, must use 8 K blocksizes (8k
"pages").
|
Listener process:
|
Oracle uses an independent daemon process called a
"listener" to manage incoming connects to Oracle
|
SQL Server has no listeners.
|
Storage
|
block
|
page
|
metadata
|
Data dictionary
|
SYS database
|
Language
|
PL/SQL
|
T-SQL
|
