Oracle 11g


Comparing Database Terms tutorials
-
Following table shows the comparison between oracle 11g and SQL Server 2012.
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 |