Transcription
Proactive Oracle DatabaseMonitoring And Capacity PlanningWith SplunkTyler Muth Analytics ArchitectSeptember 2017 Washington, DC
Who Am I? Oracle – 16 years APEX Development Team Chief Database Engineer, Public Sector Lead many Exadata POCs Wrote AWR-Miner for Sizing and CapacityPlanning, Logger, AWR Formatter tmuth@splunk.com
Introduction Oracle Databases Are part of many high-visibility systems Are highly instrumented Lack good tools to aggregate and visualize this dataSplunk Can consume , visualize and aggregate this data Can correlate this data with other parts of the “system” Can add tremendous value to Oracle customers
Why Splunk For iew of“Application”
What Can You Splunk?alert.logCell metricslistener logExadata &SuperClusterExachktrace filesOracleDatabaseOSOSWatcher /ExaWatcherFilesAuditsyslogTablesTA UnixTablesDictionaryCustom
How Can You Splunk It?Add-on for Unixalert.logDB Connect (DBX)Cell metricslistener logSplunk Add-on for Oracle DBExadata &SuperClusterStandard File Monitortrace filesOracleDatabaseTA UnixOSOSWatcher onaryCustom
Why Would You Splunk These?Securityalert.logTrace filesAudit filesAudit tablesDictionary TablesCustom TablesOS – TA UnixExadata - exachkExadata – Cell agementErrorAnalysis
Getting Oracle Data Into Splunk
Demo – Average Active Sessions ︎Using DB Connect (DBX) to pull DB metrics stored in tables / viewsJDBCDB Connect AppMost Databases
Demo – DB Memory & CPU
Demo Alert Log ︎Demo of pulling alert.log data into splunk
Demo Audit Logging ︎Demo of bringing audit log data into splunk
Demo Capacity Planning ︎Capacity planning demo using AWR data from many databases.
Demo– Logger PluginLoggerPackageError LoggedHTTP EventCollector(HEC)REST Call (push)
Conclusion ︎Oracle Databases ︎Are part of many high-visibility systemsAre highly instrumentedLack good tools to aggregate and visualize this dataSplunk Can consume , visualize and aggregate this dataCan correlate this data with other parts of the “system”Can add tremendous value to Oracle customers
2017 SPLUNK INC.Thank YouDon't forget to rate this session in the.conf2017 mobile app
Oracle –16 years APEX Development Team Chief Database Engineer, Public Sector Lead many Exadata POCs Wrote AWR-Miner for Sizing and Capacity Planning, Logger, AWR Formatter tmuth@splunk.com Who Am I?File Size: 1MB