Oracle Database 10g - New Features

Sessionid:40090OracleDatabase10g:TheSelf-ManagingDatabaseRichardSarwalVicePresidentOracleCorporationAgendayKeyManageabilityChallengesyOracle’sManagementApproachyManageabilityRevolution-OracleDatabase10gyWhatDoesItMeantoYou?yQ&AWhyisManageabilityImportant?ManagingITisManagingtheBusinessForCustomersyIncreaseinSize&ComplexityyHighAdministrationCostyUnacceptableFailureCostForISVPartnersyIncreaseinDeploymentComplexityyIncreaseinDevelopmentCostyHighSupportCost…….anditisgettingharder!Oracle’sManagementApproachCompleteManageabilitySolutionyManageentireinfrastructureyManagelargenumberofsystemsOracleeBusSuiteOracleCollabSuiteOracleiASOracleiASOracleiASGridControlOracle10iDatabaseOracle10iDatabaseOracleDatabase10gOtherApplicationsMakeSingleDatabaseEasytoManageyMakeRACEasytoManageyEnabletheGridyForApplicationISVPartnersyForEndUsersyForAllTypesofWorkloadOracleeBusSuiteOracleCollabSuiteOracleiASOracleiASOracleiASOracleDatabase10gOtherApplicationsGridControlManageabilityRevolutionUnprecedentedDevelopmentEffortySingle,biggesteffort–50%ofthearchitectsintheorganization–200+engineers–Gatheredcustomersfeedback–Active,focuseddevelopment–Notjustresearch!yWide-spreadeffort–ProjectsspanentiretechnologystackyLongtermcommitmentCreate&Configure12%LoadData6%OngoingSystemManagement55%SoftwareMaintenance6%Install6%WhereDBA’sspendtheirtimeSource:IOUG2001DBASurveyInstall6%Create&Configure12%WhereDBA’sspendtheirtimeLoadData6%OngoingSystemManagement55%SoftwareMaintenance6%Source:IOUG2001DBASurveySoftwareInstallationyFastlightweightinstall–Majorredesignofinstallationprocess–SingleCD,20Minutes–CPU,memory,diskspaceconsumptiongreatlyreduced–Extremelylightweightclientinstall(3files)usingOracleInstantClientyAutomationofAllPreandPostInstallSteps–ValidateOSConfiguration,patches,resourceavailabilityetc.–Configureallcomponents(listeners,database,agent,OMS,OIDetc.)forautomaticstartupandshutdownyEnhancedsilentinstallSimplifiedCreation&ConfigurationyGreatlyreduceddatabasecreationtimeusingpre-configured,ready-to-usedatabasey90%reductionofinitializationparameters:30BasicparametersyAutomaticallysetupcommontasks,e.g.backupsyAutomaticallyconfiguresLDAPserveryAutomaticSharedServerSet-upyEasyConnectNamingBasicParametersycompatibleyprocessesysessionsypga_aggregate_targetyynls_languageynls_territoryydb_domainyshared_serversyinstance_numberycluster_databaseydb_block_sizeysga_targetcontrol_filesydb_nameydb_recovery_file_destyremote_listenerydb_recovery_file_dest_sizeydb_create_online_log_dest_nydb_create_file_destylog_archive_dest_nylog_archive_dest_state_nyremote_login_passwordfileydb_unique_nameSimplifiedUpgradeyPreupgradechecks(e.g.parametersettings)yPostupgradestatuschecksyTimeestimatoryRe-startableyGuideadministratorsinusingbestpracticesOut-of-the-BoxDatabaseControlyNoseparateinstallyFullyfunctionaladministrationandmonitoringafterdatabasecreationyListenerdiscovery,configuration&monitoringSeamlessOut-of-the-BoxExperienceyFast,lightweightInstallySimplifiedCreate&ConfigureySimplifiedUpgradeyOut-of-the-boxDatabaseControlLoadData6%OngoingSystemManagement55%SoftwareMaintenance6%WhereDBA’sspendtheirtimeInstall6%Create&Configure12%Source:IOUG2001DBASurveyEfficientDataLoadOracleDatabase10gyDataPump–60%fasterthanExport(singlestream)–15X-20XfasterthanImport(singlestream)–AutomaticParallelism–multiplestreams–Re-startable–SizeestimationonexportdumpfilesyCrossPlatformTransportableTablespacesLoadData6%OngoingSystemManagement55%SoftwareMaintenance6%WhereDBA’sspendtheirtimeInstall6%Create&Configure12%Source:IOUG2001DBASurveyOngoingSystemManagement55%ofDBA’stimeisspentinongoingmanagement,monitoringandtuning1.PerformanceDiagnosis&Troubleshooting2.Space&ObjectManagement3.SQL&ApplicationTuning4.SystemResourceTuning5.BackupandRecoverySource:IOUG2001DBASurveyManageabilityChallenges-TodayExternalStorageManagementDiskConfigurationStripeSizeDataRedistributionInternalSpaceManagementTablegrowthtrendSpacefragmentationBackup&RecoveryManagementTapes,MTTRDisasterRecoveryApplication&SQLManagementOptimizerStatsResponsetimeThroughputSchema/IndexSystemResourceManagementCPUUtilizationMemoryPoolsProcessesOracleDatabase10g–Self-ManagingDatabaseIntelligentInfrastructureApplication&SQLManagementSystemResourceManagementSpaceManagementBackup&RecoveryManagementStorageManagementDatabaseManagementDatabaseControlIntelligentInfrastructureAutomaticWorkloadRepositoryAutomaticMaintenanceTaskInfrastructureServer-generatedAlertInfrastructureAdvisoryInfrastructureyAutomaticWorkloadRepository–“DataWarehouse”oftheDatabase–CodeinstrumentationyAutomaticMaintenanceTasks–Pre-packaged,resourcecontrolledyServer-generatedAlerts–Pushvs.Pull,Just-in-time,Out-of-the-boxyAdvisoryInfrastructure–Integrated,uniformityAutomaticDatabaseDiagnosticMonitor(ADDM)yPerformanceexpertinaboxyIntegrateallcomponentstogetheryAutomaticallyprovidesdatabase-wideperformancediagnostic,includingRACyProvidesimpactandbenefitanalysisyProvidesInformationvs.rawdatayRunsproactivelyyReal-timeresultsusingtheTimeModelIntelligentInfrastructureApplication&S