enabledserverless

serverless  时间:2021-03-26  阅读:()
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

萤光云(16元/月)高防云服务器自带50G防御

螢光云官網萤光云成立于2002年,是一家自有IDC的云厂商,主打高防云服务器产品。在国内有福州、北京、上海、台湾、香港CN2节点,还有华盛顿、河内、曼谷等海外节点。萤光云的高防云服务器自带50G防御,适合高防建站、游戏高防等业务。本次萤光云中秋云活动简单无套路,直接在原有价格上砍了一大刀,最低价格16元/月,而且有没有账户限制,新老客户都可以买,就是直接满满的诚意给大家送优惠了!官网首页:www....

Hosteons - 限时洛杉矶/达拉斯/纽约 免费升级至10G带宽 低至年$21

Hosteons,一家海外主机商成立于2018年,在之前还没有介绍和接触这个主机商,今天是有在LEB上看到有官方发送的活动主要是针对LEB的用户提供的洛杉矶、达拉斯和纽约三个机房的方案,最低年付21美元,其特点主要在于可以从1G带宽升级至10G,而且是免费的,是不是很吸引人?本来这次活动是仅仅在LEB留言提交账单ID才可以,这个感觉有点麻烦。不过看到老龚同学有拿到识别优惠码,于是就一并来分享给有需...

[6.18]IMIDC:香港/台湾服务器月付30美元起,日本/俄罗斯服务器月付49美元起

IMIDC发布了6.18大促销活动,针对香港、台湾、日本和莫斯科独立服务器提供特别优惠价格最低月付30美元起。IMIDC名为彩虹数据(Rainbow Cloud),是一家香港本土运营商,全线产品自营,自有IP网络资源等,提供的产品包括VPS主机、独立服务器、站群独立服务器等,数据中心区域包括香港、日本、台湾、美国和南非等地机房,CN2网络直连到中国大陆。香港服务器   $39/...

serverless为你推荐
安徽汽车网安徽省各地车牌号简称是按照什么顺序排的firetrap我淘宝店还是卖二单就被删,怎么回事!www.kkk.comwww.kkk103.com网站产品质量有保证吗长尾关键词挖掘工具怎么挖掘长尾关键词,可以批量操作的那种www.baitu.com谁有免费的动漫网站?广告法有那些广告法?还有广告那些广告词?广告法新修订的《广告法》有哪些内容www.zhiboba.com看NBA直播的网站哪个知道www.ijinshan.com在电脑看港台电视台那个网站最好而又不用钱速度又快ww.66bobo.com这个WWW ̄7222hh ̄com是不是真的不太易开了,换了吗?
美国vps评测 金万维动态域名 bbr 狗爹 mediafire 59.99美元 美国主机论坛 抢票工具 回程路由 NetSpeeder 免费网站申请 免费个人空间申请 阿里云浏览器 vip购优汇 cdn联盟 腾讯实名认证中心 卡巴斯基试用版 爱奇艺vip免费领取 789 英国伦敦 更多