Bradley Brown, TUSC(ROLTA) Co-Founder: Application Express : 4 presentations
Richard Niemiec, TUSC(ROLTA) Co-Founder and President: How Oracle Came to Rule the Database World
Mark Henderson and Rick Stehno from LSI: Solid State Storage in Oracle Environments
Boris Trukhnov: Installing 11g R2 Databases using VMWare and RH Linux: Complete details.
Accessing Hierarchical Data in Oracle: presenter Carol-Lee Tutch
Six presentations: Exadata, ODI/GoldenGate, Oracle Virtuallization, Exadata Case Studies, Value Chain Planning/ APC, and Demantra
OSWOUG Call for Papers: OpenWorld 2011:
If you attended OpenWorld and would like to share you experiences, send us an email, (to Jon Wasserman jsw@oswoug.org or any OSWOUG officer).
This years' event was exciting featuring Exadata, Exalogic and Exanalytics. A lot has changed in the "Fusion" space in one year. Oracle Data Integrator and Goldengate are key vessels for data integration going forward. Oracle has dedicated large scale resources in developing ODI and Goldengate as a key component to handle database design (Warehouse Builder is now integrated into ODI), Master Data Management, Data Mappings as Workflows, and many more combinations of integration interfaces to the entire Enterprise. This includes Siebel, JDEdwards, Hyperion and Essbase, Value Chain Planner components ( Demantra: Demand Forecasting and Trade Promotion Optimizations, Advanced Planning Command Center and Advanced Supply Chain Management), Financials, Human Capital Management, not to mention the underutilized, but significant, Advanced Planner Command Console.
Current Meeting: Tuesday, November 8, 2011
Craig Shallahamer Rick Stehno Boris Trukhnov
Title: Products offered by Oracle with an emphasis on server virtualization techniques.
A high level discussion of Oracle's offerings in virtualization for the server. Boris has dedicated many years to Oracle database optimization. He spoke previously on virtualization as part of an Oracle grid discussion at OSWOUG last year.
Title: Intro to Oracle Buffer Cache Internals
While Oracle's buffer cache consists entirely of database blocks, the buffer headers and the supporting lists/chains are what makes the buffer cache a consistent topic of importance, interest, and challenge. Using creative visualizations, the presentation begins by introducing the key buffer cache structures followed by Craig role playing as a server process performing a variety of server process related activities. This naturally leads into when and how CPU is consumed and how the various buffer cache related wait events manifest, such as free buffer waits, and cache buffer chain and LRU latch contention. Both new and experienced Oracle DBAs will find this presentation informative, practical, and entertaining.
Abstract: The arrival of more cost effective Solid State Disks and Flash based Storage technology has provided significant performance gains in the deployment of an Oracle database. Oracle and storage vendors have started enhancing their products to take advantage of these SSD and Flash technologies. Choosing the right implementation approach can be a challenging proposition for the DBA. In this session we will look at implementing Oracle’s Smart Flash Cache using an internal SSD acceleration board, using cache technology inside of the array, and the benefits of storage tiers using SSD, with the benefits and challenges of each.
Details: Oracle Smart Flash Cache; Technology available in 11gR2; Extends Oracle Buffer Cache; Can use any technology - Flash Cards, Network Flash, Solid State Disk, even USB drives;
Caching Inside the Array; Technology available for all Oracle database releases; Caches disk access to increase performance; Used in conjunction with SSD
General Meeting: Tuesday, May 10, 2011
Jared Still
Making RMAN Perform
Jared has recently made his contribution to another book, this time in partnership with Karen Morton, titled Pro Oracle SQL. OSWOUG feels this book is an outstanding reference.
Edward Roske, CEO
interRel Consulting, LLP
Edward Roske is the CEO and co-founder of interRel Consulting, one of the 5 largest Oracle EPM consulting firms in the world. As an Oracle ACE Director and author of seven books, Edward has spoken on four continents evangelizing everything Oracle Business Intelligence, Enterprise Performance Management, and Hyperion.
THREE PRESENTATIONS:
Oracle EPM: Hyperion is the Future of Reporting, Analysis, Modeling, and Planning
In 2007, Oracle acquired Hyperion for three primary products: Essbase, Hyperion Financial Management (HFM), and Hyperion Planning. What exactly are these products and how can you begin freeing your data? In this session, you'll learn how Essbase provides robust reporting, analysis and calculations against multiple data sources; why HFM is the market leading product in the financial management, consolidation, and accounting reporting space; and how Hyperion Planning gives you powerful budgeting, planning, forecasting, what-if'ing, and modeling capabilities. You'll leave this session with an understanding of not only what the main Hyperion products do, but how they can make your life better at your company by saving you time, reducing costs, and giving you better access to information. If you don't already have Hyperion or you just want to increase your fundamental Hyperion knowledge, this may be the most important presentation you attend all year.
What is Essbase and Why Should I Care?
Oracle’s acquisition of Hyperion’s Essbase provides powerful analytic and calculation capabilities to Oracle's Business Intelligence suite. Join us for this presentation where we will show you why Essbase is the best multi-dimensional (OLAP) solution for customers. We’ll demonstrate the advanced analytic capabilities, powerful calculation engine, and all of the features and functions of Essbase. With recent Essbase enhancements like Aggregate Storage Databases and XOLAP, the lines are blurring between relational and multi-dimensional storage and traditional relational reporting options. We guarantee you’ll leave this session with a better understanding of what Essbase can do, when Essbase makes sense (and when it doesn’t) as a solution.
Integrating Oracle Essbase & OBIEE with Your Data Warehouse Strategy
If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition (including the products formerly known as Hyperion) helps drive value from your warehouse solution. Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. We’ll show how the OBIEE+ Reporting and Analysis components provide a single interface into any type of data source, combining data from your data warehouse and data marts into in nicely formatted reports, user friendly dashboards, and easy-to-use analytic screens. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.
More information about our speaker:
Edward is continuously recruited to host various Hyperion presentations at user groups around the world as he uses his 15+ years of expertise on over 500 implementations in the Hyperion arena to provide insight on the future of Hyperion within Oracle. Edward also offers an Oracle EPM blog,Looksmarter.blogspot.com, which offers a unique perspective inside the world of Oracle EPM, including information on upcoming releases, colorful commentary on Edward’s ideas on hot topics in the industry, and much more. Recently, Edward was just made a certified Oracle Fusion Applications Advocate, a title Oracle has only bestowed on 7 people.
Link to InterRel
Edward Roske's Blog
Jared Still's BIO and Presentation Details
Jared Still is a Sr. DBA at Pythian and enjoys exploring all things Oracle and learning how they work and how to use them. Jared is perhaps best known for founding the Oracle-L oracle mailing list many years ago. He is also known as the "Part Time Perl Evangelist" for his use of Perl in conjunction with Oracle, and is co-author of "Perl for Oracle DBA's" and "Pro Oracle SQL". Jared is a member of the Oracle Oak Table and an Oracle ACE.
RMAN is a well-established backup tool. As it has become increasingly robust, it has also become increasingly complex.
When RMAN doesn't seem to be performing as well as you think it should, where do you begin to tune it? While there is some RMAN tuning information available to guide you, it is somewhat sparse.
This presentation is not going to offer any quick tips or silver bullets, because there aren't any.
This presentation is about learning how to determine what makes RMAN perform well in a particular environment, and what makes it perform poorly.
You will see what parameters performed well in my test system, but there are no guarantees that you would see the same results in your systems by applying the same values to these parameters.
Topics for this presentation include:
- Increasing backup performance.
- Increasing restore performance.
- Compromises between backup and restore performance.
- Compromising backup performance to maintain response time.
Recognition to InterRel and Oracle for bringing Edward Roske.
TekSystems providing breakfast and lunch.
The DBAs at Standard Insurance, you know who you are.
Meeting: Tuesday, February 8, 2011. 8:00 a.m.
Bring your stats pack report and calculator to the meeting.
Mark Henderson
LSI Corp.
Craig will present:
Resolving Buffer Busy Waits Related Contention (50 min.)
Evaluating Alternative Performance Solutions (50 min.)
Rick and Mark will present:
Performance benefits of using SSD technology in an Oracle database environment. (50 min.)
DETAILS and BIOs
Craig Shallahamer's bio:
Craig is a researcher, writer, and teacher for 1000s of Oracle professionals. His focus is Oracle performance management, which has led to a string of publishing over 24 technical papers and authoring the books Oracle Performance Firefighting and Forecasting Oracle Performance. Craig is the creator and teacher of the popular Advanced Oracle Performance Analysis, Oracle Performance Firefighting, and the Oracle Forecasting & Predictive Analysis courses. After nine years with Oracle Corporation in which he co-founded the Core Technologies and the System Performance Groups, in 1998 he left Oracle to start OraPub, Inc. He is a passionate educator, a pinnacle of Oracle knowledge, and an engaging instructor. His entertaining presentation style combines with his depth of Oracle experiences to make each presentation unique. An Oracle ACE Director, he has taught 1000s of Oracle professionals on 6 continents in 24 countries.
Presentation: Resolving Buffer Busy Waits Related ContentionOf all the Oracle wait events, the buffer busy wait and read by other session are two of the most intriguing. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important because there are a number of reasons why a buffer can become too busy and the solutions are derived in part by understanding the underlying Oracle structures. This presentation guides you through the process of discovering if there is a significant problem, the related Oracle internal structures, wait event name changes, a spot-on diagnosis method, and solutions for the most common situations you're likely to face. The presentation closes with a case study bringing together all the presented material.
Presentation: Evaluating Alternative Performance SolutionsDBAs can do a pretty good job at diagnosing performance problems and coming up with a list of solutions. But an awkward uncomfortableness can occur when asked to objectively choose and to explain which solution is the best or how the solution will specifically affect the system or a user. This presentation will introduce you how to quantitatively and graphically represent your system and your proposed solutions. This will enable you to objectively compare various solutions and to confidently present your solutions to both management and your colleagues.
Presentation: Advantages of using Solid State Device Storage for Performance in an Oracle Database Environment
Mark Henderson is a Solutions Marketing Manager with LSI Corporation which designs and manufactures high-performance midrange storage systems for IBM, Oracle, Dell, Blue Arc, SGI, Teradata and others. Mark works with Oracle and LSI’s various OEM channels to create and promote solutions that address customer problems and create competitive advantage. He has a degree in Computer Systems Engineering, has designed high-end flight simulators, participated in computer science and networking research at US DOE labs, architected HPC centers, and had been involved with Storage Resellers, Tape Systems, Fibre Channel Director SAN technology and MAID storage systems. He has been in the industry for 25 years.
Rick Stehno is an Oracle Technologist/DBA with LSI Corporation which designs and manufactures high performance storage systems. Rick works with Oracle and LSI's various OEM's to create and promote solutions using LSI's storage systems with the various Oracle technologies. Rick has been in the IT field for over 34 years and working with Oracle databases since 1989.
Thanks to TEK Systems, Standard Insurance, and our speakers; All of whom give time and money to bring together a growing network of professionals.
General Meeting: Tuesday, November 9, 2011. 8:00 a.m.
COGNOS
will discuss the current state-of-the-art in Oracle performance tuning.
His many accomplishments include the O'Reilly book "Optimizing Oracle Performance". In this crucial book, Cary Millsap, former VP of Oracle's System Performance Group, clearly and concisely explains how to use Oracle's response time statistics to diagnose and repair performance problems. Cary also shows how "queueing theory" can be applied to response time statistics to predict the impact of upgrades and other system changes.
There are certain "camps" in the worldwide Oracle community. For example, there is the "Oak Table Network" of "Oracle scientists" who seek thorough understandings of issues backed up by details, tests and proofs. Contrasting is the "Silver Bullet" family of field-tested generals who prefer rules of thumb and quick fixes even it means some false understandings and occasionally being wrong. Cary Millsap (of the Oak Table Network) stands as someone respected by both sides.
Cary Millsap worked at Oracle for 10 years on system performance before co-founding Hotsos in 1999 [...]. He is one of the most trusted sources on matters of Oracle system performance, and "Optimizing Oracle Performance" is considered his finest work (4.5 out of 5 stars on Amazon).
* The preceding is an anonymous comment from a book reviewer on safaribooksonline.comexpert Anand Thiagaraj from IBM
In this session, Anand with present and demonstrate IBM Cognos Business Intelligence. IBM Cognos Business Intelligence delivers the complete range of BI capabilities: Reporting, Analysis, Dashboarding and Scorecards on a single, service-oriented architecture (SOA). With IBM Cognos you can author, share and use reports that draw on data across all enterprise sources for better business decision.
Bio: Anand Thiagaraj is a Solution Specialist for the IBM Business Analytics' brand. He has more than 17 years of software industry experience and has performed different roles - consulting, engineering, product management and product marketing. He has an MBA from Rutgers University. Anand lives in the San Francisco Bay Area with his wife and two daughters.
General Meeting, August 10, 2010. 8:30 a.m.
Oracle OpenWorld 2010: Brief Presentation.
Erik Kaarto will discuss Oracle OpenWorld 2010
Erik's career with Oracle, starting at Redwood Shores, extended through 15 years. He has attended every OpenWorld and almost every one of the shows prior to being taken over by Oracle marketing. Erik will make light about the "Evolution of Demos" and Oracle Sales.
Presentation: starts 8:50 a.m.
Boris Trukhnov, OCP, OCE
Installing Oracle 11gR2 RAC on Enterprise Linux 5 using VMware Server.
Boris will present installation considerations and details using VMware Virtual Machine and Red Hat Enterprise Linux.
Boris M. Trukhnov has been working with relational databases (primarily Oracle) since 1994 and is an author of several technical books published in US and translated into Portuguese, Chinese, and Russian, including “SQL Bible” (1st and 2nd editions) and “Introduction to Database Management”.
Boris’s areas of expertise include RAC, ASM, RMAN, performance tuning, database and system architecture, platform migrations, and system upgrades.
Boris is an Oracle 10g Database Administrator Certified Professional (OCP) and Oracle Real Application Clusters 10g Administrator (OCE).
General Meeting Tuesday May 11, 2010. 8:15 a.m.
Bradley D. Brown, CIO and Co-Founder of TUSC
at The Standard Insurance Center
David Alexander will be honored for his contributions to OSWOUG.
Breakfast sponsored by TekSystems' Beaverton Offices. Tek is a national staffing agency.
RSPV to jsw@oswoug.org
Bradley D. Brown, CIO and Co-Founder of TUSC
Brad is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.
APEX CLASS is scheduled for Beaverton 3:30-8:30p.m. location TBD.
Developing Applications using Application Express.
Instructions to download and install APEX will be posted here.
Understanding Oracle Licensing. starts at 8:25a.m.
Building a Mashup with Application Express. 1 Hour Presentation.
Recession-proof your company with SOA. 1 Hour Presentation.
Wimpy Web Services vs. Powerful Flexible Web Services. 1 Hour Presentation.
The presentations will include detailed technical demonstrations.
First Presentation, Starting at 8:25am.
Brian Decker
Oracle Licensing Specialist for TUSC
The Oracle Specialists.
Second Presentation: starts at 9am. (ApEx)
Building a Mashup with Application Express (ApEx)
==========================================================
In this presentation, Brad will talk about how to develop a mashup using Oracle Application Express. Traditionally people think of ApEx as being an "Oracle database" tool only - not a mashup tool. However, Brad will show how you can consuming Web Services to access data from any source - Oracle, MySQL, SQL Server, Access, Excel, Cloud Databases (like Zoho), etc. In Brad's presentation titled "Scalable Oracle ApEx" he explains how to create an n-tier architecture for ApEx. This architecture provides unparalleled scalability to your organization. This presentation explains the implementation side (i.e. the specifics) of this solution.
Third Presentation: starts at 10:10am
Recession-proof your company with SOA
Using Quick Turns for Quick Feedback
====================================
The ability to rapidly modify service offerings is becoming key to success in today's turbulent economy. Many companies are turning to SOA to help their business reduce development effort and achieve agility, but implementing SOA effectively has proved a daunting challenge all its own. How can today's IT managers and CIOs realistically propose SOA and quickly deliver benefits without risking their jobs? Rolta TUSC's Brad Brown will explain why historic SOA implementations have failed, how you can benefit from innovative software that fundamentally transforms the complexity of implementing SOA to an "instant" task, and how an agile, iterative approach can deliver rapid ROI for your business and ultimately lower total cost of ownership. In a time where budgets can be cut at a moment's notice, this briefing will ensure you derive value from your SOA initiatives in weeks and become the "hero" for your business.
Fourth Presentation: starts at 11:20am
Wimpy Web Services vs. Powerful Flexible Web Services
====================================================
In this presentation, Brad will discuss the importance of strong Web Services, the difference between wimpy services and powerful flexible Web services. Many companies today are attaching SOA MBOs to their technical teams. These performance metrics often measure based on quantity rather than quality. What is quality? Reuse? Performance? Flexibility? Brad will discuss this topic in detail.
Will cover integration tools such as Eclipse and Java. Building an open API that provides dynamic services provides a powerful service architecture to any business.
BIO*
Bradley D. Brown is Chief Technology Officer of TUSC, a ROLTA company.
Oracle Application Server, Oracle Application Express, Web Services, and the Service Oriented Architecture are a few of the technologies Brad has mastered over a career that spans more than 25 years.
Thomas Kurian, senior vice president -- Oracle Server Technologies Division, says, "Brad is among the foremost experts on Oracle's technology in the world."
He is an accomplished Oracle author and world-renowned speaker, his books include: "Oracle HTML DB Handbook" (the product was renamed Oracle Application Express), "Oracle Application Server 10g", "Oracle9i Web Development," "Oracle8i Web Development", and "Oracle Application Server Web Toolkit Reference" in 1997.
Brad has enjoyed a countless number of major implementation successes over the years, One milestone that clearly stands out centers around the development of "Periscope" which he released through TUSC in 2002. Periscope is breakthrough software that makes data from other data sources (i.e., Microsoft Access, Sybase, SQL Server, DB2, Web Services, file systems, APIs, etc.) appear as if it's in one big Oracle Database. The data also can be inserted, updated and deleted from many source databases. The groundbreaking tool works with more than 100 databases.
* More Information on Brad.
Required: RSVP your attendance to Jon Wasserman: jsw@oswoug.org Breakfast is sponsored by Tek Systems.
General Meeting: February 2010
President and co-founder of TUSC
Three presentations.
How Oracle Won the Database World (1hr.)
Slides
Performance Tuning Oracle Grid: Parts I and II (50 minutes each)
Oracle Security Issues for DBA's will be presented by a DBA from TUSC.
(45 minutes and Q&A as time allows.)
Send correspondence in advance of the event to Jon Wasserman with requests for security topics to be covered by the experts from TUSC.
Rich Niemiec, 47, Rolta's President of International EICT (Enterprise Information & Communications Technology) and President of TUSC - A Rolta Company.
TUSC is a Chicago-based systems integrator of Oracle-based business solutions since 1988; TUSC was the Oracle Partner of the Year in 2002, 2004, 2007 & 2008.
Rolta is an international market leader in IT-based geospatial solutions, and caters to industries as diverse as infrastructure, telecom, electric, airports, defense, homeland security, urban development, town planning and environmental protection.
Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG).
Rich is one of six originally honored worldwide Oracle Certified Masters.
In 2007, he authored the Oracle bestseller "Oracle10g Performance Tuning Tips & Techniques," an update of his previous 2 Oracle best sellers on Oracle8i and Oracle9i Performance Tuning. Rich was inducted into the Entrepreneurship Hall of Fame in 1998.
* abbreviated BIO.
November 2009
Tek Systems discussed the current job market for Oracle professionals.
Anatole Schaff:
Business Process Analysis Suite
As business process management (BPM) expands beyond isolated projects to mainstream programs at the division or enterprise level, there is an increased need for collaboration between process analysts and IT. Oracle Business Process Analysis (BPA) Suite speeds process innovation by rapidly modeling business processes and converting them into IT executables. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This session will present how Oracle BPA Suite allows business users to design, model, simulate, and optimize business processes to achieve maximum operational efficiency and reduce the "strategy to execution" gap.
Oracle Data Integrator (45 minutes plus question and answer session)
A key component of Oracle Fusion Middleware, Oracle Data Integrator (ODI) delivers unique next-generation Extract Load and Transform (ELT) technology that improves performance and reduces data Integration costs, even across heterogeneous systems. ODI provides high-performance movement and transformation of data across heterogeneous systems (Oracle and non-Oracle) in batch, real- time, synchronous, and asynchronous modes. ODI offers the productivity of a declarative design approach, as well as the benefits of Knowledge Modules which encapsulate best practices in loading, transforming, or integrating data for a specific data source or target. Join this session to see how ODI can benefit your Data Warehouse, Application Integration, Master Data Management, or Modernization Migration project.
Anatole Schaff is a principal SOA/BPM solution specialist at Oracle in the areas of Business Process Management and Service Oriented Architecture. His technical expertise covers Oracle BPA Suite, Oracle SOA Suite, Application Integration Architecture and software development. Anatole has more than 10 years of experience in architecting and developing solutions with Oracle technologies. Prior to joining Oracle he was Enterprise Architect at Tektronix. Anatole holds a MS in Engineering and Technology Management from PSU.
Carol-Lee Tutch:
Accessing Hierarchical Data in Oracle (30 minutes plus question and answer session)
Bill of materials, parts explosion, or hierarchically structured data presents challenges for traditional SQL queries. The standard SQL methods for examining hierarchies will be illustrated and their shortcomings described. Oracle provides the CONNECT BY and START WITH clauses, along with several operators and psuedocolumns to greatly expand such querying. These SQL extensions will be examined, along with some of the advanced functions Oracle now provides. The talk will conclude by demonstrating a couple of surprising uses for Oracle's extensions.
Carol-Lee Tutch, began developing relational database solutions in the early 80's by creating a data warehouse and a cartographic metadata database for the Defense Mapping Agency. Her first major project in Oracle involved creating an order bill-of-materiels system for Westinghouse. She has designed database systems for the FBI, PBS, Emery Worldwide, PACE Manufacturing, New Edge Networks, and The Standard. She is currently on assignment, through VOLT, at The Standard.
February 2009
Maxina Parks Oracle Technical Sales Support
Enterprise Grid Management and Oracle 11g.
Tuesday, May 13, 2008
Karen Morton
Director, Consulting & Education
Method R Corporation
The Cary Millsap Company
Oracle continues to add more and more automated features and advisors (i.e. ADDM, AWR, ASSM, SQL Tuning Advisor, etc.). Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is "dumbing us down" or "smartening us up". Too often more automation can lead to using these features as a crutch and bypassing the acquisition of key skills and knowledge. Ideally, these features should be tools to help us do our jobs better instead of simply letting Oracle do it for us. The risk is becoming trained to only follow the advisors output, but when a situation arises where our skills and knowledge are needed, it's not there. This presentation looks at some of these automations and the knowledge and critical thinking skills needed by the DBA or Developer to understand and use them properly and effectively.
David Driscoll
Senior Systems Engineer
Pillar Data Systems
Smart Storage Devices designed specifically for Oracle Databases. Designed to work with all major storage hardware. This will be a deep dive into the workings of artificial intelligence for database storage.
Bill Slocumb
Oracle Corporation
Oracle Applications: The newest method for sizing the system.
February 12, 2008
David Alexander
Oracle Corporation
Paul Veilleux
Global Sales Director, Pillar Data Systems
Presentation
Simplifying the storage grid for Oracle 10g/11g Database
