Don’t miss out on the last Quarterly Educational Workshop before Training Days
PIZZA is being sponsored by ECS Team for lunch
November 16, 2012
Oracle – Campus
7700 Technology Way
Denver, CO 80237
Building 3 (North Building)
Please go to:
Question please e-mail Heidi at firstname.lastname@example.org
Or call 303.948.1786
$15 visitor fee
7:45 am – 8:15 am Continental Breakfast
8:15 am – 9:15 am Essbase Calculations – Observations from the Road
9:25 am – 10:25 am Sherlock Holmes for the DBA
10:35 am -11:35 am Introduction to SOA and Oracle SOA Suite
11:45 am -12:45 pm CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
12:45 pm – 1:45 pm Board Meeting
8:15 am – 9:15 am
Essbase Calculations – Observations from the Road
Chris Chase, Managing Partner @ The Bean Consulting Group
With nearly 25 years experience in software and database technology I thought I had seen all that programming had to offer; then I discovered Essbase. Learn some interesting observations regarding Essbase calculations accumulated over nearly 10 years of Hyperion implementations. We will discuss aggregations, allocations, eliminations, and driver-based calculations, commands and functions specific to Hyperion Planning, and some of the more confounding aspects such as block creation and cross dimensional operators.
9:25 am -10:25 am
Sherlock Holmes for the DBA
Kellyn Pot’Vin, Senior Technical Consultant @ Enkitec
The DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often the administrator is expected to, not only identify, but also correct the problem without impact and in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.
Attendees will leave the session with a better understanding of trouble-shooting techniques and when to use what features, tools and reports to address issues.
10:35 am -11:35 am
Introduction to SOA and Oracle SOA Suite
Brian Statkevicus, Senior Consultant @ ECS Team and Greg Opie, Director of Architecture @ ECS Team
Almost everyone has heard of Service Oriented Architecture (SOA). Some people can accurately describe what it is and isn’t. This introductory session will cover:
• What is SOA?
• What are the business problems solved by implementing SOA?
• Oracle’s SOA Suite
• Demo of a sample business process using SOA Suite
• SOA Case Study
11:45 am – 12:45 pm
CTO’s Perspective on Adding Geo-spatial and Location-Based Information to Your Data
Bradley Brown, CEO/CTO @ InteliVideo
There is a considerable amount of free geo-spatial data available from the government and open source groups. This information can be quite helpful at providing more information about location-based data. For example, if you’re a property management company and you wanted to know close each of your properties are for anything from grocery stores to railroad tracks to flood plains, all of this information is available. If you wanted to know which homes are on a specific golf course, this data is available for free too.
In this presentation, Brad will share what geo-spatial data is available, where you can download the data, and what you might use the information for. You can also create your own layers of information and merge this into your queries. All of this can be done using an Oracle database (even the free version of Oracle) – i.e. without a mapping tool like ESRI. You can easily overlay this information onto Google maps or Google Earth. Brad will share PL/SQL code that will extract shapes into KML
7700 Technology Way
Denver, CO 80237
August 17th, 2012
Come Learn and Play at the next
Quarterly Educational Workshop
Elitch Garden Theme and Water Park
2000 Elitch Circle Denver, CO 80204
Registration Required by August 7th, 2012
Free PARKING for first 100 members to sign up
8:00 am – 8:30 am Continental Breakfast
8:30 am – 9:30 am APEX Admin and Install Tips and Techniques
9:50 am – 11:50 am How ASH works and how to use it
LONG PEAK PAVILION
11:00 am – 3:00 pm Pavilion Available
11:30 am – 2:30 pm Snack Baskets/Drinks served
12:00 pm – 2:00 pm Lunch Served
1:00 pm Raffle Drawing
RMOUG Members: no cost
All additional family members / guests: $15.00*
*Guests may enter park at 9:30 am
Non-Members: $50.00 or become a member for $75.00
Students: Become a member for $35.00
Attendance includes: Morning sessions, lunch, and a day pass to both the theme and water park for you and your family/guests*
8:30 am – 9:30 am
Dan Hotka, Author/Instructor/Oracle ACE Director
This presentation discusses various installation and administrative tasks associated with the Application Express 4.1 (APEX) Oracle web-based development environment. Dan discusses new APEX 4.1 features as well as using SQL Developer to aid in the administration and deployment of APEX applications.
9:50 am – 11:50 am
How ASH works and how to use it.
John Bereniewicz and Graham Wood, ORACLE Corporation
“Active Session History” (ASH) is a rich historical record sampled from activity within the database at the level of individual sessions, capturing such important information as timestamp, user identity, the name of server from which the session was connected, the SQL statement executing, the PL/SQL module from which the SQL was executing, and the event and event parameters upon which the session was waiting. ASH is a snapshot of what is happening in the database, captured automatically for later diagnosis.
Studies included will range from simple to complex.