Oracle ACE Director Björn Rost is the co-founder of portrix Systems, a service provider and consulting company focused on Oracle Technology, including servers, storage, Oracle Linux and Solaris to Real Application Cluster databases. He enjoys working with software developers to tightly integrate with existing Oracle features, oversees the operation operations for a number of cloud or SaaS platforms and consults on high availability, performance tuning and OS and DB management. He is passionate about sharing knowledge and is a regular speaker at user group conferences around the world with more than 42 presentations on five continents. He also serves as the president of IOUG's RAC special interest group.
Expertise: Working on how to get the best out of the database, linux/solaris and systems
Abstract 1: Setting up RAC to avoid application downtime
Real Application Clusters are not just about avoiding unplanned downtime. They also help a lot with planned maintenance like hardware and operating updates and rolling patches. With the right setup, administrators do not need to get up for maintenance windows in the middle of the night to apply patch sets anymore. Using the right planning and strategy, routine tasks can be dealt with while the database is up and running. This presentation walks through the proper setup of applications, implementation of services and shows how perform maintenance in such a way that applications and end users do not even notice.
We will also look at the new 12c feature Transaction Guard and Application Continuity and explain how they help to make client connections to RAC systems even more resilient.
Abstract 2: Developing applications for RAC and Exadata - what you need to know
It is often believed that applications will run fine without any changes on Cluster databases and engineered systems. But the reality for a lot of projects is that while things rarely break, the desired performance improvements from putting an app on a cluster database are rarely achieved and in addition a new class of problems pop up.
This presentations aims to give the proper information to developers so they can identify and work around potential for contention and problems. Even though transparent to the application, we will cover the basics of cache fusion and implications on application performance and workload management. The session will also cover the tradeoffs developers have to make when dealing with singleton objects like sequences in a clustered environment and how to set up and test load-balancing and failover from an application perspective.
Lastly, we will cover what can or needs to be done on the application side to make best use of features like Hybrid Columnar Compression and Smart Scans.
Abstract 3: Implementing Hard Partitioning technologies to stop over-licensing
Moore's law is giving us servers with ever-increasing throughput in terms of higher clock rates and cores per socket. If the database demands are not groing a lower rate, chances are that database servers (and as a result licensing costs) are becoming bigger than they need to be.
Consolidation and sub-server licensing are ways to avoid licensing idle cpu capacity.
This presentations introduces and explains the various ways that this can be achieved with Oracle VM, Solaris zones and LDOMs aswell as other technologies.
Demonstrations showcase simple setup scenarios that attendees can easily replicate.
Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies.
He is an author and popular speaker at many Oracle conferences around the world. He is also the President of CLOUG (Chilean Oracle Users Group), LAOUC (Latin American Oracle Users Group Community, which is the umbrella organization for all of Latin America), and NZOUG (New Zealand Oracle Users Group). He worked as an Associate Technologist for Oracle in Brazil and Chile. He was an Oracle instructor for the New Horizons Centre (Chile) and for Oracle Education (Brazil and Chile). He also worked in the first team to introduce Oracle to South America (Oracle 6 and the beta version of Oracle 7). He was also the first Master Oracle 7 Database Administrator in South America, as well as the first Latin American Oracle professional to be awarded a double ACE (ACE in 2008 and ACE Director in 2009) by Oracle HQ. In 2010, he had the privilege to receive a prestigious Oracle Magazine Editor's Choice Award as the Oracle Evangelist of the Year--a huge recognition for his outstanding achievements in the Oracle world that includes the creation and organization of the already famous OTN Tours that are the biggest Oracle evangelist events in the world.
Currently, Francisco works for Pythian, which is a global leader in data management consulting and services, as the Vice President for Asia Pacific. He also maintains an Oracle blog (http://www.oraclenz.org) and you can always contact him through this or Twitter (@fcomunoz) regarding any questions about Oracle.
Abstract 1: Don't be scare of auditors
This session will give some real life recommendations to ensure that you will have good results if your IT area is going to be audited by an external company such as PWC, KPMG and Deloitte as per example.
Most of this session will have tips to the Database side of the audit but it will also include general tips to the whole IT department.
Abstract 2: 12c Backup & Recovery – What is new?
Oracle Database 12c has introduced many new features and enhancements for Backup and Recovery, this presentation will introduce you to some of the most important ones and how they could be used in real life situations.
Of course, I cannot talk about 12c without talk first about a revolutionary whole new concept that was introduced with this new version of the database product, that is called, "Pluggable Database."
Abstract 3: Why use OVM for Oracle Database
Vibrant session about OVM, that will explain how, when and why use this product for Virtualization. It will also give an overview of how Revera is currently using this product in NZ (Biggest OVM Farm in the ANZ region) and show benchmark results between Bare Metal, OVM and ESX concluding with some tips and showing the scalability and break point of load of the Virtualization solutions.
Come and discover the answers for the following questions:
- Does an Oracle Database perform well on a virtualized environment?
- What virtualization technology is more stable and allows an Oracle database to perform faster?
- What is the performance difference between using a bare metal and a virtualized guest?
- Is it safe to run a production database in a virtualized environment?
Oracle ACE Director, Edward Roske is the cofounder/CEO of interRel Consulting and co-author of the bestselling series Look Smarter than You Are with Hyperion. Known for his dry wit and Oracle EPM/BI mastery, Oracle sends Roske around the globe to evangelize Oracle EPM/BI in the Americas, Europe, India and Asia. Though he was the first person ever to get a perfect score on the Essbase Certification exam, he is most proud of winning “Speaker of the Year” at Kscope13. Follow him on Twitter at @ERoske.
Expertise: Edward is one of the world's foremost experts on BI, EPM, Hyperion, Essbase, and OBIEE. He also has been evangelizing for big data for the last several years.
Abstract 1 Getting Value from Big Data with Analytics
The five top trends in technology right now are mobile, social, cloud, security, and big data and of all of those, the one that can add the most immediate business benefit is big data. Many discussions on big data center around "what does big data actually mean?" We will be talking about that (briefly) but we'll then get to a much more important question: how can I actually take big data and do something valuable with it? The secret is analytics: take big data and actually use it to drive business decisions. Using Oracle Business Analytics examples, we'll be showing that big data isn't all hype: there's value to your organization. Do you want to learn about big data and analytics? Then join us for this session.
Abstract 2: Everything You Wanted to Know About Oracle Hyperion 188.8.131.52 in 1 Hour or Less
This session will cover the new features available in Essbase, Planning, DRM, HFM, and HPCM from a real-world "how would I use that in my business?" perspective. In addition to covering some of the key product improvements in 184.108.40.206 and important integrations with OBIEE 220.127.116.11, we'll discuss the new applications in 18.104.22.168 including Financial Data Quality Management Enterprise Edition, Hyperion Tax Provisioning, and Hyperion Data Relationship Governance. By the end, you'll want to upgrade to 22.214.171.124.
Ronald Vargas Quesada
Ronald Vargas Quesada, ACED, First ACE & ACED America Central.
Consultant, University Professor, Oracle Academy Instructor, Oracle WDP Instructor & Speaker.
Ronald has over 25 years of Oracle DBA experience. He resides in Costa Rica and is responsible for the creation of the Central American Oracle Users Groups. He is an active participant on OracleMania, Comunidad Oracle Hispana and LAOUC and enjoys helping his peers to find solutions and answers on Oracle Technology. Ronald is also the director in technology for the LAOUC and University Professor in ULACIT y UCENFOTEC. Ronald was an Oracle University instructor from 2000-2007 and was recognized as one of the top 15 LAD instructors by Oracle University. He strives to keep his blog updated regularly and enjoys sharing his thoughts with the community at http://oracledbacr.blogspot.com,
Abstracto 1: La teoría del BIG BANG, Oracle Database optimización basada en costo. Optimización extrema de instrucciones SQL.
Un viaje a la profundo al optimizador de consultas de la base de datos. Como se ejecuta una sentencia SQL en una base de datos, como se determina su plan de ejecución, como influye el hard o soft parseo, la utilización de índices y el comportamiento de cursores. Áreas de memoria del SGA y acceso a disco.
Abstracto 2: Performance Tuning: How to write & run correctly
El 50% de las instrucciones SQL son más escritas y 9 de cada 10 se ejecutan de manera incorrecta. En esta charla conoceremos aspectos importantes que deben ser tomadas en consideración a la hora de construir y ejecutar nuestras instrucciones, funciones o procedimientos en una base de datos Oracle.
Abstracto 3: Ventajas y Beneficios de Oracle Database 12c, Multitenant Database for Cloud Environments and more, desde una Perspectiva de Seguridad ( 1.5 horas )
Se analiza las nuevas características que brinda la última versión del motor de la base de datos Oracle en materia de seguridad. Un vistazo rápido por cada una de las soluciones de seguridad de base de datos como Audit Vault & Database Firewall, Database Vault, Oracle Advanced Security Transparent Data Encryption, Data Masking y Disociación de Datos.
Kyle has worked on IT performance for over 20 years. He was a principle designer at Oracle on the Enterprise Manager performance monitoring interface which was implemented under waterfall methods. Following that he was the designer and product manager of DB Optimizer at Embarcadero using agile methodologies to deliver every version on schedule. Now he works at Delphix bringing agility to one of the biggest hurdles to application development efficiency which is managing large amounts of data when trying to implement agile practices and continuous integration to support rapid flow of features, from development to operations to the production. Kyle holds patents in the area of database performance and speaks around the world at conferences.
Expertise: performance, tuning, SQL, Enterprise Manager, data storage management
Abstract 1: Database performance tuning
45 minutes, 90 minutes or 3 hour workshop
How does one know what the load is on an Oracle database? How does one identify whether database idle or if there is a bottleneck? Using a single metric of Average Active Sessions (AAS) and a simple list of rules one can easily answer these questions. Using AAS one can both quickly identify issues and then harness active session history (ASH) and ASH Analytics in EM to dive deep in to the details to resolve even the most challenging problems.
Limits of AWR report for performance analysis
Solution to performance analysis with sampling
Sampling is used to build active session history (ASH)
ASH is the basis for average active sessions (AAS)
AAS visualized in EM and ASH analytics as well as with SQL queries
Examples of solving problems with AAS in EM
Examples of diving into ASH Analytics
Examples of querying ASH directly
Abstract 2: SQL performance tuning
Developers & DBAs
45 minutes, 90 minutes or 3 hour workshop
As a developer how does one know the impact of their SQL code on the system? How can the SQL load be verified and most importantly if the load of the SQL is high and/or SQL performance is slow, how can one tune the SQL? This presentation will show to identify high load SQL and most importantly how to analyze a SQL statement to identify bottlenecks and tune the SQL.
Analysis will go over :
1. getting the correct execution plan along with extended execution statistics and how to analyze the statistics and predicate details in the execution plan.
2. Cardinality : optimal execution plans are all about cardinality. We will go over how to get cardinality information in surprising, unique and powerful ways.
3 Visual SQL Tuning (VST) : VST is a method of laying out the tables and joins of a query graphically indicating key features of the query in the graphics. With VST, you'll learn how to quickly visualize any coding errors in the query, discover flaws in the underlying database schema, and most importantly, find the best execution path through the query
Abstract 3: Application Development performance tuning
Managers, CIO, developers, DBAs
45 minutes or 90 minutes
Databases pose a unique hurdle in the world of application development, DevOps and Continuous Delivery. Most applications depend on databases and databases tend to be large, complex and difficult to copy. Development, QA and deployment testing all require environments and if when those environments include large databases then provisioning those databases becomes the biggest constraint in the flow of features. to setting up these environments. This presentation will go over the impact of managing databases in development flow and the strategies to alleviate the constraints imposed by databases. What strategies does one use in dealing with databases? Are rollback scripts feasible? Are subsets sufficient? Can synthetic data suffice?
How long does it take a business analyst, developer or QA team to get a copy of production data ? What is the impact of the delays of getting data to the right place at the right time? How can we reduce this time and a reduce the resources required? We will explore what the impact the data constraint, find a solution to solve this constraint with and finally measure the improvements to the business by removing this data constraint.
Bruno Borges is Oracle’s Principal Product Manager responsible of Fusion Middleware, Java, and Cloud services, as well Developer Advocate for the Java platform and Oracle Cloud, and covers topics from Java Embedded to Java SE and JavaFX to Java EE. Bruno has more than 15 years of experience as a Java developer in several areas, from mobile to enterprise applications.
Expertise: Java and Cloud
Abstract 2: Cloud Services for Developers: What's inside Oracle Cloud for you?
Developers want to build cool stuff with cool stuff. What's cool about Oracle Cloud is that it brings great technologies, enterprise-ready, long-time proven, and ready for consumption, all combined together as a Platform as a Service. Learn what kind of data management technologies it offers, and how to access them from a wide range of Middleware and Java-based Cloud services. Learn how to manage your source codes and Git repositories in the Cloud with Continuous Integration and Delivery approaches, and how to plug all that from your preferred IDEs.
Abstract 3: Lambdas and Streams, Functional Programming in JDK 8
The significant new language feature in Java SE 8 is the introduction of Lambda expressions, a way of defining and using anonymous functions. On its own this provides a great way to simplify situations where we would typically use an inner class today. However, Java SE 8 also introduces a range of new classes in the standard libraries that are designed specifically to take advantage of Lambdas. These are primarily included in two new packages: java.util.stream and java.util.function. After a brief discussion of the syntax and use of Lambda expressions this session will focus on how to use Streams to greatly simplify the way bulk and aggregate operations are handled in Java. We will look at examples of how a more functional approach can be taken in Java using sources, intermediate operations and terminators. We will also discuss how this can lead to improvements in performance for many operations through the lazy evaluation of Streams and how code can easily be made parallel by changing the way the Stream is created.
Ricardo Gonzalez Acuña
Ricardo currently works as a PM and as Technology Evangelist for the RAC team in Oracle.
Prior to joining the Oracle RAC team, Ricardo worked for TimesTen as a Product Manager overseeing the LAD region. He holds a B.Sc in Computer Science from the Costa Rican Institute of Technology and a Master in Business Administration, focused on Entrepreneurship and Innovation from the Monterrey Institute of Technology in Mexico City. He has been with Oracle for the past four years and is very passionate about technology in general as well as Oracle technology in particular.
Abstract 1: Oracle RAC Operational Best Practices
Best practices for Oracle RAC categorized by use cases (Generic, Extended RAC, Dedicated and Consolidated Environments) as well as by areas (Storage, OS/Sever, Network, Cluster, and Database).
Anton is currently the Vice President Product Development at Dbvisit Software Limited. He has been working with Oracle database technology since Oracle version 7 and has successfully implemented many projects from small to large scale. He enjoys technical challenges. His areas of interest include Virtualization, Linux, Oracle Standby Databases, Backup and Recovery to name just a few. Anton is an Oracle Database 11g Certified Master and has presented at NZOUG and Collaborate. His other qualifications include Oracle 8i - 11g OCP as well as certifications in Solaris and Red Hat administration.
Extensive knowledge in Oracle Database, Linux, Disaster Recovery and Virtualization, including being Oracle 11g Certified Master. Presented at NZOUG, Collaborate 12 and 15 as well as DB Tech Showcase.
Abstract 1: Disaster Recovery as a Service (DRaaS) is at your doorstep – will you let it in?
Natural disasters are not something that should be taken lightly when talking about Disaster Recovery (DR), the impact on the business can be catastrophic. But there are many research studies showing that one of the reasons many companies experience interruptions or even data loss are caused by human error. The combination of hardware, software, and people operation is prone to failures and require contingencies in order to maintain the continuity of businesses.
There are options to protect your business against disaster, whether it is human, hardware or a natural disaster. Your company can invest in all of the components to establish a protected environment in-house – most of the time at a high level of customization and engineering requirements not to even mention the cost. Why not adopt a solution of DRaaS (Disaster Recovery as a Service) where all of the components of the solution have been already engineered together?
In this session we will review DRaaS; what is it? Things that should be considered as well as highlighting areas such as lower total cost of ownership, higher level of customer satisfaction and faster go to market - you can literally start protecting your business tomorrow.
Abstract 2: Can DRaaS help you protect your data?
Mention natural disasters and many might get a cold shiver going down their spine with just the thought of it – no need to even mention Storm Sandy and the Japan Tsunami. Guaranteeing the continuity of your business during a major natural disaster in itself is challenging, but even an operating system or database corruption may be a challenging proposition to take on. Establishing multiple datacenters - from installation, operation to interconnecting them, ensuring that your data is protected - can be challenging. Do you have individual Service Level Agreements (SLA)? Maybe you have 99.99% of availability for you servers, 99.83% for the datacenter, but 99.6% for your network? Why not review Disaster Recovery as a Service (DRaaS)? A DRaaS provider can give you a single SLA for everything from the network, datacenter, servers, operating system, DBA services, all the way through to the business continuity applications. While the DRaaS provider guarantees your peace of mind, you work with your business counterparts to develop sustainable competitive business advantages.
Abstract 3: Why Oracle Standard Edition Should Still Be on the Menu
Stop… and consider Standard Edition (SE). SE is sometimes the neglected smaller brother of Enterprise Edition (EE). Most focus on the new features available in the EE stack, but what about SE?
Some forget it is still the same core database. It can provide highly available solutions as well as help establish a robust DR environment. It is even possible to use Oracle RAC with SE, and combined with a standby database, you can implement a powerful solution. To top this all off, you gain the added advantage of lower licensing cost. Whether you are a small business or enterprise, SE may well suit your needs and as the cost saving can be substantial it is worth consideration.
Let’s go on a journey to look at why SE should still be on the menu looking at areas such as Migrating between editions as well as new Oracle 12c Features available in Oracle Standard Edition.
Roy Salazar Valverde
I'm a Senior Professional, working since year 1999 with Oracle Products and Technology, first 6 years as Consultant Developer and Systems Analyst, then last 8+ years as Oracle DBA / Database Consultant with intermittent roles as Team Leader, have both technical and non-technical skills. Really love to be an Oracle Expert and Oracle Fan.
Also aspirant to become Oracle ACE, these are my very first steps in that direction.
Abstract 1: Hangover - What happened yesterday ?
Would like to show the power and useful benefits for Troubleshooting with ASH Views (Active Session History), which are key for troubleshooting for an event in the past, mentioning key things as the fact that when using ASH is very important to count the results of queries for the events we are looking for, cause those views are based on snapshots, so to really figure out when some event was happening during certain period of time, the count for the range of time is the right way to see which event was really happening most.
Also, because this beautiful feature is only available for those with Enterprise Edition and Diagnostics Tuning Pack, Would like to show another option for the ones without EE..... there is out there an open source solution that's try to emulate the same functionality, for those without the luck of enough licenses and or running Standard Edition (Perhaps also an old Oracle version), would like to show about S-ASH Views to do same or pretty close same things as with ASH views.
Yenugula Venkata RaviKumar
Ravikumar YV has 16 years of experience in Banking, Financial Services and Insurance (BFSI) vertical and played various roles like Project Manager, Senior Database Architect and Production DBA Support for BFSI. Written Oracle Technology Network (OTN) articles on Oracle Exadata, Oracle RAC and Oracle Golden Gate in OTN-Spanish, OTN-Portuguese and OTN-English. Member of All India Oracle User Group (AIOUG) /Oracle Speaker /Exadata Consultant /Oracle Blogger /Frequent Contributor @OTN forums /DBA Mentor.
Co-Founder for OraWorld (http://www.oraworld-team.com)
Oracle Certified Master (OCM) from Oracle Corp since 2009.
Abstract 1: Benefits Of Engineered Systems
Predominant features from Oracle Exadata. Benefits to customers as well as Organizations.
Abstract 2: Oracle RAC 12c: An insight into Oracle Flex ASM and its benefits
Oracle Real Application Cluster (RAC) is a well-known product among Oracle‚ solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is constantly improving on every version and this time was not different. The new 126.96.36.199 version incorporates two properties called ‚Flex ASM‚ and ‚Flex Cluster‚ that gives support to the demand requirements on Cloud Computing oriented environments
Abstract 3: Oracle Golden Gate: An insight into Oracle Golden Gate and its benefits
Benefits from Oracle Golden Gate in Zero-Down Time, High Availability, Reporting from DR locations.
Con más de 20 años de experiencia como consultor y desarrollador en tecnologías Oracle, en la actualidad Eddie es un apasionado de la herramienta de desarrollo Oracle Application Express, a la que dedica la mayor parte de su tiempo, ya sea desarrollando, capacitando nuevos colegas en su uso o escribiendo acerca de esta en su blog Expertos Oracle Apex (cuando el tiempo lo permite). Eddie ha sido colaborador como “speaker” en las ediciones del 2013 y 2014 del OTN Tour LAD en Costa Rica, además de organizador y expositor del Oracle Apex Tour Latinoamérica del año 2013. En este 2015 además, es parte del grupo organizador del OTN Tour LAD en Costa Rica.
Abstract 1: Cosas por hacer en cada proyecto Apex
Cada desarrollador tiene sus preferencias a la hora de desarrollar, de la misma manera que los empresas definen estándares a aplicar en el proceso.
Es importante para todo desarrollador conocer las cosas que otros de sus colegas hacen para facilitar y mejorar el proceso de desarrollo, de manera que pueda tomar para si aquellas cosas que le parezcan importantes y que pueden ayudar a mejorar su metodología de trabajo.
Esta sesión se basa en las cosas que el expositor normalmente ejecuta al desarrollar cualquier aplicación, haciéndolo de manera demostrativa, de manera que al salir de la sesión los asistentes puedan llevarse “cosas” que puedan poner en práctica en sus propios proyectos.
Abstract 2: Poniendo en práctica en desarrollo de equipos de Apex
Oracle Application Express es una herramienta tan versátil, que permite a los administradores de proyectos de desarrollo, aun cuando este no sea en Apex, llevar el control del trabajo de su equipo, con una de sus funcionalidades menos utilizada, el “Desarrollo de Equipos”.
En esta sesión los asistentes conocerá las características de esta funcionalidad proporcionada por Apex, además de cómo integrarla dentro del proceso de desarrollo de aplicaciones Apex para facilitar el proceso de control de las etapas de desarrollo y mantenimiento de las aplicaciones.
Abstract 3: Principios de construcción de aplicaciones móviles con Apex
Con el uso de generalizado de dispositivos móviles (tabletas, teléfonos inteligentes, etc.) se hace trascendental el dominio del desarrollo de este tipo de aplicaciones. Con el uso de Oracle Application Express, el proceso de creación y desarrollo de aplicaciones móbiles se convierte en una tarea muy sencilla.
Los asistentes a esta sesión tendrán la oportunidad de observar el proceso de desarrollo de una aplicación móvil, así como conocer las principales características que provee Apex para el desarrollo de la misma.