Oracle Database & Data Warehouse 11g R2: Performance Assessment (2 days)

Description

This textbook is the first volume of a two-volume set devoted to the subject of Oracle database server and Oracle data warehouse performance tuning.

This first volume provides crucial background information about database performance statistics, metrics and baselines. An enormous amount of performance data is generated and presented by the self-monitoring Oracle database, but the meaning and usefulness of the data is not always obvious. Common questions are: What exactly should I be looking for in amongst all this data? What is the meaning of the performance statistics presented? What conclusions should one reach based upon what is observed and what specific tuning actions should be considered?

Therefore, this first volume helps one to assess the current performance of the database or the data warehouse, to identify whether or not there is a serious problem, and if so to isolate which areas of the database should be tuned and which tuning techniques might be considered. This textbook will at times include an in-depth discussion of some internal database operations where these are relevant to assessing database performance.

Audience

The target audience for this course is any of the following professionals:
• Database administrators
• Data warehouse administrators and implementation specialists
• Tuning specialists
• Data center support engineers and consultants

• Senior database developers

Prerequisites

Suggested prerequisites for this textbook are the following Sideris titles:
• ORACLE DATABASE 11G R2: ADMINISTRATION I
• ORACLE DATABASE 11G R2: ADMINISTRATION II

• ORACLE DATA WAREHOUSE 11G R2: WAREHOUSE ADMINISTRATION

Suggested Next Courses

The second volume of this textbook set should be considered next, which is entitled ORACLE DATABASE & DATA WAREHOUSE 11G R2: PERFORMANCE TUNING.

Ideally one will address application performance tuning issues at the same time as database performance and database server configuration issues. But if you have not already completed the following textbooks, we would recommend these next as well:
• ORACLE DATABASE 11G R2: SQL TUNING

• ORACLE DATABASE 11G R2: ADVANCED PL/SQL PROGRAMMING & TUNING

Objectives

Among the specific subjects discussed within this textbook are:

• How database performance tuning, SQL statement and application tuning, and the overall systems infrastructure configuration contribute to the performance of database installations.
• Contrast online transaction processing applications with data warehouse activity.
• Consider the systems components that interact with a database installation within multi-tiered systems architectures commonly in use today.
• Review the top 10-database configuration mistakes which contribute towards poor performance.
• Review the top 3 host system performance issues found on database servers.
• Host system components that influence database performance, such as operating systems like Linux, processor capabilities and input/output devices.
• Understanding system read and write internals, such as the difference between small reads and writes versus large reads and writes, asynchronous input/output versus synchronous input/output.
• Review the database performance assessment and performance tuning facilities built into the Oracle database server.
• Understanding the benefit of database performance statistics, metrics, alerts, thresholds and baselines.
• Using the Enterprise Manager real-time performance monitors to immediately assess current database performance.
• Interpreting database operational statistics, wait events and time model statistics to assess database performance and identify processing bottlenecks and constraints.

The second volume of this textbook set then provides tuning techniques and remedies that can be applied to address specific problems commonly found, such as the performance bottlenecks demonstrated in this textbook.


Download PDF outline here!

Oracle BI 11g: Create Analyses & Dashboards (2 day)

Description

This textbook offers an exhaustive, step-by-step guide through the powerful features of the Oracle Business Intelligence (BI) product suite. One will learn the concepts, methods and techniques for building sophisticated data analytic modules. Analytic results are then organized into interactive dashboards. A solid foundation is laid for one to progress onto the latest and most advanced data analytic capabilities.

Audience

The target audience for this course is any business professional seeking to analyze enterprise-wide or departmental information collected into an organization data warehouse. Among those for whom this course might be particularly useful would be:
• Data architects
• Data warehouse administrators and analysts
• Business analysts
• Financial managers
• Market research professionals
• Human resource managers
• Procurement and vendor management professionals
• Field representatives
• Business development managers

Prerequisites

It is assumed that you have access to a valid installation of the Oracle WebLogic Server and a deployment of the Oracle BI Server. Therefore, it is a mandatory prerequisite that this environment be configured in advance. A step-by-step guide to creating such an installation along with overview information about the technical architecture which supports these platforms is provided in the Sideris textbook
• ORACLE FUSION MIDDLEWARE 11G: WEBLOGIC & BI SERVER ARCHITECTURE & INSTALLATION.

Advanced or power users who may not be responsible for the actual installation but who are interested in Oracle BI architecture and administration topics may consider that textbook to be an optional prerequisite.

Otherwise, a general working knowledge of desktop business software and the use of web-based services via a browser are the only mandatory technical prerequisites.

Suggested Next Courses

After completing this textbook, advanced users should proceed onto the next textbook in the Sideris Oracle BI learning series entitled
• ORACLE BI 11G: ADVANCED ANALYSES FOR POWER USERS.

