enabledserverless

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