Proac Ve*Oracle*Database*Monitoring*And*

Transcription

Copyright 2016SplunkInc.Proac plunkTylerMuthAnaly csArchitect,SplunkPublicSectorCollateral- ‐bit.ly/conf16- ‐tmuth

DisclaimerDuringthecourseofthispresenta eeventsortheexpectedperformanceofthecompany.Wecau onyouthatsuchstatementsreflectourcurrentexpecta onsandes containedinourforward- eSEC.Theforward- ‐lookingstatementsmadeinthethispresenta onarebeingmadeasofthe meanddateofitslivepresenta on.IfreviewedaReritslivepresenta on,thispresenta onmaynotcontaincurrentoraccurateinforma on.Wedonotassumeanyobliga ddi on,anyinforma onaboutourroadmapoutlinesourgeneralproductdirec onandissubjecttochangeatany mewithoutno ce.Itisforinforma ontractorothercommitment.Splunkundertakesnoobliga oneithertodevelopthefeaturesorfunc onalitydescribedortoincludeanysuchfeatureorfunc onalityinafuturerelease.bit.ly/conf16- ‐tmuth

WhoAmI? WroteAWR- maZerbit.ly/conf16- ‐tmuth

WhySplunkforOracle?SecurityConfigura onManagementbit.ly/conf16- AnalysisSingle- ‐PaneViewof“Applica on”

conf16- ‐tmuthTAUnixTablesDic onaryCustom

HowCanYouSplunkIt?Add- nkAdd- ularInput(in- Tablesbit.ly/conf16- ‐tmuthExachkTablesDic onaryCustom

eCapacityPlanning Configura5onManagement tracefiles AuditFiles Auditsyslog AuditTables Dic onaryTables CustomTables OS–TAUnix OS–OSWatcher/Exawatcher Exadata- ‐exachk Exadata–Cellmetrics bit.ly/conf16- ‐tmuthErrorAnalysis

DemoArchitecturenginx proxyloadbalancerTomcat VM (APEX)2 Cores 8 GB RAMjMeterswingbenchTomcat VM (APEX)2 Cores 8 GB RAMExadataDB NodeSplunkDB NodeDB ConnectHTTP EventCollector HECStorage CellStorage CellStorage Cellbit.ly/conf16- ‐tmuthmodular input dcliExadata CellModular Input

Demo–AverageAc conf16- ‐tmuth

Demo–AverageAc veSessionsbit.ly/conf16- ‐tmuth

ExadataVirtualbit.ly/conf16- ‐tmuth

Demo–DBMemory&CPUbit.ly/conf16- ‐tmuth

conf16- ‐tmuthHTTPEventCollector(HEC)RESTCall(push)

Demo–LoggerPluginbit.ly/conf16- ‐tmuth

Demo–LoggerPluginbit.ly/conf16- ‐tmuth

Demo–CellMetricsbit.ly/conf16- ‐tmuth

Demo- ‐Swingbenchbit.ly/conf16- ‐tmuth

DemojMeterbit.ly/conf16- ‐tmuth

ConclusionOracleDatabases– Arepartofmanyhigh- ‐visibilitysystems– Arehighlyinstrumented– – Canconsume,visualizeandaggregatethisdata– �– 6- ‐tmuth

THANKYOU

Who*Am*I?* Oracle*–16*years* – APEXDevelopmentTeam* – Chief*Database*Engineer,*Public*Sector* – L