Instructor Resources

Instructor resources from the Sideris Training Portal combined with Sideris custom print courseware make distance-learning and virtual training more effective than ever! Available for download when you purchase this title. Please turn on your audio, make sure you have the latest version of Adobe Reader and then watch the demo to see how these new instructor resources improve your instructor’s presentations!

Objectives

The following specific topics are included in this guide book:
• Background discussion of data warehousing, business intelligence (BI) and data analytics presented in a form that business professionals can readily understand.
• Background concepts regarding logical data models, star schema and snowflake schema warehouse models.
• How to build analytical models using fact tables, dimensions, dimension hierarchies, cubes, measures and other multidimensional data model objects.
• Use interactive Dashboards to analyze data, uncover trends and make strategic business decisions.
• Export BI results to productivity software such as Microsoft Office or other external systems.
• Design customized Dashboards to reflect an individual's role, perspective or business interest.
• Creating data analyses and dynamically interact with results produced from Oracle BI.
• Format analyses using sorts, filters and prompts.
• Format column output, subtotaling, customization of column properties and transforming column data using formulas.
• Create results with compound layouts, including views such as tabular, chart, pivot table, gauge and others.
• Manage content, permissions and access within the Presentation Catalog.

This textbook includes dozens of learning exercises, with detailed point-and-click solutions also provided.

CONTENTS

DATA WAREHOUSING, BUSINESS INTELLIGENCE & DATA ANALYTICS
GETTING STARTED WITH ORACLE BI
USING A DASHBOARD
CREATING AN ANALYSIS
SELECTING & ORDERING DATA
COLUMN FORMATTING
EMPLOYING TABLE & TITLE VIEWS
EMPLOYING GRAPH & GAUGE VIEWS
EMPLOYING PIVOT TABLE VIEWS
EMPLOYING SECONDARY VIEWS
DEPLOYING ANALYSES TO DASHBOARDS
BUILDING A DASHBOARD

Download PDF outline here!

Oracle Fusion Middleware 11g: WebLogic & BI Server Architecture & Installation (1-2 days)

Description

This textbook will assist you in learning and using one of the most exciting software environments available today, namely the Oracle BI Enterprise Edition data analytics suite and the Oracle Fusion Middleware WebLogic Server.

Audience

The target audience for this mini-textbook includes the following:
• Any business intelligence professional seeking an introduction to the installation and configuration of the Oracle WebLogic Server and the Oracle BI server platforms.
• Any self-study student using one of the textbooks from the Sideris Oracle Fusion Middleware curriculum.

• An instructor presenting one of the textbooks from the Sideris Oracle Fusion Middleware curriculum and who is responsible for setting up the workshop environment for the students.

Prerequisites

The target audience for this mini-textbook includes the following:
• Any business intelligence professional seeking an introduction to the installation and configuration of the Oracle WebLogic Server and the Oracle BI server platforms.
• Any self-study student using one of the textbooks from the Sideris Oracle Fusion Middleware curriculum.
• An instructor presenting one of the textbooks from the Sideris Oracle Fusion Middleware curriculum and who is responsible for setting up the workshop environment for the students.

Suggested Next Courses

This course should be considered the first part of the Sideris integrated database administrator curriculum. Therefore, in the not-too-distant future one should proceed to the follow-up course

Oracle BI 11g: Create Analyses & Dashboards

Objectives

Within this textbook you will learn:
• About the architecture and internal components of the Oracle Business Intelligence (BI) Enterprise Edition (EE) data analytics suite (OBIEE).
• Important concepts regarding the Oracle WebLogic Server application server middleware platform, the platform to which the Oracle BI suite is deployed.
• This textbook will guide you through the process of creating an installation of Oracle BI and the WebLogic Server on either a Linux/Unix or an MS Windows host system. Using this workshop setup, you will be able to complete the exercises presented in the other textbooks from the Sideris Oracle Fusion Middleware curriculum. And of course, having a working Enterprise Edition of the Oracle BI suite will also allow you to begin real-world production work for your organization.
• You will receive an introduction to administration of the Oracle WebLogic Server, the Oracle BI Server and Oracle BI Presentation Services.
• How to manage analytic content created by users and stored within the Oracle BI Presentation Catalog. Topics include managing permissions, private folders, shared folders, and archiving objects for use in other BI installations.

• How to access and use administration tools to perform basic BI management tasks. Such tools include the Oracle WebLogic Server Administration Console, the Oracle Enterprise Manager with the Fusion Middleware Control, the Oracle BI Administration tool and the Oracle BI Catalog Manager. You will learn how to add new BI users as well as manage their privileges.

Download PDF outline here!