SQL Server与Oracle的一些比较

http://www.thatjeffsmith.com/archive/2010/12/oracle-vs-sql-server-take-ii/

Technical Jargon

Microsoft SQL ServerOracleinstance (server)databasedatabaseschemaschemaNo direct equivalent.loginuseruseruserpermissionprivilege (priv)indexed viewmaterialized view (snapshot)T-SQLPLSQL (mostly)Error LogsAlert LogLog fileRedo LogsExecution PlanExplain PlanRe-CompilesFLUSH SGA (wipes out ALL cached plans)
OR in 10/11g use baseline control (not nearly as common)

The underlying fundamentals of a RDBMS hold true for both SQL Server and Oracle. If you ‘know’ one, you will be able to transition into another. Some things are actually exactly the same but have different names. Others are similar but have their own twist in implementation or architecture. Clustering and HA are examples of where you would see major differences, and partitioning would be a place where you’d have only minor differences (other than available partitioning schemes in SQL Server).

Tools

Microsoft SQL ServerOracleSSMSOEMQuery AnalyzerSQL DeveloperServer Side TraceDBMS_SYSTEM|Monitor|Support + tkProfProfilerOEM can be used to start a trace.Maintenance PlanNo direct equivalent. (jobs?)DMVSYS ViewDefault TracesNo direct equivalent.SSISOBIEEPowerShellSH (*NIX)ClusteringRAC (kind of, but not really)Log Shipping?MirroringStreams|Data Guard|GoldenGate

More GUIs from Microsoft – surprise, surprise! More packages and command-line tools from Oracle. However this is quickly evolving. Also, I doubt that this point rarely surfaces as the deal-breaker when it comes to choosing one platform over the other. It’s more of an issue for the people who get to support the database after-the-fact.

Community

Microsoft SQL ServerOracleMSDNOTNPASSODTUG|IOUG|UKOUG|…PASS SummitOracle Open WorldPASS ChaptersLocal Oracle User Groups (independent)
RMOUG, SOUG, …SQLBitsUKOUG Annual ConferenceSQL SaturdayNo direct equivalent.SQL Server CentralOraFaq|OTNSQLServerPediaOraDBPediaBuck Woody|Paul Randall|Brent Ozar…Tom Kyte|Cary Milsap|Alex Gorbachev…#SQLHELP#ORACLEHELP (barely)SQL MVPOracle ACE

Both communities are mature, strong, and active. The major difference I see is the major fragmentation on the Oracle side. I would say this is due a combination of factors, but the amount of time is probably the biggest one. I would say that PASS in 10 years will look drastically different today, and would not be surprised if it starts to splinter into different groups. Don’t assume that because there is no unifying ‘PASS’ that local groups of Oracle professionals do not congregate. There are many, and they are very dedicated.