Tag: Database & Technology

This session covers migration from any other platform to System z. Also covered are adjustments on the Linux box for best performance and changes to the source system which will ensure a smooth migration

In this seminar I will teach a holistic approach to Oracle tuning involving design, implementation and the physical creation of the database and its environment. The proper use of Oracle structures and features, proper use of indexing and proper use of new technology such as flash cache and SSD will be covered.

The speaker will principally be addressing and sharing direct experience on Linux on System Z with customers: "The more I share what we know - the fewer SRs I get" An update on the OSDI (Operating System Dependent Interface) for Oracle on z/OS will also be included.

If you enjoy solving a difficult technical puzzle, then working on a system plagued by free buffer waits should get your adrenaline pumping! The free buffer waits event is intriguing because it takes a combination of database writer, IO subsystem, SQL, buffer cache configuration, and server process activity to manifest. Understanding this wait event is fascinating because it touches the very deepest parts of the Oracle architecture; the least recently used lists, the dirty lists, how blocks are brought into the buffer cache, and buffer "movement." Fortunately, with so many causes to this problem there are also many solutions. This presentation focuses squarely on resolving free buffer waits by focusing on Oracle buffer cache internals, diagnosis using Oracle's wait interface, and solution development focusing on tweaking Oracle, the application (including the SQL), and the IO subsystem. This is a very practical yet deep internal presentation, filled with amazing discoveries about how Oracle works.

This session will showcase a real world case study involving both Hyperion / Essbase and Oracle Business Intelligence Applications (OBIA). Here we will look at leveraging the best of both the platforms to take advantage of Multidimensional capabilities of Essbase and pre-built data warehousing and BI capabilities of OBIA. We will look at the scenario…

The new 11g version of Oracle Business Intelligence (OBIEE) has added many new OLAP features. One of the most significant features includes dynamic mapping of multidimensional data sources. In the past administrators needed to manually map Oracle OLAP and Essbase sources to the BI Server catalog. Then alot of special adjustments had to be made…

New in Oracle Database 11gR2, the "recursive common table expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members" followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list…

Oracle Data Guard can be an integral part of a disaster recovery plan and can be used to protect against planned and unplanned downtimes. Data Guard standby databases can also be used to support production functions such as reporting, querying, and testing, while in a standby role. This presentation will discuss Oracle Data Guard architecture.…

In this RAC Bootcamp presentation, we will at the considerations and procedures for optimizing database and application performance in a RAC environment. Starting with a deeper understanding of some of the background processes, we will progress to RAC related wait events and what they mean. Armed with this information, we will look at RAC specific…

Session discusses Oracle VM's capabilities, Creating Software Templates, Automation of Oracle Installs and Patches in VM Environments, integration with EM Grid Control, Administration using Oracle VM Manager, OCFS2 Cluster configuration, Server Pools & Live Migration, ASM Configuration in Guest Machines, Monitoring & Alerting, Implementation Specifics and Lessons learned during implementation.