Pythian at UKOUG: Wednesday December 8

Posted in: Technical Track

For the final day of UKOUG there are quite a few Pythian presentations. Unfortunately a lot of them happen at the same time, so it won’t be possible to attend them all live.

Using Oracle GoldenGate to Minimize Database Upgrade Risk

10:10, Media Suite
Marc Fielding

Even the best-planned database upgrades can leave nagging questions: what happens if my upgraded system performs unexpectedly? Is there a way I can go back to the previous version without downtime and data loss? Oracle GoldenGate allows DBAs to give affirmative answers to these questions. Drawing on upgrade experiences ranging from mid-sized databases to a large 10TB 90-CPU OLTP system, this session will show how to optimally configure Oracle GoldenGate, minimize downtime, maximize replication performance, and integrate Oracle GoldenGate into existing infrastructure such as Oracle ASM and storage-based replication.

Learn the various deployment scenarios where GoldenGate can minimize upgrade risk and delivery business value. Find out how GoldenGate can help not only during the upgrade, but after the upgrade as well. Learn how to use GoldenGate in medium- and high-volume environments. See real-world, tested GoldenGate configurations. Find out lessons learned and pitfalls to avoid.

The Answer to Free Memory Swap and Everything

10:10, Hall 8A
Christo Kutrovsky

Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in detail the different types of memory, how to monitor memory, and how to optimally use it with Oracle. Multiple examples in the presentation demonstrate how certain actions on the database side cause different memory areas to be allocated and used on the OS side. Key underlying differences in operating systems approaches to managing memory will be highlighted, with special attention given to Linux and Solaris. Using Linux as an example throughout, this presentation explains how to effectively use tools such as “top”, “vmstat” and “/proc/meminfo” to look into into a system’s allocation and use of memory.

Amazon RDS, EC2 and S3 for Oracle Databases

11:20am, Hall 10B
Alex Gorbachev

This technical session focuses on specific recommendations and guidelines for leveraging the Amazon Web Services platform to host Oracle databases. We will looks into traditional database hosting using EC2 platform as well as recently introduced Amazon RDS on Oracle. We will look into how to configure, provision, backup, restore, monitor, and secure your databases in AWS. We will also look on how you can leverage S3 cloud storage for hybrid cloud deployments, particularly for backup and archival storage.

Backup and Recovery Roundtable

11:20am, Roundtable Area
Michael Abbey

A discussion of backup and recovery technology, problems and solutions. We will poll the attendees for an agenda on the day and proceed with an informal discussion not limited to:

RMAN, OSB, Sans, Data Guard backups, RAC backups and other topics of interest.

Concurrent Processing Performance Analysis for Apps DBAs

2:25pm, Hall 10B
Maris Elsins

Concurrent processing is one of the key elements of Oracle E-Business Suite, that’s used by most of modules for scheduling and processing background jobs. Keeping this functionality healthy is important to get maximum performance out of it. The paper describes the key metrics to estimate the performance of the concurrent managers, discusses approaches and techniques that can be used to understand how well the concurrent processing is set up, what are the bottlenecks and delays in processing of concurrent requests and provides tips on how to deal with each of the identified problem. This paper is targeted for Oracle Applications DBAs and technical consultants.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

Marc is a passionate and creative problem solver, drawing on deep understanding of the full enterprise application stack to identify the root cause of problems and to deploy sustainable solutions. Marc has a strong background in performance tuning and high availability, developing many of the tools and processes used to monitor and manage critical production databases at Pythian. He is proud to be the very first DataStax Platinum Certified Administrator for Apache Cassandra.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *