Oracle 常识

OracleEERACSERAC----------------------------SERAC4(Processor)(Cluster)()EERAC(Scalability)SEEEEESERACOracleASM(AutomaticStorageManagement)EERAC(ClusterFileSystem)RACSERACOracleEERACOracle(3rdpart)OracleEESE----------------------------EESE(capability)EE80GBSE500GBEESESE(Parallel)EE(HighPerformance)(HighAvailability)(AdvancedSecurity)(analysis)Oracle----------------------------IT5:)Oracle19771979Oracle2,(RDBMS)1982Oracle3,(DB2,SQLServer,Sybase)1984Oracle4,(DB2,SQLServer,Sybase)1985Oracle5,/(C/S)1988Oracle6,(DB2,SQLServer,Sybase)1989Oracle6.2,OracleParallelServer(OPSRAC)1992Oracle7,1997Oracle8,1999Oracle8iR1(8.1.5,iisInternet)2000Oracle8iR2(8.1.6)Oracle8iR3(8.1.7)2001Oracle9iR1(9.0.1),RAC(RACOPS)2002Oracle9iR2(9.2.0)2004Oracle10gR1(10.1.0,gisGrid)2005Oracle10gR2Oracle2000OracleApplicationServer(OAS)InternetApplicationServer(iAS)2000Oracle8iApplicationServer(8iAS)2002Oracle9iApplicationServer(9iAS)2003Oracle10gApplicationServer(10giAS)R12004Oracle10gApplicationServer(10giAS)R2OracleFormsReportsDiscoverer1996Developer/20001999Developer62000Developer6i(6.0.8)2002InternetDeveloperSuite9i(iDS,JDeveloper)2003InternetDeveloperSuite10gWebJavaJDeveloperFormsReportsFormsReportsOracleEE----------------------------EE(scalability)(availability)(security)EE“RAC”“”(Partitioning)“OLAP”“”(DataMining)“”(Spatial)“”(AdvancedSecurity)“”(LabelSecurity)(replication)OracleEE----------------------------OracleRACRAC(Certified)OracleSE,SE1----------------------------SE4(Processor)SE12SERACSE1RACOracleEESE----------------------------EESEEESEEE(Incrementalbackupandrecovery)(Parallelbackupandrecovery)SEEEDateGuard(mirror)SEEE(Block-levelmediarecovery)SERAC/(Active/Standby)RAC----------------------------RAC/RACRAC/RAC(Failover)/RAC/(DiskArray)HA(HighAvailability)DataGuard(DiskArray)/(Active/Standby)----------------------------DataGuardOracleEE/HA(HighAvailability)/OracleDataGuard/(mirror)(resumefrombreakpoint)/HA(PartitioningOption)----------------------------“”15GB(Partitioning)(Reliability)(Parallel)15iDS----------------------------Oracle(iDS)JavaXMLWeb(BI)(OLTP)(Portal)Web(WebService)(Wireless)OEMPacks----------------------------DBA(DiagnosticsPack)(HighAvailability)ADDM(TuningPack)Oracle(ChangeManagementPack)OracleDB2MSSQLServer----------------------------OracleIBMMSOraclehttp://www.oracle.com/technology/products/manageability/database/pdf/Competitive/edison%20study%20sumary.pptOracleRAC(DiskArray)DB2MSSQLServerOracleOracle(DirtyRead)DB2MSSQLServerOracle(unblock)(rowlevellock)DB2MSSQLServer(block)(locksescalate)OracleOracle9i8i----------------------------9i8iOPS9iRAC8i9i(CacheFusion)1009i8i8i9i9i8iANSISQL999i8i(Fast-start)8i(physicalbackup)9i(logicalbackup)Oracle10g9i----------------------------10(Grid)(AutomaticManagement)10ggGrid(LoadBalance)(SinglePointofFaliure)9i(EnterpriseManager)(ASM)OracleASMSQLHTMLDB(Flashback)(DataPump)15--45(Fine-GrainedAuditing)(Tablespace)(Streams)(double-direction)(resumefrombreakpoint)(crossplatform)Oracle9i10g----------------------------9i10g10g9i10g9i9i10g9i10g9i(Platform)----------------------------(OS)(Hardware)OracleOracle(bit)CPU3264OraclexxxxOracle3264----------------------------OracleWindowsLinux32WindowsLinuxUnixUnix6464OracleUnixOracle10g649i8i6432“64bit”6432Oraclexxxxyyyy----------------------------Oracle10g(DualCore)/(MultiCore)CPU(HyperThreading)(Processor)----------------------------(Processor)CPU“”“”(Core=Processor)/CPUCPU(*0.75)“”Oracle(upgrade)----------------------------OracleDatabase(instance)----------------------------DatabaseOracleDatabase“Database”OracleDatabaseCPULicenseOracle----------------------------OracleLicenseOracleLicenseOracleLicense+86-10-65386688x301Oracle----------------------------TPCOracleOracleOracleOracleTimesTen----------------------------TimesTen(in-memorydatabase)(real-time)OracleOracleDBTimesTenOracleDBiASTimesTenAmdocs(AspectCommunications)(Avaya)JP(JPMorgan)NEC(Sprint)----------------------------(Close)Oraclehttp://www.oracle.com/global/cn/support/index.html“Oracle”“”www.oracle.com/global/cn/support/1_SPS_CN_Final.pdfOracle(CSI,10)8008100366(010-65386688)OracleOracle(CSI)CSIOraclehttp://metalink.oracle.com(RDBMS)----------------------------Excel(Sheet)(Oracle,SQLServer,DB2)OracleEE(,EnterpriseEdition),SE(,StandardEdition),SE1(1,StandardEditionOne)----------------------------1.SE1SEEESEEEEE(Partitioning)(OLAP)(DataMining)(AdvancedSecurity)2.10gSE(RAC)4CPU(CFS)(,Veritas)(RawDevice)EE3.SE/DML(ParallelQuery/DML)/(Parallelbackupandrecovery)CPUSECPUEECPU(loadbalance)/SE4.SE(Incrementalbackup)EE5.SESEEE(FlashRecovery)(Block-levelmediarecovery)6.SEEEDataGuardSE(BasicReplication)EE(AdvancedReplication)7.SEEE(Transportabletablespaces)8.SESE1500GBEE8,000,000,000GB(80GB)EE(Compression)I/O9.SEEE10.(RowLevelSecurity)(auditing)SEEE(FineGrainAccessControl)(Finegrainedauditing)(GridComputing)----------------------------——————————OracleMySQLPostgreSQLIngresCach----------------------------IDC2004Oracle41%MySQLPostgreSQLIngresCach“”----------------------------Oracle2005“Yahoo!()”