BI Management Presentation - OpenWorld 2008 (Final Version).ppt

1、 2008 Oracle Corporation Proprietary and Confidential,Oracle Business Intelligence Management: Achieving High Performance and Availability with Oracle Enterprise Manager,Amjad Afanah Product Manager, 2008 Oracle Corporation Proprietary and Confidential,Oracles Complete Enterprise Software StackBuilt

2、-in & Integrated Manageability,Leader in the complete enterprise application stack Built-in manageability in every tier Integrated manageability across the entire stack, 2008 Oracle Corporation Proprietary and Confidential,Manage applications top-down, from the business perspective by understanding

3、user experiences and business impact of IT issues Manage entire application lifecycle to increase business agility with comprehensive application quality management and compliance solutions Reduce operational costs through intelligent diagnostics and automated IT processes,Oracle Enterprise ManagerI

4、ncreases Business Efficiency, 2008 Oracle Corporation Proprietary and Confidential,Agenda,Introduction Business Intelligence Management Pack Capabilities Customer Case Study: Fiberlink Communications Demo, 2008 Oracle Corporation Proprietary and Confidential,Introduction, 2008 Oracle Corporation Pro

5、prietary and Confidential,Key Features: Configuration Management o Automatic Discovery o Configuration Snapshots o View Configuration o Configuration Comparison o Change History Application Performance Management o Performance Charts o Multi-System Management o Aggregated System Health o Dashboards

6、and Reports o Alert Notifications o Historical Performance and Usage Metrics o Blackouts o O/S Management Service Level Management o Define Service Tests and Beacons o Edit Service Level Rules o Topology Views o Monitor Availability, Performance and Usage,Business Intelligence Management Pack, 2008

7、Oracle Corporation Proprietary and Confidential,Business Intelligence Management Pack: Complement and Extend Bundled Tools, 2008 Oracle Corporation Proprietary and Confidential,Licensing Information for Business Intelligence Management Pack,Business Intelligence Management Pack is offered within Ora

8、cle Enterprise Manager 10g Release 4 (10.2.0.4.0) Supports Oracle Business Intelligence Enterprise Edition 10.1.3.x Supports Business Intelligence Applications v 7.9, 7.9.1 - 7.9.4. The Data Warehouse Administration Console (DAC) Server comes with the BI Applications install. The following Oracle Bu

9、siness Intelligence-specific targets are licensed within Enterprise Manager. Oracle BI Server Oracle BI Cluster Controller Oracle BI Presentation Server Oracle BI Scheduler Oracle BI Suite Enterprise Edition Oracle BI Data Warehouse Administration Console (DAC) Server Hosts Running BI Components, 20

10、08 Oracle Corporation Proprietary and Confidential,Interface with OBIEE and BI Applications,Web Browser, 2008 Oracle Corporation Proprietary and Confidential,Business Intelligence Management Pack Capabilities, 2008 Oracle Corporation Proprietary and Confidential,Controlled Deployment into Production

11、Configuration Comparison,Compare: Two saved snapshots in the Management Repository Two different systems One configuration to multiple configurations A configuration in the Management Repository to a saved configuration file, 2008 Oracle Corporation Proprietary and Confidential,Aligning IT Prioritie

12、s with Business DemandsService Level Management,Define Service Level Objectives (SLO) Model Services Dependencies End-to-End Monitor Services Against SLO Targets Report on Actual Service Levels, 2008 Oracle Corporation Proprietary and Confidential,Multi-System Management Manage multiple Oracle BI de

13、ployments from a single console. Aggregated System Status Monitor the health of all critical Oracle BI components. Thresholds may be defined against server and component statistics such as CPU utilization, the number of active logins/sessions, and up/down status of servers and components.,Notificati

14、on Methods Notification methods could be defined to send email, trigger SNMP traps to forward alerts to third party management tools, or to kick off custom scripts.,Proactive Monitoring of the Complete Oracle BI Environment, 2008 Oracle Corporation Proprietary and Confidential,Performance charts are

15、 available for different categories: General Performance: - CPU Usage % - Memory Usage (KB) - Physical DB Connections - Execute Requests - Fetch Requests - Prepare Requests - Active Logins - Total Sessions Cache Performance: - Data Cache Hit Ratio % - Data Cache Hits Vs. Misses - Generic Cache Reque

