ComparingOracleDatabasePerformanceintheCloudApril2nd,2020AccentureEnkitecGroup10.
000+hoursof24x7on-callDBAFirstOracleCertifiedMasterinEurope:2002OracleACEDirectorMasterTechnologyArchitectMasterDataArchitectDatabaseBlogat:juliandontcheff.
wordpress.
comCopyright2019Accenture.
Allrightsreserved.
3COMBININGCLOUDANDMACHINELEARNINGINTOTHEWORLD'SFIRSTSELF-DRIVING,AUTONOMOUSDATABASETHEORACLEAUTONOMOUSDATAWAREHOUSECLOUD:ACCENTURETESTEDTHEAUTONOMOUSDATAWAREHOUSECLOUDONAREALAPPLICATION,RUNNINGREAL-WORLDWORKLOADS–TestsperformedatmultipleAccenturelocationsandinnovationcenters–ConductedbyateamofAccenture'sOracledataspecialists–DatareplicatedonboththeOracleDatabaseCloudServiceandtheAutonomousDataWarehouseCloudCANTHEWORLD'SFIRSTAUTONOMOUSDATABASEUNLEASHTHEINTELLIGENTENTERPRISECopyright2019Accenture.
Allrightsreserved.
4EXTREMELYFASTTESTINGSHOWEDSIGNIFICANTSPEEDIMPROVEMENTInserting500millionrowsofdatatooklessthanthreeminutes,onaverage1.
6xperformanceimprovementcomparedtopublishedfindings14xperformanceaccelerationFEATURECOMPARISONCopyright2019Accenture.
Allrightsreserved.
6DATABASEPROVISIONINGSCALEUP/DOWNHARDWAREMANUALINSTALL*DBCSADWCPHYSICALHARDWAREDBCSADWC101SECONDS58SECONDS4HOURS1HOUR30MINUTESNotpossibleasthehardwareisnotelastic*assumehardwareisalreadyprocuredDatabaseisdownwhilescalingishappeningDatabaseremainsactivewhilescalingishappeningTESTINGAPPROACHCopyright2019Accenture.
Allrightsreserved.
7UtilizinganexistingcloudbasedanalyticsapplicationcalledPRETT[PlatformResourceEnablementTrackingTool]runningonOACS[OracleAnalyticsCloudService].
DatawillbereplicatedinDBCSandADWCtoprovideareallifeapplicationusageexperienceThedatawillthenbeextrapolatedandexpandbasedonthatexistingapplicationtosimulateADWCfunctionality.
SPRINT1SPRINT2BASELINEEXTRAPOLATECompareliketolikedatavolumeinOACS[DBCS]toOACS[ADWC]3MonthDatavolumeRunandcompareperformanceinOACS[ADWC]andcomparewithbaselineOACS[DBCS]informationCreate9yearsofdataonADWCbasedonthe3monthlivedatatothencompareperformanceonhighvolumedata.
TESTINGRESULTSSPRINT1SPRINT2BASELINEEXTRAPOLATEADWCISCONSISTENTLYPERFORMINGFASTERAVERAGERUNTIMEAVERAGERUNTIME1.
63x1.
72xCopyright2019Accenture.
Allrightsreserved.
8ORIGINALARCHITECTURECopyright2019Accenture.
Allrightsreserved.
9US2–CHICAGODATACENTERANALYTICSCLOUDSERVICEORACLEDATABASECLOUDSERVICEARCHITECTUREUSINGADWCCopyright2019Accenture.
Allrightsreserved.
10US2–CHICAGODATACENTERANALYTICSCLOUDSERVICEORACLEDATABASECLOUDSERVICEASHBURNDATACENTERMETADATAONLYAUTONOMOUSDATAWAREHOUSECLOUDFourAreasofSelf-SecuringofAutonomousDatabasesAdministratoractivityonOracleAutonomousDataWarehouseCloudisloggedcentrallyandmonitoredforanyabnormalactivities.
Oraclehaveenableddatabaseauditingusingpredefinedpoliciessothatcustomerscanviewlogsforanyabnormalaccess:UNIFIED_AUDIT_TRAILSelf-securingstartswiththesecurityoftheOracleCloudinfrastructureanddatabaseservice.
Securitypatchesareautomaticallyappliedeveryquarterorasneeded,narrowingthewindowofvulnerability.
Patchingincludesthefullstack:firmware,operatingsystem[OS],clusterware,anddatabase.
Therearenostepsrequiredfromthecustomerside.
Oracleencryptcustomerdataeverywhere:inmotion,atrest,andinbackups.
Theencryptionkeysaremanagedautomatically,withoutrequiringanycustomerintervention.
Andencryptioncannotbeturnedoff.
BuiltuponOracleDatabaseVault,uniquetoOracleCloud,operationspersonnelhaveprivilegetodoalladministrativetaskswithoutanyabilitytoeverseeanycustomerdataFourAreasofSelf-AutomationofAutonomousDatabasesAutomaticFaultTolerantFailover:RACandDataGuardAutomaticallykillrun-awaytransactionsandSQLAutomaticallykillinactivesessionAutomaticprovisioning:pluggabledatabasesAutomaticscaling:PDBresourcemanagerAutomatictuning:SQLPlanManagement,AdaptivePlans,SQLTuningAdvisor–AutomaticSQLTuning,StorageIndexes,AutomaticStorageManagement,Automaticdetectionandcorrectionofregressionsduetoplanchanges,Automaticallytunememory,process,sessionsAutomaticBackupandRecovery:RMAN,FlashbackSevenAreasofSelf-RepairingofAutonomousDatabases2019AccentureAllrightsreserved.
1519c:whyautomatingindexcreationinthedatabaseForaverylongtime,bothDBAsandDevelopers,havebeenstruggling(reallystruggling)withwhatindexesshouldbecreated,whattypeofindexestheyshouldbecreatedasandwhatindexesshouldbedroppedfromthedatabaseByfar,themostinterestingnewfeatureofOracleDatabase19cisAutomaticIndexcreation(AICreation)Inthelongrun,thisistobeoneofthemostimportantfeaturesintheOracledatabase2019AccentureAllrightsreserved.
1619c:MachineLearningandArtificialIntelligenceintheDBOraclefirstcreateinvisible-invalidindexesusingdbms_stats.
report_col_usageThentheytest-parseSQLintheSQLtuningsettoseeifitwillusetheindexes-becauseatthisstageOraclehavecandidateindexesbutOraclewon'tyetknowiftheystandachanceofactuallybeinguseful-iftheSQLdoesusetheindexes,thenOraclemaketheminvisible-validThentheytestexecutethequeriesinSPA(allowingtheSQLtoseetheinvisible-validindexes)andtheychecktoseeiftheyrunbetterwiththeseproposedindexes-iftheydo,thenwecanmakethevalidindexesvisibleIntheorywecangetanewbatchofvisibleindexesevery15minutesFourAreasofdifferencesbetweenADWandATPInADW:statisticsareautomaticallymaintainedaspartofbulkloadandDBMS_CLOUDactivitiesInATP:statisticsareautomaticallygatheredwhenthevolumeofdatachangessignificantlyenoughtomakeadifferencetothestatisticsInADW:themajorityofthememoryisallocatedtothePGA–joins,aggregationsinmemoryInATP:themajorityofthememoryisallocatedtotheSGA–minimizeI/OInADW:dataisstoredinacolumnarformatasthat'sthebestformatforanalyticsprocessing-ADWusesDBIMoptionfeatureslikein-memorycolumnarflashcacheunderthecoversInATP:dataisstoredinarowformatInADW:onlyoneservice(LOW)automaticallyrunsSQLstatementsserially,allisparallelInATP:thePARALLELservicedoesnolongerexist(asof12.
11.
2018)ATP-DgenerallyavailablesinceJune18th,2019ATP-DgenerallyavailablesinceJune18th,2019FourAreasofhowATP-Disdifferent-LoadingdatafromobjectstoresviaDBMS_CLOUDistherecommendedmethodforloadinglargedatasets-DBMS_CLOUDtoloaddataisnotapplicableforATP-DbecauseDBMS_CLOUDisnotavailableonATP-D-PrivateIPsarenotyetsupportedforserverlessADBdeploymentsbuttheyareontheshort-termroadmap-PrivateIPsaresupportedwithATP-Dedicated-ADB(serverless)doeshaveauto-scaling-youcanselectautoscalingduringprovisioningorlaterusingtheScaleUp/DownbuttonontheOracleCloudInfrastructureconsole-ATP-Ddoesnothaveauto-scalingsupport-InADB-D,thedatabaseversionis19cwhichisrequiredforAuto-Indexingwhichisonbydefault-Supportfor19cand20c/Auto-IndexingonATP-SisontheroadmapNewPerformanceTests:OracleADWandMajorCloudDWNevertheless,OracleADWessentiallymatchedorexceededthatperformanceinthesmallandmediumscenarios,anditclearlyexceededitinthelargescenarioOtherCloudDWsareasolidofferingthatperformedwellinthetests,especiallyinthesmallercloud-anddata-sizescenariosWithitsdata-cachingandparallel-executioncapabilities,theyshowedperformanceaboveandbeyondthatwhichwouldbeexpectedfromatraditionaldatabaseengineAtthesametime,whenitcomestoheavyworkloadsADWdelivershigherperformanceatmuchlowerscostsWithitswinningperformance/costratio—andtheoperationaladvantagesofferedbyitsextensiveautonomouscapabilities—OracleADWshouldbeconsideredbycompaniesthatwanttoruntheirenterprisedatawarehouseinthecloudAccentureNewPerformanceTestsAclientTCOanalysisTCOSavingsforAutonomousDataWarehouseYear1Year2through5DescriptionAssociatedCostonPremises(130Cores)AssociatedAutonomousDWCost(92Cores)AssociatedCostonPremises(130Cores)AssociatedAutonomousDWCost(92Cores)5xExadata1/4racks(130cores)(25%Discount)$1,262,250Included$0IncludedHardwareandOSSupport$252,450Included$252,450IncludedOracleEE,RAC,Partitioning,Diagnostics(@60%discount)(65licenses)$2,522,000$394,260$0$394,260AnnualSupportforDBandoptions$554,840included$554,840IncludedExadataStorage(480TB)(60%Discount)$720,000$0$0$0ExadataStorageSupport$158,400$0$158,400$0ADWStorage(8TB)$0$21,310$0$21,310Labor–FTE@$165,000ea.
$495,000$247,500$495,000$247,500Datacenter$54,000Included$54,000IncludedNetworkCosts$15,600$31,200$15,600$31,200OracleFastConnect$11,385$11,385TotalCost$6,034,540$705,655$1,530,290$705,65588%TCOYear154%TCOYears2–5Copyright2019Accenture.
Allrightsreserved.
SPEED:FEELTHENEEDCopyright2019Accenture.
Allrightsreserved.
25vCPUMemoryDiskTypeDiskSizeORACLECLOUDINFRASTRUCTURE16(8OCPU)120GBNVMESSD6.
4TB#ACCENTUREOOW19LEADINGCLOUDPROVIDER16128GBSSD1TBAUTONOMOUSDATAWAREHOUSE16(8OCPU)Exadata1TBAUTONOMOUSDATAWAREHOUSE4(2OCPU)Exadata1TBAUTONOMOUSDATAWAREHOUSE651,26411,9752,453QueriesperHourMONEY:MAKEITWORKCopyright2019Accenture.
Allrightsreserved.
26QueriesperHourTermCommitmentAnnualIaaSCostAnnualOracleDBSupportAnnualInfrastructure+OracleDBCostORACLECLOUDINFRASTRUCTURE1,264None$8,928$55,000*$63,928LEADINGCLOUDPROVIDER653Years$5,352$110,000*$115,352AUTONOMOUSDATAWARELARGER11,9753Years$101,580AUTONOMOUSDATAWASMALLER2,453None$46,812AUTONOMOUSDATAWAREHOUSE*DatabaselicensingonlyincludesOracleDatabaseEnterpriseEditionandAdvancedSecurityAUTONOMOUSDATAWARELARGER$101,58011,975$11.
60$0.
0010AUTONOMOUSDATAWARSMALLER$46,8122,453$5.
34$0.
0022AUTONOMOUSDATAWAREHOUSEVALUE:MOREFORLESSCopyright2019Accenture.
Allrightsreserved.
27AnnualTotalCostQueries/HourCost/HourCost/QueryPatchingforSecurityORACLECLOUDINFRASTRUCTURE$63,9281,264$7.
30$0.
0058#ACCENTUREOOW19LEADINGCLOUDPROVIDER$115,35265$13.
17$0.
2026Real-TimeDays/Weeks/MonthsDays/Weeks/MonthsORACLERUNSBESTONORACLECLOUDREADTHESTUDYAT:accenture.
com/adbREADTHETECHVISION:accenture.
com/tvo
Hostadvice主机目录对我们的服务进行了测试,然后给PQ.hosting颁发了十大WordPress托管奖。为此,宣布PQ.Hosting将在一周内进行折扣优惠,购买和续订虚拟服务器使用优惠码:Hostadvice ,全部优惠10%。PQ.hosting,国外商家,成天于2019年,正规公司,是全球互联网注册商协会 RIPE 的成员。主要是因为提供1Gbps带宽、不限流量的基于KVM虚拟的V...
舍利云怎么样?舍利云推出了6核16G超大带宽316G高性能SSD和CPU,支持全球范围,原价516,折后价200元一月。原价80美元,现价30美元,支持地区:日本,新加坡,荷兰,法国,英国,澳大利亚,加拿大,韩国,美国纽约,美国硅谷,美国洛杉矶,美国亚特兰大,美国迈阿密州,美国西雅图,美国芝加哥,美国达拉斯。舍利云是vps云服务器的销售商家,其产品主要的特色是适合seo和建站,性价比方面非常不错,...
春节期间我们很多朋友都在忙着吃好喝好,当然有时候也会偶然的上网看看。对于我们站长用户来说,基本上需要等到初八之后才会开工,现在有空就看看是否有商家的促销。这里看到来自HMBcloud半月湾服务商有提供两款春节机房方案的VPS主机88折促销活动,分别是来自洛杉矶CN2 GIA和日本CN2的方案。八八折优惠码:CNY-GIA第一、洛杉矶CN2 GIA美国原生IP地址、72小时退款保障、三网回程CN2 ...
serverless为你推荐
甲骨文不满赔偿如果合同期不满被单位辞退,用人单位是否需要赔偿www.yahoo.com.hk香港的常用网站porntimesexy time 本兮 MP3地址斗城网女追男有多易?喜欢你,可我不知道你喜不喜欢我!!平安夜希望有他陪我过partnersonline电脑内一切浏览器无法打开haole012.com说在:012qq.com这个网站能免费挂QQ,是真的吗?javlibrary.comsony home network library官方下载地址www.gogo.comNEO春之色直径?汴京清谈汴京还被称为什么?干支论坛天干地支常识?
网站空间免备案 什么是虚拟主机 国内最好的虚拟主机 美国linux主机 备案域名出售 科迈动态域名 smartvps 个人免费空间 宁波服务器 域名接入 卡巴斯基试用版 双线机房 服务器是干什么用的 中国电信网络测速 lamp架构 阿里云邮箱登陆地址 免费网络空间 江苏徐州移动 域名和主机 cdn服务 更多