The Best Oracle Database 11g New Features

1RichNiemiec,RoltaTUSC()(Thanks:CarylLeeFisher,PaulDorsey,KenJacobs,DebbieMigliore,MariaColgan,LindaSmith)OracleDisclaimer:ThefollowingisintendedtooutlineOracle'sgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle'sproductsremainsatthesolediscretionofOracle.TheBestOracleDatabase11gNewFeaturesNewYork20092AudienceKnowledge/Versions•Oracle7Experience?•Oracle8iExperience?•Oracle9iExperience?•Oracle10gExperience?•OracleDatabase11gExperience?•Goals–PresentNEWfeaturesinanEASYway–FocusonafewnicefeaturesofOracle11g•Non-Goals–LearnALLaspectsofOracle11g3Overview•StartMeUp–UsingMemoryTarget•TheResultCache•InvisibleIndexes&OnlineIndexRebuilds•NiceDeveloperFeatures•ADDMEnhancements•SQLPlanManagementandSQLPlanBaselines•SQLQueryRepairAdvisor•SQLPerformanceAnalyzer•RealApplicationTesting(DatabaseCaptureandReplay)•IntervalPartitioning&PartitionCompression•DBAToolsandDBMS_STATSEnhancements•GridControl&EM•SecurityEnhancements&theFutureSizes•SummaryKnowtheOracle5OracleFirsts–Innovation!1979FirstcommercialSQLrelationaldatabasemanagementsystem1983First32-bitmodeRDBMS1984Firstdatabasewithreadconsistency1987Firstclient-serverdatabase1994Firstcommercialandmultilevelsecuredatabaseevaluations1995First64-bitmodeRDBMS1996Firsttobreakthe30,000TPC-Cbarrier1997FirstWebdatabase1998FirstDatabase-NativeJavaSupport;Breaks100,000TPC-C1998FirstCommercialRDBMSportedtoLinux2000FirstdatabasewithXML2001Firstmiddle-tierdatabasecache2001FirstRDBMSwithRealApplicationClusters2004FirstTrueGridDatabase2005FirstFREEOracleDatabase(10gExpressEdition)2006FirstOracleSupportforLINUXOffering2007Oracle11gReleased!62007:Version11gArrives•TheFocushasbeenAcquisitionsandgainingMarketShare•Oracle11gDatabaseextendsanalreadylargelead–EasiertoManagetheDatabase–BetterGridControl–SelfTuningthroughavarietyoftools(Makes1personequal10)–BetterSecurity/Encryption&RecoverabilityviaFlashback–BetterTestingTools(RealApplicationTesting)•AndyMendelsohnisstillthedatabaselead•NewreleasesofSiebel,PeopleSoftandOracle12Apps.•NewOracleBISuite&AcquisitionofHyperionTestingtheFutureVersionVersion11.1.0.6.0oftheDatabase8OracleDatabase11gRelease1:UpgradePathsSourceDatabaseTargetDatabase9.2.0.4.0(orhigher)11.1.x10.1.0.2.0(orhigher)11.1.x10.2.0.1.0(orhigher)11.1.xSourceDatabaseUpgradePathforTargetDatabaseTargetDatabase7.3.3.0.0(orlower)7.3.4.x--9.2.0.811.1.x8.0.5.0.0(orlower)8.0.6.x--9.2.0.811.1.x8.1.7.0.0(orlower)8.1.7.4--9.2.0.811.1.x9.0.1.3.0(orlower)9.0.1.4--9.2.0.811.1.xDirectUpgradePathIn-DirectUpgradePath9DatabaseUpgradeAssistant(DBUA)•CommandLineOptiontoAutoExtendSystemFiles•ExpressEditionUpgradetoothers•IntegrationwithOracleDatabase11gPre-upgradeTool•MovingDataFilesintoASM,SAN,andOtherFileSystems•OracleBaseandDiagnosticDestinationConfiguration10DatabaseUpgradeAssistant(DBUA)•DBUAchecksbeforetheupgrade:•Invaliduseraccountsorroles•Invaliddatatypesorinvalidobjects•De-supportedcharactersets•Adequateresources(rollbacksegments,tablespaces,andfreediskspace)•MissingSQLscriptsneededfortheupgrade•Listenerrunning(ifOracleEnterpriseManagerDatabaseControlupgradeorconfigurationisrequested)•OracleDatabasesoftwarelinkedwithDatabaseVaultoption.IfDatabaseVaultisenabled,DisableDatabaseVaultbeforeupgrade.11TheNewVersion–LifeisGood!$sqlplus***/***SQL*Plus:Release11.1.0.6.0-ProductiononTueOct3011:21:042007Copyright(c)1982,2007,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.1.0.6.0-ProductionWiththePartitioning,OLAP,DataMiningandRealApplicationTestingoptionsSQLstartupORACLEinstancestarted.TotalSystemGlobalArea422670336bytesFixedSize1300352bytesVariableSize306186368bytesDatabaseBuffers109051904bytesRedoBuffers6131712bytesDatabasemounted.Databaseopened.12DatabaseInformation-UP!MonitorDatabase(UP)UsersareDefinitelyUsingit!MEMORY_TARGET&AutomaticMemoryManagement14AutomaticMemoryManagement(AMM)MEMORY_TARGETin11g•FirsttherewassomeAutomaticMemoryMgmt-9i–SGA_MAX_SIZEintroducedin9i–DynamicMemory–NomoreBuffers–DB_CACHE_SIZE–Granulesizesintroduced-_ksm_granule_size•ThencameSGA_TARGET–10g–OracleApplicationsrecommendssettingthisforSGA–Setminimumsforkeyvalues(DataCache/SharedPool)15SGA&PGAwillbeMEMORY_TARGET16MovingfromSGA_TARGETto:MEMORY_TARGET-EMADDMEnhancements(AutomaticDatabaseDiagnosticMonitor)18ADDMenhancements•GlobalADDMsothatDiagnosticsaredoneacrosstheentirecluster•EmergencyADDMforusewhendatabaseishung•Onanygranularity–DatabaseCluster–DatabaseInstance–SpecificTarget(suchashost,ASM...etc.)•OveraspecifiedtimeNOTtiedtoapairofsnapshots19ADDMBrieflySpecificDatabaseInstanceWehave5ADDMFindingsCheckthemHere20ADDMBrieflyTopADDMFindingsClickaSingleTimeframeLet’sChecktheHardParseIssue21ADDMBrieflyDetailedInfo&FindingsAdd’lInfo22ADDM-RunNOW!ABigProblemOccursRunADDMNOW!23ADDM-RunNOW!AreyouSure?Running24ADDM–RunNOW!Done.CPUIssue25ADDM–RunNOW!D