16、sts - Generic Cache Average Hits/sec - Generic Cache Utilization Ratio %,Database Performance: - Queries/sec - Rows/sec - Failed queries/sec - Average Query Response Time (sec),Proactive Monitoring of the Complete Oracle BI EnvironmentOracle BI Server Performance Charts, 2008 Oracle Corporation Prop

17、rietary and Confidential,Performance charts are available for: General Performance: - CPU Usage % - Memory Usage (KB) - Sessions - Chart Engine - Query Thread Pool - Chart Thread Pool,Proactive Monitoring of the Complete Oracle BI EnvironmentOracle BI Presentation Server Performance Charts, 2008 Ora

18、cle Corporation Proprietary and Confidential,The Oracle BI Scheduler home page shows graphs for Failed Jobs and Total Jobs under the Scheduler Jobs section. Under the Failed BI Scheduler Jobs (Last 24 Hrs) section, information about failed jobs is displayed with details about the Job Name, Instance

19、ID, Job ID, Start Time, Duration and Error Message. Under the Next Scheduled Jobs section, information about scheduled jobs is displayed with details about User ID, Job Name, Job ID, Next Run Time, and Script Type.,Proactive Monitoring of the Complete Oracle BI EnvironmentOracle BI Scheduler Perform

20、ance Charts, 2008 Oracle Corporation Proprietary and Confidential,Performance charts are available for different categories: Historical ETL Performance: - Total Tasks - Completed Tasks - Running Tasks - Failed Tasks - Queued Tasks - Runnable Tasks,Proactive Monitoring of the Complete Oracle BI Envir

21、onmentOracle BI DAC Server Performance Charts,ETL Runs: View summary of completed runs with information about the Duration, Total Steps, Completed Steps, Stopped/Failed Steps and Running Steps for all completed runs., 2008 Oracle Corporation Proprietary and Confidential,The performance metrics that

22、are collected out-of-box for the host span several different categories: CPU Usage (including idle, wait, and user times), Disk Activity (including Average Disk I/O rate), and Network Interface Activity, among others. You can also view real-time metrics such as buffer activity.,Using the Performance

23、 page, you can: View the processes that are using the most CPU or memory resources. View performance data in real-time or historical data over defined periods.,Proactive Monitoring of the Complete Oracle BI EnvironmentHost Monitoring, 2008 Oracle Corporation Proprietary and Confidential,Log File Mon

24、itoring Monitor abnormal conditions recorded in the log files present on the host (e.g. NQServer.log),Execute Host Command Execute non-interactive host commands remotely over the network, as well as view and edit text files.,User-Defined Metrics Extend the reach of Enterprise Managers monitoring cap

25、abilities via custom scripts. Once a user-defined metric is defined, it will be monitored, aggregated in the repository, and can trigger alerts like any other metric in Enterprise Manager.,Proactive Monitoring of the Complete Oracle BI EnvironmentHost Monitoring, 2008 Oracle Corporation Proprietary

26、and Confidential,Record synthetic web transactions “Service Tests” within the application to be used as the criteria for determining the services availability e.g. logging in and navigating through critical pages of the Oracle BI Dashboards,Define Beacons that are used to play back service tests at

27、specified intervals from various locations that are representative of your user communities.,Monitoring End-User ExperienceService Tests, 2008 Oracle Corporation Proprietary and Confidential,Dashboard Usage in Last 7 Days Failed Dashboards in Last 24 Hours Top Dashboards by Resource Usage in Last 7

28、Days Top Users by Resource Usage in Last 7 Days Breakdown of response time based on database time, compile time and overall time for end-user queries.,Monitoring End-User ExperienceDashboard Reports, 2008 Oracle Corporation Proprietary and Confidential,Information about the longest running queries a

29、nd detailed statistics on queries per day/user/subject area. Response times of queries on various screens and views.,Monitoring End-User ExperienceOracle BI Usage Tracking, 2008 Oracle Corporation Proprietary and Confidential,Aggregate Component Availability Service Test Status Service Level,Diagnos

30、ing Production ProblemsService Monitoring, 2008 Oracle Corporation Proprietary and Confidential,Search collected configuration data and view the history of configuration changes to diagnose performance problems,Diagnosing Production ProblemsConfiguration History,“When things stop working, the first

31、thing we do is try to figure out what has changed”, 2008 Oracle Corporation Proprietary and Confidential,Dashboard Reports and Usage Tracking Longest Running Queries Top Dashboards Failed Dashboards Query Statistics per Day/User /Subject Area Oracle Database Management Pack Slow/Failed Queries Execu

32、tion Plan Statistics SQL Tuning Wizard,Diagnosing Production ProblemsDashboard Reports and Usage Tracking, 2008 Oracle Corporation Proprietary and Confidential,SLM reports indicate whether the Oracle BI application has provided the performance and availability needed to support critical business ope

33、rations.,Make Fact-Based Optimization DecisionsService Level Management Reports, 2008 Oracle Corporation Proprietary and Confidential,Vishal Doshi Oracle Business Intelligence and Database Administrator,Customer Case Study Fiberlink Communications,Company Founded in 1994. Headquarters in Blue Bell P

34、ennsylvania. Presence in NA, EMEA & Asia. Over 250 employees. Mission Enable the Internet to be your mobile corporate network Customers Over 1,000,000 deployed users across over 700 enterprise customers, Leadership Recognized by industry analysts as an innovator and leader in the mobile market. Fina

35、ncial - Privately held, profitable and growing. Investors include Goldman Sachs, GE and TCV,Fiberlink Overview,Unique Selling Proposition,Fiberlink Unique Selling Proposition Fiberlink is the only company that provides an integrated laptop management and compliance platform for endpoint security, th

36、at controls both security and access enablement through a hosted, policy based, delivery model.,Customer Sampling,Retail,Technology,Travel,Other,Finance,Healthcare,Insurance,Media,Automotive,Consulting,Consumer Goods,Energy,Mission Critical Application Oracle Business Intelligence Enterprise Edition

37、 (OBIEE) is a mission-critical application. Slow performance or outages may have a negative impact on the business. Clustered Environment The Oracle Business Intelligence Enterprise Edition (OBIEE) environment consists of 2 Oracle BI Servers, 2 Oracle BI Presentation Servers, 2 Oracle BI Schedulers,

38、 and 2 Oracle BI Cluster Controllers in a clustered deployment. All Oracle BI components are running on Linux 32-bit. Business Requirements Service level objectives have been defined to meet the availability, performance, and business needs within the services business hours.,Oracle BI Application E

39、nvironment,Deploy a centralized system for managing a clustered Oracle Business Intelligence Enterprise Edition (OBIEE) application environment Gain the ability to track, maintain, and correlate configuration changes to incidents Diagnose performance problems and gain insight into end users experien

40、ce Create a centralized system for monitoring and managing service level agreements (SLAs),Challenges,Business Intelligence Management Pack:Comprehensive and Integrated Solution,Business Intelligence Management Pack provides an integrated solution for proactively monitoring multiple OBIEE environmen

41、ts from a single console.,Configuration Management,Used Configuration Snapshots to save “gold copies” of working configuration settings that were in turn used: to replicate configuration in development to production, and to make sure that configuration settings amongst components in a clustered envi

42、ronment are consistent. Used Configuration History to track changes (e.g. parameter changes in NQSConfig.INI or NQClusterConfig.INI) for diagnostic purposes.,Performance Monitoring,Defined critical and warning thresholds for a wide range of performance metrics to monitor the health of all critical O

43、racle BI components. Used Service Tests to simulate key end user activities and to actively measure performance and availability from an end user perspective. Used Dashboard Reports for usage trending and for diagnosing performance problems associated with failed dashboards,Service Level Management,

44、Modeled the End-to-End Service down to the components it depends on Defined Service Level Objectives (SLO) based on business requirements Monitored Service Against SLO Targets Used SLM Reports for SLA compliance,Deploy a centralized system for managing a clustered Oracle Business Intelligence Enterp

45、rise Edition (OBIEE) application environment Gain the ability to track, maintain, and correlate configuration changes to incidents Diagnose performance problems and gain insight into end users experience Create a centralized system for monitoring and managing service level agreements (SLAs),CHALLENG

46、ES,Implemented the Business Intelligence Management Pack (as part of the the Oracle Enterprise Manager 10gR4 installation) to improve the efficiency and effectiveness of: Application Performance Management Configuration Management Service Level Management,Gained the ability to monitor a wide range of performance metrics